public StudentDataHandler(string id)
{
this.id = id;
this.StudentDataContext = new AdminDataDataContext();
var StudentInformation = from student in StudentDataContext.Test_StudentTables
where student.ID == id
select student;
StudentInformation.ToList();
foreach (var data in StudentInformation)
{
this.name = data.Name;
this.CGPA = (double)data.CGPA;
this.credit = data.Credits ?? 0;
this.department = data.Department ?? 1;
this.father = data.FatherName;
this.mother = data.MotherName;
this.phone = data.Phone;
this.email = data.Email;
this.bloodGroup = data.BloodGroup ?? 1;
this.gender = data.Gender ?? 1;
this.dob = data.DOB ?? DateTime.Now;
this.imageDirectory = data.ImageDirectory;
this.nationality = data.Nationality ?? 1;
this.macAddress = data.MACAddress;
this.password = data.Password;
}
}
public CourseDataHandler(int id)
{
this.id = id;
this.CourseDataContext = new AdminDataDataContext();
var CourseInformation = from course in CourseDataContext.Test_CourseTables
where course.ID == id
select course;
CourseInformation.ToList();
foreach (var data in CourseInformation)
{
this.name = data.Name;
this.id = data.ID;
this.department = data.Department ?? 1;
this.credits = data.Credits ?? 1;
this.section = data.Section ?? 1;
this.daySlot = data.DaySlot ?? 1;
this.startTime = data.StartTime ?? 1;
this.endTime = data.EndTime ?? 1;
}
}
public AdminDataHandler(string id)
{
this.id = id;
this.AdminDataContext = new AdminDataDataContext();
var AdminInformation = from student in AdminDataContext.Test_AdminTables
where student.ID == id
select student;
AdminInformation.ToList();
foreach (var data in AdminInformation)
{
this.name = data.Name;
this.father = data.FatherName;
this.mother = data.MotherName;
this.phone = data.Phone;
this.email = data.Email;
this.bloodGroup = data.BloodGroup ?? 1;
this.gender = data.Gender ?? 1;
this.dob = data.DOB.ToString();
}
}
public FacultyDataHandler(string id)
{
this.id = id;
this.FacultyDataContext = new AdminDataDataContext();
var FacultyInformation = from student in FacultyDataContext.Test_FacultyTables
where student.ID == id
select student;
FacultyInformation.ToList();
foreach (var data in FacultyInformation)
{
this.name = data.Name;
this.department = data.Department ?? 1;
this.father = data.FatherName;
this.mother = data.MotherName;
this.phone = data.PhoneNumber;
this.email = data.Email;
this.bloodGroup = data.BloodGroup ?? 1;
this.gender = data.Gender ?? 1;
this.dob = data.DOB ?? DateTime.Now;
this.nationality = data.Nationality ?? 1;
}
}
public StudentDataHandler()
{
this.StudentDataContext = new AdminDataDataContext();
}
public FacultyDataHandler()
{
this.FacultyDataContext = new AdminDataDataContext();
}
public CourseDataHandler()
{
this.CourseDataContext = new AdminDataDataContext();
}
public AdminDataHandler()
{
this.AdminDataContext = new AdminDataDataContext();
}
