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";
}
public void ContactsRepositoryContainsData()
{
// arrange
// note connection string is in app.config
ContactsDb db = new ContactsDb();
// act -- go get the first record
Contact savedContact = (from d in db.Contacts where d.id == 1 select d).Single();
// assert
Assert.AreEqual(savedContact.id, 1);
}
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 Page_Load(object sender, EventArgs e)
{
if (IsPostBack == false)
{
if (Request.QueryString["id"] == null)
{
Response.Redirect("default.aspx");
}
int idToupdate = Convert.ToInt32(Request.QueryString["id"].ToString());
ContactsDb db = new ContactsDb();
Contact con = db.Contacts.SingleOrDefault(p => p.id == idToupdate);
Label1.Text = con.id.ToString();
Label2.Text = con.fname;
Label3.Text = con.lname;
TextBox1.Text = con.phone;
Session["updatingContact"] = con;
}
}
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";
}
}
protected void Page_Load(object sender, EventArgs e)
{
ContactsDb db = new ContactsDb();
Repeater1.DataSource = db.Contacts;
Repeater1.DataBind();
}
