public static void ChangeStatus(int Id, EVacationStatus status) { using (ManagementSystemEntities db = new ManagementSystemEntities()) { var q = db.WorkFromHomeDays.FirstOrDefault(e => e.Id == Id); if (q != null) { q.StatusId = (int)status; } db.SaveChanges(); } }
public static List <EmplyeeVacationDetails> GetCompletedVacations(int page, int userId, EVacationStatus completeStatus) { int takeCount = Config.PageItemCount(); int skipCount = page * takeCount; return(EmployeeVacationsRepositories.GetCompletedVacations(skipCount, takeCount, userId, completeStatus, DateTimeHelper.Today())); }
public static void ChangeStatus(int employeeVacationId, EVacationStatus status) { EmployeeVacationsRepositories.ChangeStatus(employeeVacationId, status); }
public static List <EmplyeeVacationDetails> GetCompletedVacations(int skipCount, int takeCount, int userId, EVacationStatus completeStatus, DateTime datetime) { using (ManagementSystemEntities db = new ManagementSystemEntities()) { var q = (from vacation in db.EmployeeVacations join status in db.VacationStatus on vacation.StatusId equals status.Id join vacationType in db.VacationTypes on vacation.VacationTypeId equals vacationType.Id join user in db.UserProfiles on vacation.EmployeeUserId equals user.UserId where vacation.StartDate.Year == datetime.Year && vacation.EmployeeUserId == userId && vacation.StatusId == (int)completeStatus select new EmplyeeVacationDetails { Id = vacation.Id, EmployeeUserId = vacation.EmployeeUserId, EmployeeUserName = user.UserName, StatusId = vacation.StatusId, StatusName = status.Name, VacationTypeId = vacation.VacationTypeId, VacationTypeName = vacationType.Name, StartDate = vacation.StartDate, EndDate = vacation.EndDate, VacationDays = vacation.VacationDays }) .OrderByDescending(x => x.StartDate) .Skip(skipCount) .Take(takeCount) .ToList(); return(q); } }
public static void ChangeStatus(int Id, EVacationStatus status) { WorkFromHomeReopsitories.ChangeStatus(Id, status); }