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