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