public static void InsertNewWrokFromHomeRequest(WorkFromHomeModel model) { VacationYear vacationYear = VacationYearsLogic.GetCurrentVacationYear(); model.WorkFromHomeDay.VacationYearId = vacationYear.Id; WorkFromHomeReopsitories.InsertNewEmployeeWorkFromHome(model.WorkFromHomeDay); }
public static void InsertNewVacationYear(VacationYear vacationYear) { using (ManagementSystemEntities db = new ManagementSystemEntities()) { db.VacationYears.Add(vacationYear); db.SaveChanges(); } }
public static List <RequestFromHomeDayDetails> GetEmployeeWorkFromHomeDaysList(int page, int statusId) { int takeCount = Config.PageItemCount(); int skipCount = page * takeCount; VacationYear vacationYear = VacationYearsLogic.GetCurrentVacationYear(); int vacationYearId = vacationYear.Id; return(WorkFromHomeReopsitories.GetEmployeeWorkFromHomeDaysList(statusId, vacationYearId, DateTimeHelper.Today(), skipCount, takeCount)); }
public static void DeleteVacationYear(int id) { using (ManagementSystemEntities db = new ManagementSystemEntities()) { VacationYear vacationYearItem = db.VacationYears.FirstOrDefault(a => a.Id == id); if (vacationYearItem != null) { vacationYearItem.IsDeleted = true; db.SaveChanges(); } } }
public static VacationYear GetNextVacationYear() { using (ManagementSystemEntities db = new ManagementSystemEntities()) { DateTime nextYearDateTime = DateTime.Now.AddYears(1); VacationYear vacationYear = db.VacationYears .FirstOrDefault(a => a.StartDate.Year == nextYearDateTime.Year && a.IsDeleted == false); return(vacationYear); } }
// // GET: /OccasionVacations/ public ActionResult Index(VacationYear vacationYear) { OccasionVacation occassionVacation = new OccasionVacation() { VacationYearId = vacationYear.Id, VacationYearStatusId = vacationYear.VacationYearStatusId, StartDate = (vacationYear.StartDate).ToString("yyyy/MM/dd"), EndDate = (vacationYear.EndDate).ToString("yyyy/MM/dd") }; return(View(occassionVacation)); }
public static bool IsDateValid(DateTime date, int?vacationYearId) { using (ManagementSystemEntities db = new ManagementSystemEntities()) { VacationYear vacationYear = db.VacationYears.FirstOrDefault(a => a.IsDeleted == false && a.Id == vacationYearId); if (vacationYear != null) { if (date >= vacationYear.StartDate && date <= vacationYear.EndDate) { return(true); } } return(false); } }
public static VacationYear GetCurrentVacationYear() { using (ManagementSystemEntities db = new ManagementSystemEntities()) { DateTime currentYearDateTime = DateTime.Now; VacationYear vacationYear = db.VacationYears.FirstOrDefault(a => a.StartDate.Year == currentYearDateTime.Year && a.IsDeleted == false); if (vacationYear != null) { if (!vacationYear.IsCurrent) { vacationYear.IsCurrent = true; db.SaveChanges(); } } return(vacationYear); } }
public static VacationYear GetNextVacationYear() { VacationYear nextVacationYear = VacationYearsRepositories.GetNextVacationYear(); if (nextVacationYear == null) { nextVacationYear = new VacationYear(); nextVacationYear.CreateDate = DateTime.Now; DateTime nextYearDateTime = DateTime.Now.AddYears(1); nextVacationYear.YearName = nextYearDateTime.Year.ToString(); nextVacationYear.StartDate = new DateTime(nextYearDateTime.Year, 1, 1); nextVacationYear.EndDate = new DateTime(nextYearDateTime.Year, 12, 31); nextVacationYear.IsCurrent = false; VacationYearsRepositories.InsertNewVacationYear(nextVacationYear); } nextVacationYear.VacationYearStatusId = (int)Y.Next; return(nextVacationYear); }
public static VacationYear GetCurrentVacationYear() { VacationYear currentVacationYear = VacationYearsRepositories.GetCurrentVacationYear(); if (currentVacationYear == null) { currentVacationYear = new VacationYear(); currentVacationYear.CreateDate = DateTime.Now; DateTime currentYearDateTime = DateTime.Now; currentVacationYear.YearName = currentYearDateTime.Year.ToString(); currentVacationYear.StartDate = new DateTime(currentYearDateTime.Year, 1, 1); currentVacationYear.EndDate = new DateTime(currentYearDateTime.Year, 12, 31); currentVacationYear.IsCurrent = true; VacationYearsRepositories.InsertNewVacationYear(currentVacationYear); } currentVacationYear.VacationYearStatusId = (int)Y.Current; return(currentVacationYear); }