public CalendarModel generateCalendar(YearMonthModel ymmodel)//, string userID) { //create a new calendar model CalendarModel newCalendar = new CalendarModel(); //get bankholidays, vacations and populate calendar var bankholidays = BhR.GetBankHolidays(); var vacations = Vacations.GetVacations(); newCalendar.monthdays = new System.Collections.Generic.List <DayModel>(); newCalendar.bankholidays = bankholidays; newCalendar.vacations = vacations; //get our month days number and parse it var mdays = DateTime.DaysInMonth(ymmodel.year, ymmodel.month); for (var iter = 1; iter <= mdays; iter++) { //default values for descriptions and freeday var descriptionStatus = "busy"; var isFreeDayStatus = false; //next day and check if its weekend, bankholiday or vacation day var currentDate = new DateTime(ymmodel.year, ymmodel.month, iter); if ((currentDate.DayOfWeek == DayOfWeek.Saturday) || (currentDate.DayOfWeek == DayOfWeek.Sunday)) { descriptionStatus = "Weekend"; isFreeDayStatus = true; } if (bankholidays.Any(x => x.Month == currentDate.Month && x.Day == iter)) { isFreeDayStatus = true; descriptionStatus += " BankHoliday"; } var CurrentUserID = User.Identity.GetUserId(); var check = newdb.UserDetails.FirstOrDefault(d => d.UserID == CurrentUserID); if (vacations.Any(x => x.UserId == check.ID && x.StartDate <= currentDate && x.EndDate >= currentDate && x.StateId == 1)) { descriptionStatus += " Want to go to Vacation"; } if (vacations.Any(x => x.UserId == check.ID && x.StartDate <= currentDate && x.EndDate >= currentDate && x.StateId == 2)) { isFreeDayStatus = true; descriptionStatus += " Vacation"; } //add it to our list newCalendar.monthdays.Add(new DayModel { description = descriptionStatus, day = iter, name = currentDate.ToString("dddd"), isFreeDay = isFreeDayStatus }); } //return our calendar return(newCalendar); }
// GET: Dashboard public ActionResult Index() { DashboardViewModel dashboardVM = new DashboardViewModel() { Test = "Test Value" }; dashboardVM.UsersList = UserDetailsRepo.GetUsers(); ////////////////////////////////////// dashboardVM.Teams = TeamRepo.GetTeams(); dashboardVM.CalendarViewModel.BankHolidays = BankHolidayRepo.GetBankHolidays(); dashboardVM.CalendarViewModel.Vacations = VacationRepo.GetVacations(); dashboardVM.CalendarViewModel.MonthDays = new List <MonthDaysViewModel>(); //dashboardVM.CalendarViewModel.MonthDays.Day = for (int i = 1; i <= DateTime.DaysInMonth(2017, 7); i++) { DateTime dt = new DateTime(2017, 7, i); string aux = dt.DayOfWeek.ToString(); dashboardVM.CalendarViewModel.MonthDays.Add(new MonthDaysViewModel(i, false, aux)); }//ajax call from javascript ////////////////////////////////////// //dashboardVM.Test = dashboardVM.UsersList[0].FirstName; return(View("Index", dashboardVM)); }
// GET: Dashboard public ActionResult Index() { var DbUsers = db.UserDetailsModel.ToList(); DashboardViewModels dashboardVM = new DashboardViewModels(); UserDetailsRepository UDR = new UserDetailsRepository(); dashboardVM.UserList = UDR.GetUsers(); TeamRepository TR = new TeamRepository(); dashboardVM.TeamList = TR.GetTeams(); List <IdentityRole> roles = db.Roles.ToList(); dashboardVM.RoleList = roles; VacationRepository vac = new VacationRepository(); BankHolidayRepository bank = new BankHolidayRepository(); CalendarViewModel calendar = new CalendarViewModel(); calendar.BankHolidayList = bank.GetBankHolidays(); calendar.VacationList = vac.GetVacations(); dashboardVM.Calendar = calendar; return(View(dashboardVM)); }
private List <MonthDayViewModel> GetMonthDays(int year, int month) { List <MonthDayViewModel> days = new List <MonthDayViewModel>(); var bankHolidays = getBankHoliday.GetBankHolidays();; DateTime now = DateTime.Now; int countOfDays = DateTime.DaysInMonth(year, month); var holidays = vacRep.GetVacations(); for (int i = 1; i <= countOfDays; i++) { DateTime date = new DateTime(year, month, i); MonthDayViewModel day = new MonthDayViewModel(); day.Day = i; day.Name = date.DayOfWeek.ToString(); var bH = bankHolidays.FirstOrDefault(x => x.Day == i && x.Month == month); day.IsFreeDay = date.DayOfWeek == DayOfWeek.Saturday || date.DayOfWeek == DayOfWeek.Sunday || bH != null; day.Vacations = holidays.Where(x => DateTime.Compare(x.StartDate, date) <= 0 && DateTime.Compare(x.EndDate, date) >= 0).ToList(); day.Description = date.ToString("MMMM"); DateTimeFormatInfo mfi = new DateTimeFormatInfo(); day.Month = mfi.GetMonthName(month).ToString(); days.Add(day); } return(days); }
// GET: Dashboard public ActionResult Index() { var users = database.GetUsers(); var teams = db.GetTeams(); var roles = newdb.Roles.ToList(); DashboardViewModel dash = new DashboardViewModel() { UserList = users, TeamList = teams, Roles = roles }; CalendarViewModel Calendar = new CalendarViewModel() { BankHolidays = bank.GetBankHolidays(), Vacations = vakacio.GetVacations() }; VacationRepository vakrep = new VacationRepository(); var datum = DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month); var free = vakrep.GetVacations(); for (int i = 1; i <= datum; ++i) { var date = new DateTime(DateTime.Now.Year, DateTime.Now.Month, i); bool isFreeDay = date.DayOfWeek == DayOfWeek.Saturday || date.DayOfWeek == DayOfWeek.Sunday; MonthDayViewModel day = new MonthDayViewModel() { Day = i, Name = date.DayOfWeek.ToString(), IsFreeDay = isFreeDay }; var vakacio = Calendar.BankHolidays.FirstOrDefault(x => x.Day == i && x.Month == DateTime.Now.Month); day.IsFreeDay = date.DayOfWeek == DayOfWeek.Saturday || date.DayOfWeek == DayOfWeek.Sunday || vakacio != null; day.Vacations = free.Where(x => DateTime.Compare(x.StartDate, date) <= 0 || DateTime.Compare(x.EndDate, date) >= 0).ToList(); Calendar.MonthDays.Add(day); } ; dash.Calendar = Calendar; return(View(dash)); }
private List <Vacation> CreateVacationList() { List <Vacation> vacationlist = new List <Vacation> { }; VacationRepository vacations = new VacationRepository(); HolidayManagementContext database = new HolidayManagementContext(); var vac = vacations.GetVacations(); foreach (var v in vac) { if (v.StateId == 1 || v.StateId == 4) { vacationlist.Add(v); } } return(vacationlist); }
public CalendarViewModel getMonthDays(AjaxDateModel model) { CalendarViewModel calendar = new CalendarViewModel(); calendar.Vacations = vacationrepo.GetVacations(); calendar.BankHolidays = bankHolidayrepo.GetBankHolidays(); var numberOfDays = DateTime.DaysInMonth(model.year, model.month); for (int i = 1; i <= numberOfDays; ++i) { var date = new DateTime(model.year, model.month, i); MonthDayViewModel day = new MonthDayViewModel(); day.day = i; day.nameOfDay = date.DayOfWeek.ToString(); var holiday = calendar.BankHolidays.FirstOrDefault(x => x.Day == i && x.Month == model.month); if (holiday != null) { day.isFreeDay = true; day.description = holiday.Description; } else { if (day.nameOfDay == "Sunday" || day.nameOfDay == "Saturday") { day.isFreeDay = true; day.description = "Weekend"; } else { day.isFreeDay = false; day.description = null; } } calendar.MonthDays.Add(day); } return(calendar); }
public IActionResult getVacations() { return(Ok(vacationRepository.GetVacations())); }