public void onRowDelete(object sender, GridViewDeleteEventArgs e)
{
int id = Convert.ToInt32(grid_expance.DataKeys[e.RowIndex].Values[0].ToString());
Exapance_DB ex = db.Exapance_DBs.SingleOrDefault(s => s.ID == id);
db.Exapance_DBs.DeleteOnSubmit(ex);
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);
}
public void onRowUpdate(object sender, GridViewUpdateEventArgs e)
{
RequiredFieldValidator1.Enabled = false;
RequiredFieldValidator2.Enabled = false;
RequiredFieldValidator3.Enabled = false;
GridViewRow row = grid_expance.Rows[e.RowIndex];
int id = Convert.ToInt32(grid_expance.DataKeys[e.RowIndex].Values[0]);
string type_exp = (row.FindControl("txttype") as TextBox).Text;
int amount = Convert.ToInt32((row.FindControl("txtamt") as TextBox).Text);
string message = (row.FindControl("txtmsg") as TextBox).Text;
string log = (row.FindControl("txtlog") as TextBox).Text;
Exapance_DB ee = db.Exapance_DBs.SingleOrDefault(x => x.ID == id);
ee.type_of_expance = type_exp;
ee.amount = amount;
ee.message = message;
ee.Log = log;
db.SubmitChanges();
UpdateExpance();
}
partial void DeleteExapance_DB(Exapance_DB instance);
partial void UpdateExapance_DB(Exapance_DB instance);
partial void InsertExapance_DB(Exapance_DB instance);
