public void InsertCourse()
{
var newCourse = new Test_CourseTable();
// newCourse.ID = this.id;
newCourse.Name = this.name;
newCourse.Department = this.department;
newCourse.Credits = this.credits;
newCourse.Section = this.section;
newCourse.DaySlot = this.daySlot;
newCourse.StartTime = this.startTime;
newCourse.EndTime = this.endTime;
CourseDataContext.Test_CourseTables.InsertOnSubmit(newCourse);
CourseDataContext.SubmitChanges();
}
public void InsertFaculty()
{
var newFaculty = new Test_FacultyTable();
newFaculty.Name = this.name;
newFaculty.Department = this.department;
newFaculty.FatherName = this.father;
newFaculty.MotherName = this.mother;
newFaculty.PhoneNumber = this.phone;
newFaculty.Email = this.email;
newFaculty.BloodGroup = this.bloodGroup;
newFaculty.Gender = this.gender;
newFaculty.ID = this.id;
newFaculty.DOB = this.dob;
newFaculty.Nationality = this.nationality;
newFaculty.Password = this.password;
FacultyDataContext.Test_FacultyTables.InsertOnSubmit(newFaculty);
FacultyDataContext.SubmitChanges();
}
public void InsertStudent()
{
var newStudent = new Test_StudentTable();
newStudent.Name = this.name;
newStudent.CGPA = this.CGPA;
newStudent.Credits = this.credit;
newStudent.Department = this.department;
newStudent.FatherName = this.father;
newStudent.MotherName = this.mother;
newStudent.Phone = this.phone;
newStudent.Email = this.email;
newStudent.BloodGroup = this.bloodGroup;
newStudent.Gender = this.gender;
newStudent.ID = this.id;
newStudent.DOB = Convert.ToDateTime(this.dob);
newStudent.ImageDirectory = this.imageDirectory;
newStudent.Nationality = this.nationality;
newStudent.MACAddress = this.macAddress;
newStudent.Password = this.password;
StudentDataContext.Test_StudentTables.InsertOnSubmit(newStudent);
StudentDataContext.SubmitChanges();
}
public void InsertAdmin()
{
var newAdmin = new Test_AdminTable();
newAdmin.Name = this.name;
newAdmin.FatherName = this.father;
newAdmin.MotherName = this.mother;
newAdmin.Phone = this.phone;
newAdmin.Email = this.email;
newAdmin.BloodGroup = this.bloodGroup;
newAdmin.Gender = this.gender;
newAdmin.ID = this.id;
newAdmin.DOB = Convert.ToDateTime(this.dob);
newAdmin.Password = this.password;
AdminDataContext.Test_AdminTables.InsertOnSubmit(newAdmin);
AdminDataContext.SubmitChanges();
}