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();
}
