/// <summary> /// Deletes Existing Holiday /// </summary> /// <param name="holiday"></param> /// <returns></returns> public bool DeleteHoliday(businessAdminModel.Holiday holiday) { try { bool isDeletedSuccesfully = false; bool isUpdatedBusinessDays = false; DateDimension dayInQuestion = _m3pactContext.DateDimension.FirstOrDefault(day => day.DateKey == holiday.DateKey); if (dayInQuestion != null) { if (dayInQuestion.Date.Day == holiday.HolidayDate.Day && dayInQuestion.Date.Month == holiday.HolidayDate.Month && dayInQuestion.Date.Year == holiday.HolidayDate.Year) { dayInQuestion.IsHoliday = false; } isDeletedSuccesfully = _m3pactContext.SaveChanges() > 0; isUpdatedBusinessDays = UpdateBusinessDays(holiday.HolidayDate.Year); } return(isDeletedSuccesfully && isUpdatedBusinessDays); } catch (Exception ex) { throw ex; } }
/// <summary> /// Edits the Selected Holiday /// </summary> /// <param name="holiday"></param> /// <returns></returns> public bool AddOrEditHoliday(businessAdminModel.Holiday holiday) { try { bool isEditedSuccesfully = false; bool isUpdatedBusinessDays = false; if (holiday != null && holiday.HolidayDate != null) { DateDimension dayInQuestion = _m3pactContext.DateDimension.FirstOrDefault(day => day.DateKey == holiday.DateKey); if (dayInQuestion != null) { if (dayInQuestion.Date.Day == holiday.HolidayDate.Day && dayInQuestion.Date.Month == holiday.HolidayDate.Month && dayInQuestion.Date.Year == holiday.HolidayDate.Year) { dayInQuestion.HolidayText = holiday.HolidayName; } else { dayInQuestion.IsHoliday = false; dayInQuestion.HolidayText = string.Empty; DateDimension dayToUpdate = _m3pactContext.DateDimension.FirstOrDefault(day => day.Day == holiday.HolidayDate.Day && day.Month == holiday.HolidayDate.Month && day.Year == holiday.HolidayDate.Year); if (dayToUpdate != null) { dayToUpdate.HolidayText = holiday.HolidayName; dayToUpdate.IsHoliday = true; } } } else { DateDimension dayToUpdate = _m3pactContext.DateDimension.FirstOrDefault(day => day.Day == holiday.HolidayDate.Day && day.Month == holiday.HolidayDate.Month && day.Year == holiday.HolidayDate.Year); if (dayToUpdate != null) { dayToUpdate.HolidayText = holiday.HolidayName; dayToUpdate.IsHoliday = true; } } isEditedSuccesfully = _m3pactContext.SaveChanges() > 0; if (dayInQuestion != null && string.IsNullOrEmpty(dayInQuestion.HolidayText)) { isUpdatedBusinessDays = UpdateBusinessDays(dayInQuestion.Date.Year); } else { isUpdatedBusinessDays = UpdateBusinessDays(holiday.HolidayDate.Year); } } return(isEditedSuccesfully && isUpdatedBusinessDays); } catch (Exception ex) { throw ex; } }