// יציאה של עובד שומר במסד נתונים ת שעת היציאה של העובד public static UserCalandarDTO SingOut(int id, DateTime date) { using (restaurantEntities db = new restaurantEntities()) { Employees emm = db.Employees.FirstOrDefault(e => e.Id == id); if (emm != null) { UserCalander userCalandar = db.UserCalander.FirstOrDefault(u => u.IdUser == id && u.Date.Value.Year == date.Year && u.Date.Value.Month == date.Month && u.Date.Value.Day == date.Day); if (userCalandar != null) { userCalandar.LeavingTime = date; db.Entry(userCalandar).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(UserCalandarC.ToDTO(userCalandar)); } else { return(null); } } Visiters visiter = db.Visiters.FirstOrDefault(e => e.ld == id); if (visiter != null) { visiter.lastDateEnter = date; db.Entry(visiter).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(null); } }
public static List <UserCalandarDTO> getDailyWorker() { using (restaurantEntities db = new restaurantEntities()) { List <UserCalander> userCalandar = db.UserCalander.Where(u => u.Date.Value.Year == DateTime.Today.Year && u.Date.Value.Month == DateTime.Today.Month && u.Date.Value.Day == DateTime.Today.Day).ToList(); return(UserCalandarC.ListToDTO(userCalandar)); } }