public void Insert(object sender, EventArgs e) { DBADataContext db = new DBADataContext(); user u = new user { username = textunm.Text, firstname = textfnm.Text, lastname = textlnm.Text, mobile_no = textmob.Text, email_id = textemail.Text, password = textpass.Text, user_type = listut.Text }; db.users.InsertOnSubmit(u); db.SubmitChanges(); updateUser(); textunm.Text = ""; textfnm.Text = ""; textlnm.Text = ""; textmob.Text = ""; textemail.Text = ""; textpass.Text = ""; Response.Write("<script>alert('Record insert Success');</script>"); }
protected void Page_Load(object sender, EventArgs e) { updateUser(); if (Request.QueryString.Get("edit") != null) { DBADataContext db = new DBADataContext(); } }
public bool CheckEmail(string email) { DBADataContext dbb = new DBADataContext(); user u = dbb.users.FirstOrDefault(eb => eb.email_id.Equals(email) || eb.mobile_no.Equals(email)); if (u != null) { return(true); } else { return(false); } }
protected void Page_Load(object sender, EventArgs e) { int id = Convert.ToInt16(Request.QueryString.Get("id").Trim()); DBADataContext db = new DBADataContext(); user u = db.users.FirstOrDefault(x => x.uid == id); //var use = from d in db.users where d.uid == id select d; if (u != null) { db.users.DeleteOnSubmit(u); db.SubmitChanges(); Response.Write("Delete Success"); } else { Response.Write("Not deleted Data"); } }