private void btnUpdate_Click(object sender, EventArgs e)
{
string msgYear = val.valYear(txtYearUp.Text);
string msgCName = val.valCName(txtCourseNameUp.Text);
string msgSem = val.valSem(txtSemUp.Text);
if (msgSem == "" && msgYear == "" && msgCName == "")
{
using (SchoolEntities db = new SchoolEntities())
{
int cno = Convert.ToInt32(cboCourseID.Text);
Course courses = (from c in db.Courses where c.CID == cno select c).First();
courses.Year = Convert.ToInt32(txtYearUp.Text);
courses.CName = txtCourseName.Text;
courses.Semester = txtSemUp.Text;
courses.CID = Convert.ToInt32(txtCourseID.Text);
if (ckAdT.Checked)
{
courses.TID = Convert.ToInt32(cboAllodTeacher.Text);
}
db.SaveChanges();
MessageBox.Show("Course details updated!");
}
this.refreshForm();
this.updateTeacher();
}
else
{
MessageBox.Show(msgCName + "\r\n" + msgYear + "\r\n" + msgSem);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
string msgFN = val.valFName(txtFName.Text);
string msgLN = val.valLName(txtLName.Text);
string msgP = val.valPassword(txtPassword.Text);
if (msgFN == "" && msgLN == "" && msgP == "")
{
using (SchoolEntities db = new SchoolEntities())
{
Administrator admins = new Administrator();
admins.FName = txtFName.Text;
admins.LName = txtLName.Text;
admins.Password = txtPassword.Text;
db.Administrators.Add(admins);
db.SaveChanges();
MessageBox.Show("New Admin Added! ID:" + admins.AID);
}
this.updateAdmin();
}
else
{
MessageBox.Show(msgFN + "\r\n" + msgLN + "\r\n" + msgP);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
string msgYear = val.valYear(txtYear.Text);
string msgCName = val.valCName(txtCourseName.Text);
string msgSem = val.valSem(txtSem.Text);
string msgCID = val.validCID(txtCourseID.Text);
if (msgSem == "" && msgYear == "" && msgCName == "" && msgCID == "")
{
using (SchoolEntities db = new SchoolEntities())
{
Course courses = new Course();
courses.Year = Convert.ToInt32(txtYear.Text);
courses.CName = txtCourseName.Text;
courses.Semester = txtSem.Text;
courses.CID = Convert.ToInt32(txtCourseID.Text);
if (ckAT.Checked)
{
courses.TID = Convert.ToInt32(cboAlloTeacher.Text);
}
db.Courses.Add(courses);
db.SaveChanges();
MessageBox.Show("Course Added!");
}
}
else
{
MessageBox.Show(msgCName + "\r\n" + msgYear + "\r\n" + msgSem + "\r\n" + msgCID);
}
this.refreshForm();
this.updateTeacher();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
string msgFN = val.valFName(txtFNameUp.Text);
string msgLN = val.valLName(txtLNameUp.Text);
string msgP = val.valPassword(txtPasswordUp.Text);
if (msgFN == "" && msgLN == "" && msgP == "")
{
using (SchoolEntities db = new SchoolEntities())
{
int ano = Convert.ToInt32(cboAIDUp.Text);
Administrator admins = (from c in db.Administrators where c.AID == ano select c).First();
admins.FName = txtFNameUp.Text;
admins.LName = txtLNameUp.Text;
admins.Password = txtPasswordUp.Text;
db.SaveChanges();
MessageBox.Show("Admin Updated!");
}
this.updateAdmin();
}
else
{
MessageBox.Show(msgFN + "\r\n" + msgLN + "\r\n" + msgP);
}
}
private void btnAddMarks_Click(object sender, EventArgs e)
{
string mark = val.valMark(txtMarkAdd.Text);
if (!(mark == ""))
{
MessageBox.Show(mark);
}
using (SchoolEntities db = new SchoolEntities())
{
int sno = Convert.ToInt32(cboSIDAdd.Text);
int cno = Convert.ToInt32(cboCIDAdd.Text);
Student_Course course = (from c in db.Student_Course where sno == c.SID && cno == c.CID select c).FirstOrDefault();
if (course != null)
{
MessageBox.Show("Mark Exists Already. Cannot Add Marks.");
}
else
{
course = new Student_Course();
course.SID = sno;
course.CID = cno;
course.Mark = Convert.ToInt32(txtMarkAdd.Text);
db.Student_Course.Add(course);
db.SaveChanges();
MessageBox.Show("Mark Added.");
}
updateMarks();
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
using (SchoolEntities db = new SchoolEntities())
{
int cno = Convert.ToInt32(cboCIDEdit.Text);
int[] sid = (from c in db.Student_Course where c.CID == cno select c.SID).ToArray();
int sct = sid.Length;
for (int i = 0; i < sct; i++)
{
int studentid = sid[i];
Student_Course cou = (from c in db.Student_Course where c.CID == cno && c.SID == studentid select c).FirstOrDefault();
string markInput = dGVMarks.Rows[i].Cells[MarkCol].Value.ToString();
string output = val.valMark(markInput);
int markEd = Convert.ToInt32(markInput);
if (!(output == ""))
{
MessageBox.Show(output);
}
cou.Mark = markEd;
db.SaveChanges();
}
}
updateMarks();
}
private void btnDelete_Click(object sender, EventArgs e)
{
using (SchoolEntities db = new SchoolEntities())
{
int cno = Convert.ToInt32(cboCourseID.Text);
Course cor = (from c in db.Courses where c.CID == cno select c).First();
db.Courses.Remove(cor);
db.SaveChanges();
MessageBox.Show("Course Deleted!");
}
this.updateTeacher();
this.refreshForm();
}
private void btnDelete_Click(object sender, EventArgs e)
{
using (SchoolEntities db = new SchoolEntities())
{
int tno = Convert.ToInt32(cboTIDUp.Text);
Teacher teach = (from c in db.Teachers where c.TID == tno select c).First();
db.Teachers.Remove(teach);
db.SaveChanges();
MessageBox.Show("Teacher Deleted!");
}
this.updateTeacher();
}
private void btnDelete_Click(object sender, EventArgs e)
{
using (SchoolEntities db = new SchoolEntities())
{
int sno = Convert.ToInt32(cboSIDUp.Text);
Student stud = (from c in db.Students where c.SID == sno select c).First();
db.Students.Remove(stud);
db.SaveChanges();
MessageBox.Show("Student Deleted!");
}
this.updateStudent();
}
private void btnDelete_Click(object sender, EventArgs e)
{
using (SchoolEntities db = new SchoolEntities())
{
int ano = Convert.ToInt32(cboAIDUp.Text);
Administrator admins = (from c in db.Administrators where c.AID == ano select c).First();
db.Administrators.Remove(admins);
db.SaveChanges();
MessageBox.Show("Admin Deleted!");
}
this.updateAdmin();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
string msgFName = val.valFName(txtFNameUp.Text);
string msgLName = val.valLName(txtLNameUp.Text);
string msgDate = val.validDateDOB(dateTUp.Value);
string msgPhone = val.valPhone(txtPhoneUp.Text);
string msgAdd1 = val.valAdd1(txtAddressLine1Up.Text);
string msgAdd2 = val.valAdd2(txtAddressLine2Up.Text);
string msgSuburb = val.valSub(txtSuburbUp.Text);
string msgPost = val.valPostcode(txtPostcodeUp.Text);
string msgRego = val.valRegoNo(txtRegNoUp.Text);
string msgPass = val.valPassword(txtPasswordUp.Text);
if (msgFName == "" && msgLName == "" && msgDate == "" && msgPhone == "" && msgAdd1 == "" && msgAdd2 == "" && msgSuburb == "" && msgPost == "" && msgRego == "" && msgPass == "")
{
using (SchoolEntities db = new SchoolEntities())
{
int tno = Convert.ToInt32(cboTIDUp.Text);
Teacher teachers = (from c in db.Teachers where c.TID == tno select c).First();
teachers.FName = txtFNameUp.Text;
teachers.LName = txtLNameUp.Text;
teachers.DOB = dateTUp.Value;
teachers.Phone = txtPhoneUp.Text;
teachers.Add1 = txtAddressLine1Up.Text;
teachers.Add2 = txtAddressLine2Up.Text;
teachers.Suburb = txtSuburbUp.Text;
teachers.State = cboStateUp.Text;
teachers.Postcode = txtPostcodeUp.Text;
teachers.RegNo = txtRegNoUp.Text;
teachers.Password = txtPasswordUp.Text;
db.SaveChanges();
MessageBox.Show("Teacher Updated!");
}
this.updateTeacher();
}
else
{
MessageBox.Show(msgFName + "\r\n" + msgLName + "\r\n" + msgPhone + "\r\n" + msgAdd1 + "\r\n" + msgAdd2 + "\r\n" + msgSuburb + "\r\n" + msgPost + "\r\n" + msgRego + "\r\n" + msgPass);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
string msgFName = val.valFName(txtFNameUp.Text);
string msgLName = val.valLName(txtLNameUp.Text);
string msgDate = val.validDateStart(dateSDUp.Value);
string msgDateDOB = val.validDateDOB(dateSUp.Value);
string msgPhone = val.valPhone(txtPhoneUp.Text);
string msgAdd1 = val.valAdd1(txtAddressLine1Up.Text);
string msgAdd2 = val.valAdd2(txtAddressLine2Up.Text);
string msgSuburb = val.valSub(txtSuburbUp.Text);
string msgPost = val.valPostcode(txtPostcodeUp.Text);
if (msgFName == "" && msgLName == "" && msgDate == "" && msgDateDOB == "" && msgPhone == "" && msgAdd1 == "" && msgAdd2 == "" && msgSuburb == "" && msgPost == "")
{
using (SchoolEntities db = new SchoolEntities())
{
int sno = Convert.ToInt32(cboSIDUp.Text);
Student students = (from c in db.Students where c.SID == sno select c).First();
students.FName = txtFNameUp.Text;
students.LName = txtLNameUp.Text;
students.SDate = dateSDUp.Value;
students.DOB = dateSUp.Value;
students.Phone = txtPhoneUp.Text;
students.Add1 = txtAddressLine1Up.Text;
students.Add2 = txtAddressLine2Up.Text;
students.Suburb = txtSuburbUp.Text;
students.State = cboStateUp.Text;
students.Postcode = txtPostcodeUp.Text;
db.SaveChanges();
MessageBox.Show("Student Updated!");
}
}
else
{
MessageBox.Show(msgFName + "\r\n" + msgLName + "\r\n" + msgPhone + "\r\n" + msgAdd1 + "\r\n" + msgAdd2 + "\r\n" + msgSuburb + "\r\n" + msgPost);
}
this.updateStudent();
}
private void btnAdd_Click(object sender, EventArgs e)
{
string msgFName = val.valFName(txtFName.Text);
string msgLName = val.valLName(txtLName.Text);
string msgDate = val.validDateDOB(dateT.Value);
string msgPhone = val.valPhone(txtPhone.Text);
string msgAdd1 = val.valAdd1(txtAddressLine1.Text);
string msgAdd2 = val.valAdd2(txtAddressLine2.Text);
string msgSuburb = val.valSub(txtSuburb.Text);
string msgPost = val.valPostcode(txtPostcode.Text);
string msgRego = val.valRegoNo(txtRegNo.Text);
string msgPass = val.valPassword(txtPassword.Text);
if (msgFName == "" && msgLName == "" && msgDate == "" && msgPhone == "" && msgAdd1 == "" && msgAdd2 == "" && msgSuburb == "" && msgPost == "" && msgRego == "" && msgPass == "")
{
using (SchoolEntities db = new SchoolEntities())
{
Teacher teachers = new Teacher();
teachers.FName = txtFName.Text;
teachers.LName = txtLName.Text;
teachers.DOB = dateT.Value;
teachers.Phone = txtPhone.Text;
teachers.Add1 = txtAddressLine1.Text;
teachers.Add2 = txtAddressLine2.Text;
teachers.Suburb = txtSuburb.Text;
teachers.State = cboState.Text;
teachers.Postcode = txtPostcode.Text;
teachers.RegNo = txtRegNo.Text;
teachers.Password = txtPassword.Text;
db.Teachers.Add(teachers);
db.SaveChanges();
MessageBox.Show("New Teacher Added! ID:" + teachers.TID);
}
}
else
{
MessageBox.Show(msgFName + "\r\n" + msgLName + "\r\n" + msgPhone + "\r\n" + msgAdd1 + "\r\n" + msgAdd2 + "\r\n" + msgSuburb + "\r\n" + msgPost + "\r\n" + msgRego + "\r\n" + msgPass);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
string msgFName = val.valFName(txtFName.Text);
string msgLName = val.valLName(txtLName.Text);
string msgDate = val.validDateStart(dateSD.Value);
string msgDateDOB = val.validDateDOB(dateS.Value);
string msgPhone = val.valPhone(txtPhone.Text);
string msgAdd1 = val.valAdd1(txtAddressLine1.Text);
string msgAdd2 = val.valAdd2(txtAddressLine2.Text);
string msgSuburb = val.valSub(txtSuburb.Text);
string msgPost = val.valPostcode(txtPostcode.Text);
if (msgFName == "" && msgLName == "" && msgDate == "" && msgDateDOB == "" && msgPhone == "" && msgAdd1 == "" && msgAdd2 == "" && msgSuburb == "" && msgPost == "")
{
using (SchoolEntities db = new SchoolEntities())
{
Student students = new Student();
students.FName = txtFName.Text;
students.LName = txtLName.Text;
students.DOB = dateS.Value;
students.Phone = txtPhone.Text;
students.Add1 = txtAddressLine1.Text;
students.Add2 = txtAddressLine2.Text;
students.Suburb = txtSuburb.Text;
students.State = cboState.Text;
students.Postcode = txtPostcode.Text;
students.SDate = dateSD.Value;
db.Students.Add(students);
db.SaveChanges();
MessageBox.Show("New Student Added! ID:" + students.SID);
}
}
else
{
MessageBox.Show(msgFName + "\r\n" + msgLName + "\r\n" + msgPhone + "\r\n" + msgDate + "\r\n" + msgAdd1 + "\r\n" + msgDateDOB + "\r\n" + msgAdd2 + "\r\n" + msgSuburb + "\r\n" + msgPost);
}
this.refreshForm();
this.updateStudent();
}