protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { int Cid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value); CalendarIB c = db.CalendarIBs.Single(casl => casl.id == Cid); db.CalendarIBs.DeleteOnSubmit(c); db.SubmitChanges(); FillGridview1(); lblMsg.Text = " Successfully Deleted "; } catch (Exception E) { lblMsg.Text = "System error when adding , please advise Webmaster." + E.Message; } }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { int Cid = Convert.ToInt16(GridView1.DataKeys[e.RowIndex].Value); CalendarIB c = db.CalendarIBs.Single(cals => cals.id == Cid); c.IBEVent = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox1")).Text; string Cdate = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox2")).Text; //c.IBDate = Cdate; db.SubmitChanges(); GridView1.EditIndex = -1; FillGridview1(); lblMsg.Text = " Successfully Updated "; } catch (Exception E) { lblMsg.Text = "System error when updating , please advise Webmaster." + E.Message; } }
private bool UpdateCalendarTable(DateTime date1, DateTime date2, string Desc) { bool val = false; try { IBHhsDataContext db = new IBHhsDataContext(); //IBCalendarDataContext db = new IBCalendarDataContext(); y DateTime dt = date1; CalendarIB newEntry = new CalendarIB(); //add 1st day //IB_Calendar newEntry = new IB_Calendar(); y newEntry.IBEVent = Desc; newEntry.IBDate = dt; //db.IB_Calendars.InsertOnSubmit(newEntry); y comment db.CalendarIBs.InsertOnSubmit(newEntry); //add repeating days if (date2 != date1) { TimeSpan ts = date2 - date1; int diffDays = ts.Days; for (int i = 1; i < diffDays + 1; i++) { dt = date1.AddDays(i); newEntry = new CalendarIB(); newEntry.IBEVent = Desc; newEntry.IBDate = dt; db.CalendarIBs.InsertOnSubmit(newEntry); } } db.SubmitChanges(); val = true; } catch (Exception e) { val = false; lblMsg.Text = "System error when adding this student, please advise Webmaster." + e.Message; } return(val); }