private bool CheckTeacherTime(TeacherCourse aTeacherCourse) { aTeacherGateway = new TeacherGateway(); ScheduleGateway aScheduleGateway = new ScheduleGateway(); List <int> coursesId = new List <int>(); coursesId = aTeacherGateway.GetTeacherAssignCoursesId(aTeacherCourse); List <Schedule> schedules = new List <Schedule>(); schedules = aScheduleGateway.GetTeacherAllSchedules(coursesId); List <Schedule> currentScheduleList = new List <Schedule>(); currentScheduleList = aScheduleGateway.GetCurrentCourseSchedules(aTeacherCourse); foreach (Schedule schedule in currentScheduleList) { foreach (Schedule aSchedule in schedules) { if (schedule.DayId == aSchedule.DayId && ((schedule.StartTime <= aSchedule.StartTime && schedule.EndingTime >= aSchedule.StartTime) || (schedule.StartTime <= aSchedule.EndingTime & schedule.EndingTime >= aSchedule.EndingTime))) { return(true); } } } return(false); }
public void can_create_find_update_and_delete_teacher() { TeacherGateway sut = new TeacherGateway(TestHelpers.ConnectionString); string firstName = TestHelpers.RandomTestName(); string lastName = TestHelpers.RandomTestName(); sut.Create(firstName, lastName); Teacher teacher; { teacher = sut.FindByName(firstName, lastName); CheckTeacher(teacher, firstName, lastName); } { teacher = sut.FindById(teacher.TeacherId); CheckTeacher(teacher, firstName, lastName); } { firstName = TestHelpers.RandomTestName(); lastName = TestHelpers.RandomTestName(); sut.Update(teacher.TeacherId, firstName, lastName); teacher = sut.FindById(teacher.TeacherId); CheckTeacher(teacher, firstName, lastName); } { sut.Delete(teacher.TeacherId); teacher = sut.FindById(teacher.TeacherId); Assert.That(teacher, Is.Null); } }
public JsonResult GetTeachersAndCoursesByDepartment(int departmentId) { if (departmentId <= 0) { return(Json("Department Id cannot be null or less than zero")); } IEnumerable <Teacher> teachers = TeacherGateway.GetTeachersByDepartmentId(departmentId); IEnumerable <Course> courses = CourseGateway.GetCoursesByDepartment(departmentId); return(Json(new { teachers, courses }, JsonRequestBehavior.AllowGet)); }
public string SaveTeacher(Teacher aTeacher) { aTeacherGateway = new TeacherGateway(); if (!DoesThisEmailExist(aTeacher)) { return(aTeacherGateway.SaveTeacher(aTeacher)); } else { return("This Email Already Exist"); } }
private bool DoesThisEmailExist(Teacher aTeacher) { List <string> emails = new List <string>(); aTeacherGateway = new TeacherGateway(); emails = aTeacherGateway.GetAllEmails(); foreach (string email in emails) { if (email == aTeacher.Email) { return(true); } } return(false); }
public string GetTeacherId(int departmentId) { string teacherId = ""; aTeacherGateway = new TeacherGateway(); int id = aTeacherGateway.GetTeacherId(departmentId); if (id < 10) { teacherId = "0" + id; } else { teacherId = id.ToString(); } return(teacherId); }
public string SaveTeacerCourse(TeacherCourse aTeacherCourse, float credit) { aTeacherGateway = new TeacherGateway(); if (!CheckTeacherTime(aTeacherCourse)) { if (!DoesThisCourseExist(aTeacherCourse)) { return(aTeacherGateway.SaveTeacerCourse(aTeacherCourse, credit)); } else { return("This Course Already Assigned"); } } else { return("This Time Teacher Handel Another Course"); } }
public void can_assign_teacher() { TeacherGateway teacherGateway = new TeacherGateway(TestHelpers.ConnectionString); string firstName = TestHelpers.RandomTestName(); string lastName = TestHelpers.RandomTestName(); teacherGateway.Create(firstName, lastName); Teacher teacher1 = teacherGateway.FindByName(firstName, lastName); ClassGateway sut = new ClassGateway(TestHelpers.ConnectionString); string name = TestHelpers.RandomTestName(); string level = TestHelpers.RandomLevel(); sut.Create(name, level, teacher1.TeacherId); Class c; { c = sut.FindByName(name); CheckClass(c, name, level, teacher1.TeacherId); } { string firstName2 = TestHelpers.RandomTestName(); string lastName2 = TestHelpers.RandomTestName(); teacherGateway.Create(firstName2, lastName2); Teacher teacher2 = teacherGateway.FindByName(firstName2, lastName2); sut.AssignTeacher(c.ClassId, teacher2.TeacherId); c = sut.FindById(c.ClassId); CheckClass(c, name, level, teacher2.TeacherId); sut.AssignTeacher(c.ClassId, 0); c = sut.FindById(c.ClassId); CheckClass(c, name, level, 0); teacherGateway.Delete(teacher2.TeacherId); } sut.Delete(c.ClassId); teacherGateway.Delete(teacher1.TeacherId); }
public List <CourseStatics> GetCoursesInformation() { List <CourseStatics> courseStatics = courseGateway.GetCoursesInformation(); List <Teacher> teacherList = new TeacherGateway().GetAllTeachers(); foreach (CourseStatics course in courseStatics) { foreach (Teacher teacher in teacherList) { if (course.TeacherId == teacher.Id) { course.TeacherName = teacher.Name; break; } else { course.TeacherName = "Not Assigned Yet"; } } } return(courseStatics); }
public async Task can_create_find_update_and_delete_teacher() { TeacherGateway sut = new TeacherGateway(TestHelpers.ConnectionString); string firstName = TestHelpers.RandomTestName(); string lastName = TestHelpers.RandomTestName(); var result = await sut.Create(firstName, lastName); Assert.That(result.Status, Is.EqualTo(Status.Created)); int teacherId = result.Content; Result <TeacherData> teacher; { teacher = await sut.FindById(teacherId); CheckTeacher(teacher, firstName, lastName); } { firstName = TestHelpers.RandomTestName(); lastName = TestHelpers.RandomTestName(); Result r = await sut.Update(teacherId, firstName, lastName); Assert.That(r.Status, Is.EqualTo(Status.Ok)); teacher = await sut.FindById(teacherId); CheckTeacher(teacher, firstName, lastName); } { await sut.Delete(teacherId); teacher = await sut.FindById(teacherId); Assert.That(teacher.Status, Is.EqualTo(Status.NotFound)); Assert.That(teacher.HasError, Is.True); } }
public ActionResult Save(Teacher teacher) { TeacherViewModel viewModel = new TeacherViewModel { Designations = DesignationGateway.GetAllDesignations(), Departments = DepartmentGateway.GetAllDepartments() }; if (!ModelState.IsValid) { viewModel.Teacher = teacher; return(View(viewModel)); } int rowAffected = TeacherGateway.Save(teacher); if (rowAffected > 0) { return(Redirect("Save")); } return(View("~/Views/Shared/_BadRequest")); }
public CourseAssignToTeacherManager() { courseAssignToTeacherGateway = new CourseAssignToTeacherGateway(); teacherGateway = new TeacherGateway(); courseGateway = new CourseGateway(); }
public TeacherManager() { TeacherGateway = new TeacherGateway(); }
public TeacherController(TeacherGateway teacherGateway, ClassGateway classGateway) { _teacherGateway = teacherGateway; _classGateway = classGateway; }
public List <Teacher> GetAllTeachers(int departmentId) { aTeacherGateway = new TeacherGateway(); return(aTeacherGateway.GetAllTeachers(departmentId)); }
public TeacherManager() { teacherGateway = new TeacherGateway(); departmentManager = new DepartmentManager(); }
public JsonResult GetTeacherCreditReport(int teacherId) { TeacherCreditReportJsonModel jsonModel = TeacherGateway.GetTeacherCreditReport(teacherId); return(Json(jsonModel, JsonRequestBehavior.AllowGet)); }
public CourseAssignManager() { courseAssignGateway = new CourseAssignGateway(); teacherGateway = new TeacherGateway(); }
public TeacherService(TeacherGateway teacherGateway, ClassGateway classGateway) { _teacherGateway = teacherGateway; _classGateway = classGateway; }
public Teacher GetTeacher(Teacher aTeacher) { aTeacherGateway = new TeacherGateway(); return(aTeacherGateway.GetTeacher(aTeacher)); }
public bool IsEmailExist(string email) { TeacherGateway teacherGateway = new TeacherGateway(); return(teacherGateway.IsEmailExist(email)); }
public AssignCourseManager() { assignCourseGataway = new AssignCourseGataway(); courseGateway = new CourseGateway(); teacherGateway = new TeacherGateway(); }
public Teacher GetTeacherCreditInfo(Teacher aTeacher) { aTeacherGateway = new TeacherGateway(); return(aTeacherGateway.GetTeacherCreditInfo(aTeacher)); }
public int Save(Teacher teacher) { TeacherGateway teacherGateway = new TeacherGateway(); return(teacherGateway.Save(teacher)); }
public CourseAssignTeacherManager() { _courseAssignTeacherGateway = new CourseAssignTeacherGateway(); _teacherGateway = new TeacherGateway(); }