First we did the wizard to get all the products. Here is the source code for Default.aspx<>p>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<h1>Our Products</h1>
<asp:DataList ID="DataList1" runat="server" CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333">
<AlternatingItemStyle BackColor="White" />
<FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<ItemStyle BackColor="#E3EAEB" />
<ItemTemplate>
<strong>
<asp:Label ID="ProductNameLabel" runat="server" Text='<%# Eval("ProductName") %>' /></strong>
<br />
$
<asp:Label ID="ProductUnitPriceLabel" runat="server" Text='<%# Eval("ProductUnitPrice") %>' />
<br />
</ItemTemplate>
<SelectedItemStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
</asp:DataList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:PerfectPizzaConnectionString %>" SelectCommand="SELECT [ProductName], cast([ProductUnitPrice] as decimal(5,2)) as [ProductUnitPrice] FROM [Product] ORDER BY [ProductName]"></asp:SqlDataSource>
</div>
<p>Enter your phone number to order or register if you are a new customer <asp:TextBox ID="txtPhone" runat="server"></asp:TextBox><br />
<asp:Button ID="Button1" runat="server" Text="Submit" OnClick="Button1_Click" />
</p>
<asp:LinkButton ID="LinkButton1" runat="server">Register</asp:LinkButton>
</form>
</body>
</html>
Here is the code behind which checks to see if the phone number matches
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
PerfectPizzaEntities pe = new PerfectPizzaEntities();
var ph = from p in pe.Customers
where p.CustomerPhoneKey.Equals(txtPhone.Text)
select p.CustomerPhoneKey;
if (ph.ToList().Count != 0)
Response.Redirect("Default3.aspx");
else
Response.Redirect("Default4.aspx");
}
}
Here is the form for entering a new customer
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default4.aspx.cs" Inherits="Default4" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<h1>Register</h1>
<table>
<tr>
<td>Enter phone</td>
<td>
<asp:TextBox ID="txtPhone" runat="server"></asp:TextBox> </td>
</tr>
<tr>
<td>Last Name</td>
<td>
<asp:TextBox ID="txtLastName" runat="server"></asp:TextBox> </td>
</tr>
<tr>
<td>Address1</td>
<td>
<asp:TextBox ID="txtAddress1" runat="server"></asp:TextBox> </td>
</tr>
<tr>
<td>Address2</td>
<td>
<asp:TextBox ID="txtAddress2" runat="server"></asp:TextBox> </td>
</tr>
<tr>
<td>City</td>
<td>
<asp:TextBox ID="txtCity" runat="server"></asp:TextBox> </td>
</tr>
<tr>
<td>State</td>
<td>
<asp:TextBox ID="txtState" runat="server"></asp:TextBox> </td>
</tr>
<tr>
<td>Zip Code</td>
<td>
<asp:TextBox ID="txtZip" runat="server"></asp:TextBox> </td>
</tr>
<tr>
<td>
<asp:Button ID="Button1" runat="server" Text="Submit" OnClick="Button1_Click" /></td>
<td>
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label> </td>
</tr>
</table>
</div>
</form>
</body>
</html>
And here is the code behind
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Default4 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
PerfectPizzaEntities pe = new PerfectPizzaEntities();
Customer c = new Customer();
c.CustomerPhoneKey = txtPhone.Text;
c.CustomerLastName = txtLastName.Text;
c.CustomerAddress1 = txtAddress1.Text;
c.CustomerAddress2 = txtAddress2.Text;
c.CustomerCity = txtCity.Text;
c.CustomerState = txtState.Text;
c.CustomerZip = txtZip.Text;
pe.Customers.Add(c);
pe.SaveChanges();
Response.Redirect("Default2.aspx");
}
}
