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