protected void LinqDataSource1_Inserted(object sender, LinqDataSourceStatusEventArgs e)
{
PersonInfo p = e.Result as PersonInfo;
if (p.SpouseID != null && p.SpouseID != 0)
{
try
{
//Updating SpouseID after submit
using (MyFamilyDatabaseDataContext db = new MyFamilyDatabaseDataContext())
{
PersonInfo spouse = db.PersonInfos.Where(sp => sp.PersonID == p.SpouseID).FirstOrDefault();
spouse.SpouseID = p.PersonID;
db.SubmitChanges();
}
}
catch (Exception)
{
//Eat any exception
}
}
ExtMethods.SendAddEmail(p);
Response.Redirect("./PersonInfo.aspx?PersonID=" + p.PersonID);
}
protected void Button1_Click(object sender, EventArgs e)
{
PopulatePersonInfo();
if (_PersonInfo != null)
{
_db.PersonInfos.DeleteOnSubmit(_PersonInfo);
try
{
_db.SubmitChanges();
Response.Write("Deleted PersonInfo");
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
else
{
Response.Write("_PersonInfo is null");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtOccupation.Text))
{
Response.Write("Occupation can't be empty");
return;
}
try
{
using (MyFamilyDatabaseDataContext db = new MyFamilyDatabaseDataContext())
{
Occupation occupation = new Occupation();
occupation.OccupationDesc = txtOccupation.Text;
db.Occupations.InsertOnSubmit(occupation);
db.SubmitChanges();
Response.Write("New occupation inserted");
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}