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