public int CountVisitsByDepartmentAndDate(AspitDepartment department, DateTime date)
{
return(db.Visits.Where(v => v.AspitDepartment.departmentName == department.departmentName && DbFunctions.TruncateTime(v.visitStartTime) == DbFunctions.TruncateTime(date)).Count());
}
public int CountVisitsByDepartment(AspitDepartment department)
{
return(db.Visits.Where(v => v.AspitDepartment.departmentName == department.departmentName).Count());
}
public int CountPotentialStudentsByDepartment(AspitDepartment department)
{
return(db.Visits.Where(v => v.AspitDepartment.departmentName == department.departmentName && v.visitorWantsToStudyAtAspit == true).Count());
}
public void CreateVisit(DateTime startTime, DateTime endTime, Visitor visitor, AspitDepartment department, bool wantToApply)
{
Visit visit = new Visit {
visitEndTime = endTime, visitStartTime = startTime, visitorWantsToStudyAtAspit = wantToApply
};
DB.Visitors.Where(v => v.firstName == visitor.firstName && v.lastName == visitor.lastName).First().Visits.Add(visit);
DB.AspitDepartments.Where(d => d.departmentName == department.departmentName).Single().Visits.Add(visit);
DB.SaveChanges();
}
