public void LoadTeachers()
{
ITeacherService teacherService = new TeacherService();
string message = String.Empty;
try
{
var teachers = teacherService.GetAllTeachers();
teacherList = new List<Teacher>(teachers);
gvTeacher.DataSource = teachers;
gvTeacher.Refresh();
if (gvTeacher.RowCount != 0)
gvTeacher.Rows[0].IsSelected = true;
}
catch (Exception ex)
{
message = "Error Loading Faculty List";
MessageBox.Show(ex.ToString());
}
}
public List <Teacher> GetAvailableTeachers(string timeslotcode)
{
List <Teacher> teacherList = new List <Teacher>();
List <SubjectAssignment> schedList = new List <SubjectAssignment>();
List <Teacher> takenTeachers = new List <Teacher>();
List <Teacher> availableTeachers = new List <Teacher>();
SubjectAssignmentService sas = new SubjectAssignmentService();
schedList = GetAllSchedules();
foreach (SubjectAssignment sa in schedList)
{
takenTeachers.Add(sa.Teacher);
}
TeacherService ts = new TeacherService();
teacherList = ts.GetAllTeachers();
availableTeachers = teacherList.Except <Teacher>(takenTeachers).ToList <Teacher>();
return(availableTeachers);
}
public void TranslateGradeSectionBDOToGradeSection(GradeSectionBDO gs, GradeSection gsb)
{
RoomService rService = new RoomService();
Room room = new Room();
TeacherService tService = new TeacherService();
Teacher teacher = new Teacher();
string message = string.Empty;
room = rService.GetRoom(gs.HomeRoomNumber);
teacher = tService.GetTeacher(gs.HomeRoomTeacherId, ref message);
gsb.Deactivated = gs.Deactivated;
gsb.GradeLevel = gs.GradeLevel;
gsb.GradeSectionCode = gs.GradeSectionCode;
gsb.HomeRoom = room;
gsb.HomeRoomNumber = gs.HomeRoomNumber;
gsb.HomeRoomTeacherId = gs.HomeRoomTeacherId;
gsb.HomeRoomTeacher = teacher;
if (teacher.MiddleName == String.Empty)
gsb.TeacherName = teacher.LastName + ", " + teacher.FirstName;
else
gsb.TeacherName = teacher.LastName + ", " + teacher.FirstName + " " + teacher.MiddleName.Substring(0, 1);
gsb.Class = gs.Class;
gsb.SY = gs.SY;
gsb.Section = gs.Section;
}
public List <Teacher> GetAllTeachers()
{
TeacherService ts = new TeacherService();
return(ts.GetAllTeachers());
}
public void TranslateScheduleBDOToSchedule(SubjectAssignmentBDO sabdo, SubjectAssignment sched)
{
GradeSectionService gs = new GradeSectionService();
GradeSection g = new GradeSection();
gs.TranslateGradeSectionBDOToGradeSection(sabdo.GradeSection, g);
sched.GradeSection = g;
sched.Section = g.Section;
sched.GradeLevel = g.GradeLevel;
sched.Class = (int)g.Class;
RoomService rs = new RoomService();
Room r = new Room();
rs.TranslateRoomBDOtoRoomDTO(sabdo.Room, r);
sched.Room = r;
sched.RoomCode = r.RoomCode;
SubjectService ss = new SubjectService();
Subject s = new Subject();
ss.TranslateSubjectBDOToSubject(sabdo.Subject, s);
sched.Subject = s;
TeacherService ts = new TeacherService();
Teacher t = new Teacher();
ts.TranslateTeacherBDOToTeacherDTO(sabdo.Teacher, t);
sched.Teacher = t;
if (t.MiddleName == String.Empty)
{
sched.TeacherName = t.LastName + ", " + t.FirstName;
}
else
{
sched.TeacherName = t.LastName + ", " + t.FirstName + " " + t.MiddleName.Substring(0, 1) + ".";
}
TimeslotService times = new TimeslotService();
Timeslot time = new Timeslot();
times.TranslateTimeslotBDOToTimeslotDTo(sabdo.Timeslot, time);
sched.Timeslot = time;
sched.Timestart = time.TimeStart;
sched.TimeEnd = time.TimeEnd;
sched.Days = time.Days;
sched.Deactivated = sabdo.Deactivated;
sched.GradeSectionCode = sabdo.GradeSectionCode;
sched.RoomId = sabdo.RoomId;
sched.SubjectAssignmentsID = sabdo.SubjectAssignmentsID;
sched.SubjectCode = sabdo.SubjectCode;
sched.SY = sabdo.SY;
sched.TeacherId = sabdo.TeacherId;
sched.TimeSlotCode = sabdo.TimeSlotCode;
sched.TimeslotInfo = time.Days + " " + time.TimeStart + "-" + time.TimeEnd;
sched.SubjectInfo = sabdo.SubjectCode + " " + sched.Section + " " + sched.TimeslotInfo;
sched.SubjectDescription = s.Description;
}
public Teacher GetTeacherDetail(string teacherID, ref string message)
{
TeacherService ts = new TeacherService();
return(ts.GetTeacher(teacherID, ref message));
}
public Teacher GetTeacher(string lastname, string middlename, string firstname)
{
TeacherService ts = new TeacherService();
return(ts.GetTeacher(lastname, firstname, middlename));
}
public Teacher GetTeacher(string lastname, string middlename, string firstname)
{
TeacherService ts = new TeacherService();
return ts.GetTeacher(lastname, firstname, middlename);
}
public Teacher GetTeacherDet(string teacherId, ref string message)
{
TeacherService ts = new TeacherService();
return ts.GetTeacher(teacherId, ref message);
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (teacherSelected != null)
{
ITeacherService teacherService = new TeacherService();
string message = String.Empty;
if (!teacherService.DeactivateTeacher(teacherSelected.TeacherId, ref message))
{
teacherSelected.Deactivated = true;
Log("D", "Teachers", teacherSelected);
MessageBox.Show("Deactivation of User Failed");
}
else
{
MessageBox.Show("Deactivated succesfully!");
}
}
}
public List<Teacher> GetAllTeachers()
{
TeacherService t = new TeacherService();
return t.GetAllTeachers();
}
public void TranslateScheduleBDOToSchedule(SubjectAssignmentBDO sabdo, SubjectAssignment sched)
{
GradeSectionService gs = new GradeSectionService();
GradeSection g = new GradeSection();
gs.TranslateGradeSectionBDOToGradeSection(sabdo.GradeSection, g);
sched.GradeSection = g;
sched.Section = g.Section;
sched.GradeLevel = g.GradeLevel;
sched.Class = (int)g.Class;
RoomService rs = new RoomService();
Room r = new Room();
rs.TranslateRoomBDOtoRoomDTO(sabdo.Room, r);
sched.Room = r;
sched.RoomCode = r.RoomCode;
SubjectService ss = new SubjectService();
Subject s = new Subject();
ss.TranslateSubjectBDOToSubject(sabdo.Subject, s);
sched.Subject = s;
TeacherService ts = new TeacherService();
Teacher t = new Teacher();
ts.TranslateTeacherBDOToTeacherDTO(sabdo.Teacher, t);
sched.Teacher = t;
if (t.MiddleName == String.Empty)
sched.TeacherName = t.LastName + ", " + t.FirstName;
else
sched.TeacherName = t.LastName + ", " + t.FirstName + " " + t.MiddleName.Substring(0, 1) + ".";
TimeslotService times = new TimeslotService();
Timeslot time = new Timeslot();
times.TranslateTimeslotBDOToTimeslotDTo(sabdo.Timeslot, time);
sched.Timeslot = time;
sched.Timestart = time.TimeStart;
sched.TimeEnd = time.TimeEnd;
sched.Days = time.Days;
sched.Deactivated = sabdo.Deactivated;
sched.GradeSectionCode = sabdo.GradeSectionCode;
sched.RoomId = sabdo.RoomId;
sched.SubjectAssignmentsID = sabdo.SubjectAssignmentsID;
sched.SubjectCode = sabdo.SubjectCode;
sched.SY = sabdo.SY;
sched.TeacherId = sabdo.TeacherId;
sched.TimeSlotCode = sabdo.TimeSlotCode;
sched.TimeslotInfo = time.Days + " " + time.TimeStart + "-" + time.TimeEnd;
sched.SubjectInfo = sabdo.SubjectCode + " " + sched.Section + " " + sched.TimeslotInfo;
sched.SubjectDescription = s.Description;
}
public List<Teacher> GetAvailableTeachers(string timeslotcode)
{
List<Teacher> teacherList = new List<Teacher>();
List<SubjectAssignment> schedList = new List<SubjectAssignment>();
List<Teacher> takenTeachers = new List<Teacher>();
List<Teacher> availableTeachers = new List<Teacher>();
SubjectAssignmentService sas = new SubjectAssignmentService();
schedList = GetAllSchedules();
foreach (SubjectAssignment sa in schedList)
{
takenTeachers.Add(sa.Teacher);
}
TeacherService ts = new TeacherService();
teacherList = ts.GetAllTeachers();
availableTeachers = teacherList.Except<Teacher>(takenTeachers).ToList<Teacher>();
return availableTeachers;
}
private void Save()
{
string szGender = string.Empty;
string szBloodType = string.Empty;
bool acad = false;
if (cmbGender.Text == "Female") szGender = "F";
if (cmbGender.Text == "Male") szGender = "M";
if (cmbBloodType.Text == "A") szBloodType = "A";
if (cmbBloodType.Text == "O") szBloodType = "O";
if (cmbBloodType.Text == "AB") szBloodType = "AB";
if (cmbBloodType.Text == "A") szBloodType = "A";
if (radioAcademic.Checked == true && radioNonAcad.Checked == false) acad = true;
else if (radioAcademic.Checked == false && radioNonAcad.Checked == true) acad = false;
else if (radioAcademic.Checked == false && radioNonAcad.Checked == false) acad = false;
Boolean ret = false;
string message = String.Empty;
byte[] bImage = null;
if (pbImage.BackgroundImage != null) bImage = imageToByteArray(pbImage.BackgroundImage, ImageFormat.Png);
TeacherService teacherService = new TeacherService();
String fName = txtFirstName.Text;
String mName = txtMiddleName.Text;
String lName = txtLastName.Text;
String cName = fName.Trim() + mName.Trim() + lName.Trim();
var teachers = teacherService.GetAllTeachers();
teacherCompare = new List<Teacher>(teachers);
Teacher teacher = new Teacher()
{
TeacherId = txtTeacherID.Text,
BloodType = szBloodType,
CivilStatus = cmbCivilState.Text,
DOB = dtBirth.Value,
DateOfAppointment = dtAppointment.Value,
EmailAddress = txtEmailAdd.Text,
EmploymentStatus = txtEmploymentState.Text,
DialectSpoken = txtDialect.Text,
FirstName = txtFirstName.Text,
MiddleName = txtMiddleName.Text,
LastName = txtLastName.Text,
Gender = szGender,
HeightCm = int.Parse(txtHeight.Text),
WeightKg = double.Parse(txtWeight.Text),
MobileNo = txtCellphone.Text,
PAMunicipality = txtPA_Municipality.Text,
PAProvince = txtPA_Province.Text,
PARegion = cmbPA_Region.SelectedValue.ToString(),
PAStreetName = txtPA_StreetName.Text,
POBMunicipality = txtPOB_Municipality.Text,
POBProvince = txtPOB_Province.Text,
PagIBIGNo = txtPagIbig.Text,
PhilHealthNo = txtPhilHealth.Text,
PreviousSchool = txtSchoolReassigned.Text,
RAMunicipality = txtRes_Municipality.Text,
RAProvince = txtRes_Province.Text,
RARegion = cmbRes_Region.SelectedValue.ToString(),
RAStreetName = txtRes_StreetName.Text,
ResTelephoneNo = txtRes_TelNo.Text,
SSSNum = txtSSS.Text,
SpouseBusinessAdd = txtSpouse_BusinessAdd.Text,
SpouseEmployerName = txtSpouse_Employer.Text,
SpouseFirstName = txtSpouse_FirstName.Text,
SpouseLastName = txtSpouse_LastName.Text,
SpouseMiddleName = txtSpouse_MiddleName.Text,
SpouseOccupation = txtSpouse_Occupation.Text,
SpouseTelephoneNo = txtSpouse_Contact.Text,
TIN = txtTIN.Text,
Image = bImage,
PERAA = txtPERAA.Text,
Academic = acad,
Salary = double.Parse(txtSalary.Text),
Department = txtDepartment.Text,
TeacherChildrens = teachChild,
TeacherEducationalBackgrounds = educBack,
TeacherEligibilities = teachElig,
WorkExperiences = workExp,
TrainingSeminars=trainSem,
};
if (Op.Equals("edit"))
{
ret = teacherService.UpdateTeacher(ref teacher, ref message);
ILogService logService = new LogService();
teacher.TeacherChildrens = null;
teacher.TeacherEducationalBackgrounds = null;
teacher.TeacherEligibilities = null;
teacher.TrainingSeminars = null;
teacher.WorkExperiences = null;
Log("U", "Teachers", teacher);
foreach (TeacherChildren tc in teachChild)
Log("U", "TeacherChildren", tc);
foreach (TeacherEducationalBackground teb in educBack)
Log("U", "TeacherEducationalBackground", teb);
foreach (TeacherEligibility te in teachElig)
Log("U", "TeacherEligibilities", te);
foreach (WorkExperience we in workExp)
Log("U", "WorkExperiences", we);
foreach (TrainingSeminar ts in trainSem)
Log("U", "TrainingSeminars", ts);
}
else
{
foreach (Teacher tc in teacherCompare)
{
String compareString = tc.FirstName.Trim() + tc.MiddleName.Trim() + tc.LastName.Trim();
if (cName.Equals(compareString))
{
MessageBox.Show("Teacher already exist!");
break;
}
else
{
ret = teacherService.CreateTeacher(ref teacher, ref message);
Log("C", "Teachers", teacher);
}
}
}
// if (ret)
MessageBox.Show("Saved Successfully");
//else
// MessageBox.Show("Error Saving");
Close();
}
private void txtTeacherID_Leave(object sender, EventArgs e)
{
Teacher teach = new Teacher();
string msg = string.Empty;
ITeacherService teacherService = new TeacherService();
if (txtTeacherID.Text == string.Empty) txtTeacherID.Text = szTeacherID;
teach = teacherService.GetTeacher(txtTeacherID.Text, ref msg);
if (teach.TeacherId != null)
{
MessageBox.Show("Teacher ID already exist!");
txtTeacherID.Text = szTeacherID;
txtTeacherID.Focus();
return;
}
}
private void frmTeacherDetails_Load(object sender, EventArgs e)
{
pageViewTeacher.SelectedPage = pageViewTeacher.Pages[0];
List<RegionDic> ResRegion = new List<RegionDic>(regions);
List<RegionDic> PARegion = new List<RegionDic>(regions);
cmbPA_Region.DataSource = PARegion;
cmbRes_Region.DataSource = ResRegion;
if (Op.Equals("edit"))
{
SetFields();
SetGrids();
}
if (Op.Equals("new"))
{
ITeacherService teacherService = new TeacherService();
szTeacherID = teacherService.GenerateTeacherId();
txtTeacherID.Text = szTeacherID;
BindGrids();
}
}
