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");
}
}
