public IEnumerable<TimeCardDTO> GetTimeCardsByDate(DateTime startDate) { using (var context = new TimeCardContext()) { return context.TimeCards.Where(tc => tc.StartDate.Equals(startDate)).Select(tc => tc.ToDTO(true)); } }
public IEnumerable<TimeCardDTO> GetTimeCardsForEmployee(int employeeId) { using (var context = new TimeCardContext()) { var employee = context.Employees.Find(employeeId); return employee != null ? employee.TimeCards.Select(tc => tc.ToDTO(true)) : new List<TimeCardDTO>(); } }
public TimeCardDTO GetTimeCard(int id) { using (var context = new TimeCardContext()) { var timeCard = context.TimeCards.Find(id); return timeCard != null ? timeCard.ToDTO(true) : null; } }
public EmployeeDTO GetEmployee(int id, bool includeTimeCards) { using (var context = new TimeCardContext()) { var employee = context.Employees.Find(id); return employee != null ? employee.ToDTO(includeTimeCards) : null; } }
public void AddTimeCard(TimeCardDTO timeCard) { using (var context = new TimeCardContext()) { context.TimeCards.Add(timeCard.ToDomain(true)); context.SaveChanges(); } }
public void AddEmployee(EmployeeDTO employee) { using (var context = new TimeCardContext()) { context.Employees.Add(employee.ToDomain(true)); context.SaveChanges(); } }
public IEnumerable<EmployeeDTO> SearchEmployees(string firstName, string lastName, string title, bool includeTimeCards) { using (var context = new TimeCardContext()) { var employees = context.Employees.AsEnumerable().Where( e => String.IsNullOrWhiteSpace(firstName) || e.FirstName.Equals(firstName, StringComparison.InvariantCultureIgnoreCase)).Where( e => String.IsNullOrWhiteSpace(lastName) || e.LastName.Equals(lastName, StringComparison.InvariantCultureIgnoreCase)).Where( e => String.IsNullOrWhiteSpace(title) || e.Title.Equals(title, StringComparison.InvariantCultureIgnoreCase)); return employees.Select(e => e.ToDTO(includeTimeCards)).ToList(); } }