public void SaveNewContactToRepository()
{
// arrange
// note connection string is in app.config
Contact con = new Contact();
ContactsDb db = new ContactsDb();
con.fname = "Adam";
con.lname = "VandenElzen";
con.phone = "867-5309";
db.Contacts.AddObject(con);
// act
db.SaveChanges();
// Assert -- see if the record retreived from the database matches the one i just added
Contact savedContact = (from d in db.Contacts where d.id == con.id select d).Single();
Assert.AreEqual(savedContact.fname, con.fname);
Assert.AreEqual(savedContact.lname, con.lname);
Assert.AreEqual(savedContact.phone, con.phone);
// cleanup
db.Contacts.DeleteObject(con);
}
protected void Button1_Click(object sender, EventArgs e)
{
int idToupdate = Convert.ToInt32(Request.QueryString["id"].ToString());
ContactsDb db = new ContactsDb();
Contact con = db.Contacts.SingleOrDefault(p => p.id == idToupdate);
con.phone = TextBox1.Text;
db.SaveChanges();
Label4.Text = "Contact updated Successfully";
}
protected void Button3_Click(object sender, EventArgs e)
{
if (CheckBox1.Checked == true)
{
//delete this contact
int idToupdate = Convert.ToInt32(Request.QueryString["id"].ToString());
ContactsDb db = new ContactsDb();
Contact con = db.Contacts.SingleOrDefault(p => p.id == idToupdate);
db.Contacts.DeleteObject(con);
db.SaveChanges();
Response.Redirect("default.aspx");
}
return;
}
protected void Button1_Click(object sender, EventArgs e)
{
if (TextBox1.Text == string.Empty ||
TextBox2.Text == string.Empty ||
TextBox3.Text == string.Empty)
{
Label1.Text = "Please enter proper details first";
return;
}
Contact con = new Contact();
con.fname = TextBox1.Text;
con.lname = TextBox2.Text;
con.phone = TextBox3.Text;
ContactsDb db = new ContactsDb();
db.Contacts.AddObject(con);
if (db.SaveChanges() == 1)
{
Label1.Text = "Contact added Successfully";
}
}
