private bool AddStudent()
{
bool val = true;
IBStudentsDataContext db = new IBStudentsDataContext();
try
{
IB_Student newst = new IB_Student();
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;
db.IB_Students.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 SelectAll(string last, string first, string year)
{
IBStudentsDataContext db = new IBStudentsDataContext();
var results = from p in db.IB_Students
where p.LastName == last &&
p.FirstName == first &&
p.ClassOf == year
orderby p.LastName
select new
{
p.StudentNo,
p.LastName,
p.FirstName,
p.ClassOf
};
if (results.FirstOrDefault() != null)
{
gdResult.DataSource = results;
gdResult.DataBind();
lblMessage.Text = "Click select to view details !";
}
else
{
lblMessage.Text = "No student found !";
}
}
