protected void Page_Load(object sender, EventArgs e) { lingtophonebookDataContext db = new lingtophonebookDataContext(); GridView1.DataSource = db.tblphones.ToList(); GridView1.DataBind(); }
protected void btndelete_Click(object sender, EventArgs e) { lingtophonebookDataContext db = new lingtophonebookDataContext(); tblphone _phone = db.tblphones.SingleOrDefault(c => c.Id.ToString() == txtid.Text); db.tblphones.DeleteOnSubmit(_phone); db.SubmitChanges(); GridView1.DataSource = db.tblphones.ToList(); GridView1.DataBind(); txtid.Text = null; txtname.Text = txtfamily.Text = txtmobile.Text = txtphonenumber.Text = ""; }
protected void btndelete_Click(object sender, EventArgs e) { lingtophonebookDataContext db = new lingtophonebookDataContext(); phone _phone = db.phones.SingleOrDefault(c => c.Id == id); db.phones.DeleteOnSubmit(_phone); db.SubmitChanges(); grdContent.DataSource = db.phones.Where(c => c.userid == Login.iduser).ToList(); grdContent.DataBind(); txtid.Text = null; txtname.Text = txtfamily.Text = txtmobile.Text = txtphonenumber.Text = ""; }
protected void grdContent_RowDeleting(object sender, GridViewDeleteEventArgs e) { lingtophonebookDataContext db = new lingtophonebookDataContext(); phone _phone = db.phones.SingleOrDefault(c => c.Id.ToString() == grdContent.Rows[e.RowIndex].Cells[0].Text); db.phones.DeleteOnSubmit(_phone); db.SubmitChanges(); grdContent.DataSource = db.phones.Where(c => c.userid == Login.iduser).ToList(); grdContent.DataBind(); txtid.Text = null; txtname.Text = txtfamily.Text = txtmobile.Text = txtphonenumber.Text = ""; }
protected void Button1_Click(object sender, EventArgs e) { lingtophonebookDataContext db = new lingtophonebookDataContext(); var q = db.Users.SingleOrDefault(c => c.username == txtusername.Text && c.password == txtpassword.Text); if (q == null) { return; } iduser = q.Id; user = q.username; Response.Redirect("phonepage.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (Login.iduser == 0) { Response.Redirect("Login.aspx"); } lbluser.InnerText = Login.user; lingtophonebookDataContext db = new lingtophonebookDataContext(); grdContent.DataSource = db.phones.Where(c => c.userid == Login.iduser).ToList(); grdContent.DataBind(); }
protected void grdContent_SelectedIndexChanged(object sender, EventArgs e) { lingtophonebookDataContext db = new lingtophonebookDataContext(); phone _phone = db.phones.SingleOrDefault(c => c.Id.ToString() == grdContent.SelectedRow.Cells[0].Text); id = _phone.Id; txtname.Text = _phone.name; txtfamily.Text = _phone.family; txtmobile.Text = _phone.mobile; txtphonenumber.Text = _phone.phonenumber; // grdContent.DataSource = db.phone.Where(c => c.Id.ToString() == txtid.Text).ToList(); // grdContent.DataBind(); }
protected void btnsearchid_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(txtid.Text)) { return; } lingtophonebookDataContext db = new lingtophonebookDataContext(); tblphone _phone = db.tblphones.SingleOrDefault(c => c.Id.ToString() == txtid.Text); txtname.Text = _phone.name; txtfamily.Text = _phone.family; txtmobile.Text = _phone.mobile; txtphonenumber.Text = _phone.phonenumber; GridView1.DataSource = db.tblphones.Where(c => c.Id.ToString() == txtid.Text).ToList(); GridView1.DataBind(); }
protected void btnsave_Click(object sender, EventArgs e) { lingtophonebookDataContext db = new lingtophonebookDataContext(); tblphone _phone = new tblphone(); _phone.name = txtname.Text; _phone.family = txtfamily.Text; _phone.mobile = txtmobile.Text; _phone.phonenumber = txtphonenumber.Text; db.tblphones.InsertOnSubmit(_phone); db.SubmitChanges(); GridView1.DataSource = db.tblphones.ToList(); GridView1.DataBind(); txtid.Text = null; txtname.Text = txtfamily.Text = txtmobile.Text = txtphonenumber.Text = ""; }
protected void btnsearch_Click(object sender, EventArgs e) { lingtophonebookDataContext db = new lingtophonebookDataContext(); if (string.IsNullOrWhiteSpace(txtsearch.Text)) { Page_Load(null, null); } GridView1.DataSource = db.tblphones.Where(c => c.name.Contains(txtsearch.Text) || c.family.Contains(txtsearch.Text) || c.mobile.Contains(txtsearch.Text) || c.phonenumber.Contains(txtsearch.Text)).ToList(); GridView1.DataBind(); txtid.Text = null; txtname.Text = txtfamily.Text = txtmobile.Text = txtphonenumber.Text = ""; }
protected void btnsearchid_Click(object sender, EventArgs e) { lingtophonebookDataContext db = new lingtophonebookDataContext(); if (string.IsNullOrWhiteSpace(txtid.Text)) { Page_Load(null, null); return; } grdContent.DataSource = db.phones.Where(c => ( c.name.Contains(txtid.Text) || c.family.Contains(txtid.Text) || c.mobile.Contains(txtid.Text) || c.phonenumber.Contains(txtid.Text)) && c.userid == Login.iduser).ToList(); grdContent.DataBind(); txtid.Text = null; txtname.Text = txtfamily.Text = txtmobile.Text = txtphonenumber.Text = ""; }
protected void btnsave_Click(object sender, EventArgs e) { lingtophonebookDataContext db = new lingtophonebookDataContext(); phone _phone = new phone(); _phone.name = txtname.Text; _phone.family = txtfamily.Text; _phone.mobile = txtmobile.Text; _phone.phonenumber = txtphonenumber.Text; _phone.userid = Login.iduser; db.phones.InsertOnSubmit(_phone); db.SubmitChanges(); grdContent.DataSource = db.phones.Where(c => c.userid == Login.iduser).ToList(); grdContent.DataBind(); txtid.Text = null; txtname.Text = txtfamily.Text = txtmobile.Text = txtphonenumber.Text = ""; }
protected void btnsaveuser_Click(object sender, EventArgs e) { try { if (string.IsNullOrWhiteSpace(txtusernamesave.Value) || string.IsNullOrWhiteSpace(txtpasswordsave.Value)) { return; } lingtophonebookDataContext db = new lingtophonebookDataContext(); User _user = new User(); _user.username = txtusernamesave.Value; _user.password = txtpasswordsave.Value; _user.email = txtemail.Value; db.Users.InsertOnSubmit(_user); db.SubmitChanges(); txtusernamesave.Value = txtpasswordsave.Value = txtemail.Value = ""; } catch (Exception) { throw; } }