First Drag the tables onto the LINQ Designer
Here is the Source code with the validation
<%@ Page Language="C#" AutoEventWireup="true"
CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0
Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<p>
<asp:Label ID="Label1" runat="server" Text="Enter First Name"></asp:Label>
<asp:TextBox ID="txtFirstname" runat="server"></asp:TextBox> <br />
<asp:Label ID="Label2" runat="server" Text="Enter Last Name"></asp:Label>
<asp:TextBox ID="txtLastName" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ControlToValidate="txtLastName" Display="None"
ErrorMessage="Last Name is required"></asp:RequiredFieldValidator>
<br />
<asp:Label ID="Label3" runat="server" Text="Enter Street Address"></asp:Label>
<asp:TextBox ID="txtStreet" runat="server"></asp:TextBox> <br />
<asp:Label ID="Label5" runat="server" Text="Enter City"></asp:Label>
<asp:TextBox ID="txtCity" runat="server"></asp:TextBox> <br />
<asp:Label ID="Label4" runat="server" Text="Enter State (2 Characters) "></asp:Label>
<asp:TextBox ID="txtState" runat="server"></asp:TextBox> <br />
<asp:Label ID="Label6" runat="server" Text="Enter Zip Code"></asp:Label>
<asp:TextBox ID="txtZip" runat="server"></asp:TextBox>
<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server"
ControlToValidate="txtZip" Display="None" ErrorMessage="Invalid Zip Code"
ValidationExpression="\d{5}(-\d{4})?"></asp:RegularExpressionValidator>
<br />
<asp:Label ID="Label7" runat="server" Text="Enter Home Phone"></asp:Label>
<asp:TextBox ID="txtPhone" runat="server"></asp:TextBox> <br />
<asp:Label ID="Label8" runat="server" Text="Enter Email"></asp:Label>
<asp:TextBox ID="txtEmail" runat="server"></asp:TextBox>
<asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server"
ControlToValidate="txtEmail" Display="None" ErrorMessage="Invalid email"
ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*">
</asp:RegularExpressionValidator>
<br />
<asp:Label ID="Label9" runat="server" Text="Enter Donation Amount"></asp:Label>
<asp:TextBox ID="txtDonation" runat="server"></asp:TextBox>
<asp:CompareValidator ID="CompareValidator1" runat="server"
ControlToValidate="txtDonation" Display="None"
ErrorMessage="Enter a valid Donation" Operator="DataTypeCheck"
Type="Currency"></asp:CompareValidator>
<br />
<asp:Button ID="btnDonation" runat="server" Text="EnterDonation"
onclick="btnDonation_Click" />
</p>
</div>
<asp:ValidationSummary ID="ValidationSummary1" runat="server" />
</form>
</body>
</html>
Here is the LINQ code
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 btnDonation_Click(object sender, EventArgs e)
{
DonorDataContext dc = new DonorDataContext();
Person p = new Person();
p.LastName = txtLastName.Text;
p.FirstName = txtFirstname.Text;
dc.Persons.InsertOnSubmit(p);
PersonAddress pa = new PersonAddress();
pa.Person= p;
pa.Street = txtStreet.Text;
pa.City = txtCity.Text;
pa.State = txtState.Text;
pa.Zip = txtZip.Text;
dc.PersonAddresses.InsertOnSubmit(pa);
PersonContact pc = new PersonContact();
pc.Person = p;
pc.ContactTypeKey = 1;
pc.ContactInfo = txtPhone.Text;
dc.PersonContacts.InsertOnSubmit(pc);
PersonContact pc2 = new PersonContact();
pc2.Person = p;
pc2.ContactTypeKey =6;
pc2.ContactInfo = txtEmail.Text;
dc.PersonContacts.InsertOnSubmit(pc2);
Donation d = new Donation();
d.Person = p;
d.DonationDate = DateTime.Now;
d.DonationAmount = decimal.Parse(txtDonation.Text);
dc.Donations.InsertOnSubmit(d);
dc.SubmitChanges();
}
}
No comments:
Post a Comment