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>");
}
public void onRowDelete(object sender, GridViewDeleteEventArgs e)
{
int id = Convert.ToInt32(grid_user.DataKeys[e.RowIndex].Values[0]);
user u = db.users.FirstOrDefault(x => x.uid == id);
db.users.DeleteOnSubmit(u);
db.SubmitChanges();
Page_Load(sender, e);
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
Exapance_DB ex = new Exapance_DB
{
type_of_expance = txtex.Text,
amount = Convert.ToInt32(txtamount.Text),
message = txtmsg.Text,
Log = "Entry Added by -" + Session["unm"],
Date = Convert.ToDateTime(DateTime.Today.ToString("MM-dd-yyyy"))
};
db.Exapance_DBs.InsertOnSubmit(ex);
db.SubmitChanges();
txtamount.Text = "";
txtex.Text = "";
txtmsg.Text = "";
Page_Load(sender, e);
}
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");
}
}
