// יציאה של עובד שומר במסד נתונים ת שעת היציאה של העובד
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));
}
}
