private bool AddStudent()
{
bool val = true;
IBHhsDataContext db = new IBHhsDataContext();
try
{
StudentIB newst = new StudentIB();
newst.LastName = txtLastName.Text.Trim();
newst.FirstName = txtFirstName.Text.Trim();
newst.Address = txtAddress.Text.Trim();
newst.City = txtCity.Text.Trim();
newst.ZipCode = txtZipcode.Text.Trim();
newst.Phone1 = txtPhone1.Text.Trim();
newst.Phone2 = txtPhone2.Text.Trim();
newst.Email = txtEmail.Text.Trim();
newst.Parents = txtParent.Text.Trim();
newst.ParentEmail1 = txtPEmail1.Text.Trim();
newst.ParentEmail2 = txtPEmail2.Text.Trim();
newst.ClassOf = ddlYear.SelectedItem.Text;
newst.Homeroom = ddlHomeroom.SelectedItem.Text;
newst.HomeroomId = Convert.ToInt16(ddlHomeroom.SelectedItem.Value);
db.StudentIBs.InsertOnSubmit(newst);
db.SubmitChanges();
val = true;
}
catch (Exception ex)
{
val = false;
lblMsg.Text = "System error when adding this student, please advise Webmaster.";
}
return(val);
}
private void GetHomerooms()
{
IBHhsDataContext db = new IBHhsDataContext();
var results = from p in db.HomeroomIBs
orderby p.Name
select new { p.Name, p.ID };
ddlHomeroom.DataSource = results;
//ddlHomeroom.DataTextField = "Name";
//ddlHomeroom.DataValueField = "Name";
ddlHomeroom.DataBind();
}
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);
}
