/// <summary> /// Get Calender By Id /// </summary> /// <param name="calendar"></param> /// <returns></returns> public CalendarAddViewModel ViewCalendar(CalendarAddViewModel calendar) { try { CalendarAddViewModel calendarAddViewModel = new CalendarAddViewModel(); var calendarRepository = this.context?.SchoolCalendars.FirstOrDefault(x => x.TenantId == calendar.schoolCalendar.TenantId && x.SchoolId == calendar.schoolCalendar.SchoolId && x.CalenderId == calendar.schoolCalendar.CalenderId); if (calendarRepository != null) { calendar.schoolCalendar = calendarRepository; calendar._tenantName = calendar._tenantName; calendar._failure = false; return(calendar); } else { calendarAddViewModel._failure = true; calendarAddViewModel._message = NORECORDFOUND; return(calendarAddViewModel); } } catch (Exception es) { throw; } }
/// <summary> /// Delete Calendar /// </summary> /// <param name="calendar"></param> /// <returns></returns> public CalendarAddViewModel DeleteCalendar(CalendarAddViewModel calendar) { try { var calendarRepository = this.context?.SchoolCalendars.Where(x => x.CalenderId == calendar.schoolCalendar.CalenderId).ToList().OrderBy(x => x.CalenderId).LastOrDefault(); if (calendarRepository != null) { var eventsExist = this.context?.CalendarEvents.FirstOrDefault(x => x.TenantId == calendarRepository.TenantId && x.SchoolId == calendarRepository.SchoolId && x.CalendarId == calendarRepository.CalenderId); if (eventsExist != null) { calendar._message = "Calendar cannot deleted because it has event."; calendar._failure = true; } else { this.context?.SchoolCalendars.Remove(calendarRepository); this.context?.SaveChanges(); calendar._failure = false; calendar._message = "Deleted"; } } return(calendar); } catch (Exception ex) { throw ex; } }
/// <summary> /// Add calendar /// </summary> /// <param name="calendar"></param> /// <returns></returns> public CalendarAddViewModel AddCalendar(CalendarAddViewModel calendar) { //int? calenderId = Utility.GetMaxPK(this.context, new Func<SchoolCalendars, int>(x => x.CalenderId)); int?calenderId = 1; var calenderData = this.context?.SchoolCalendars.Where(x => x.TenantId == calendar.schoolCalendar.TenantId && x.SchoolId == calendar.schoolCalendar.SchoolId).OrderByDescending(x => x.CalenderId).FirstOrDefault(); if (calenderData != null) { calenderId = calenderData.CalenderId + 1; } calendar.schoolCalendar.CalenderId = (int)calenderId; calendar.schoolCalendar.LastUpdated = DateTime.UtcNow; var checkDefaultCalendar = this.context?.SchoolCalendars.Where(x => x.AcademicYear == calendar.schoolCalendar.AcademicYear && x.TenantId == calendar.schoolCalendar.TenantId && x.SchoolId == calendar.schoolCalendar.SchoolId).ToList().Find(x => x.DefaultCalender == true); if (checkDefaultCalendar == null) { calendar.schoolCalendar.DefaultCalender = true; } if (calendar.schoolCalendar.DefaultCalender == true) { (from p in this.context?.SchoolCalendars where p.TenantId == calendar.schoolCalendar.TenantId && p.SchoolId == calendar.schoolCalendar.SchoolId && p.AcademicYear == calendar.schoolCalendar.AcademicYear select p).ToList().ForEach(x => x.DefaultCalender = false); } this.context?.SchoolCalendars.Add(calendar.schoolCalendar); this.context?.SaveChanges(); calendar._failure = false; calendar._message = "Calendar Added Successfully"; return(calendar); }
public async Task <ActionResult> Add(CalendarAddViewModel data) { if (ModelState.IsValid) { try { data.active = true; data.createdBy = Session["user_id"].ToString(); List <CalendarCompanySetup> elements = new List <CalendarCompanySetup>(); { foreach (CalendarCompanySetup dp in data.companies) { elements.Add(new CalendarCompanySetup() { comp_id = dp.comp_id, createdDateTime = DateTime.Now, createdBy = Session["user_id"].ToString() }); } } data.companies = elements; var postTask = await client.PostAsJsonAsync("/api/Calendar/Add", data); if (postTask.IsSuccessStatusCode) { return(Json(true, JsonRequestBehavior.DenyGet)); } } catch { return(Json(false, JsonRequestBehavior.DenyGet)); } } return(Json(false, JsonRequestBehavior.DenyGet)); }
public ActionResult <CalendarAddViewModel> DeleteCalendar(CalendarAddViewModel calendar) { CalendarAddViewModel deleteCalendar = new CalendarAddViewModel(); try { deleteCalendar = _calendarService.DeleteCalendar(calendar); } catch (Exception es) { deleteCalendar._message = es.Message; deleteCalendar._failure = true; } return(deleteCalendar); }
public ActionResult <CalendarAddViewModel> UpdateCalendar(CalendarAddViewModel calendar) { CalendarAddViewModel calendarUpdate = new CalendarAddViewModel(); try { calendarUpdate = _calendarService.UpdateCalendar(calendar); } catch (Exception es) { calendarUpdate._failure = true; calendarUpdate._message = es.Message; } return(calendarUpdate); }
public ActionResult <CalendarAddViewModel> ViewCalendar(CalendarAddViewModel room) { CalendarAddViewModel viewCalendar = new CalendarAddViewModel(); try { viewCalendar = _calendarService.ViewCalendar(room); } catch (Exception es) { viewCalendar._failure = true; viewCalendar._message = es.Message; } return(viewCalendar); }
/// <summary> /// Update Calendar /// </summary> /// <param name="calendar"></param> /// <returns></returns> public CalendarAddViewModel UpdateCalendar(CalendarAddViewModel calendar) { CalendarAddViewModel calendarAddViewModel = new CalendarAddViewModel(); if (TokenManager.CheckToken(calendar._tenantName + calendar._userName, calendar._token)) { calendarAddViewModel = this.calendarRepository.UpdateCalendar(calendar); return(calendarAddViewModel); } else { calendarAddViewModel._failure = true; calendarAddViewModel._message = TOKENINVALID; return(calendarAddViewModel); } }
/// <summary> /// Update Calendar /// </summary> /// <param name="calendar"></param> /// <returns></returns> public CalendarAddViewModel UpdateCalendar(CalendarAddViewModel calendar) { try { var calendarRepository = this.context?.SchoolCalendars.FirstOrDefault(x => x.TenantId == calendar.schoolCalendar.TenantId && x.SchoolId == calendar.schoolCalendar.SchoolId && x.CalenderId == calendar.schoolCalendar.CalenderId); calendarRepository.SchoolId = calendar.schoolCalendar.SchoolId; calendarRepository.TenantId = calendar.schoolCalendar.TenantId; calendarRepository.Title = calendar.schoolCalendar.Title; calendarRepository.AcademicYear = calendar.schoolCalendar.AcademicYear; var checkDefaultCalendar = this.context?.SchoolCalendars.Where(x => x.AcademicYear == calendar.schoolCalendar.AcademicYear && x.TenantId == calendar.schoolCalendar.TenantId && x.SchoolId == calendar.schoolCalendar.SchoolId && x.CalenderId != calendar.schoolCalendar.CalenderId).ToList().Find(x => x.DefaultCalender == true); if (checkDefaultCalendar == null) { calendarRepository.DefaultCalender = true; } else { calendarRepository.DefaultCalender = calendar.schoolCalendar.DefaultCalender; } if (calendar.schoolCalendar.DefaultCalender == true) { (from p in this.context?.SchoolCalendars where p.CalenderId != calendarRepository.CalenderId && p.AcademicYear == calendar.schoolCalendar.AcademicYear && p.TenantId == calendar.schoolCalendar.TenantId && p.SchoolId == calendar.schoolCalendar.SchoolId select p).ToList().ForEach(x => x.DefaultCalender = false); } calendarRepository.Days = calendar.schoolCalendar.Days; calendarRepository.LastUpdated = DateTime.UtcNow; calendarRepository.VisibleToMembershipId = calendar.schoolCalendar.VisibleToMembershipId; calendarRepository.UpdatedBy = calendar.schoolCalendar.UpdatedBy; calendarRepository.StartDate = calendar.schoolCalendar.StartDate; calendarRepository.EndDate = calendar.schoolCalendar.EndDate; this.context?.SaveChanges(); calendar._failure = false; return(calendar); } catch (Exception ex) { calendar.schoolCalendar = null; calendar._failure = true; calendar._message = NORECORDFOUND; return(calendar); } }
/// <summary> /// Add calendar /// </summary> /// <param name="calendar"></param> /// <returns></returns> public CalendarAddViewModel AddCalendar(CalendarAddViewModel calendar) { int?calenderId = Utility.GetMaxPK(this.context, new Func <SchoolCalendars, int>(x => x.CalenderId)); calendar.schoolCalendar.CalenderId = (int)calenderId; calendar.schoolCalendar.LastUpdated = DateTime.UtcNow; var checkDefaultCalendar = this.context?.SchoolCalendars.Where(x => x.AcademicYear == calendar.schoolCalendar.AcademicYear && x.TenantId == calendar.schoolCalendar.TenantId && x.SchoolId == calendar.schoolCalendar.SchoolId).ToList().Find(x => x.DefaultCalender == true); if (checkDefaultCalendar == null) { calendar.schoolCalendar.DefaultCalender = true; } if (calendar.schoolCalendar.DefaultCalender == true) { (from p in this.context?.SchoolCalendars where p.TenantId == calendar.schoolCalendar.TenantId && p.SchoolId == calendar.schoolCalendar.SchoolId && p.AcademicYear == calendar.schoolCalendar.AcademicYear select p).ToList().ForEach(x => x.DefaultCalender = false); } this.context?.SchoolCalendars.Add(calendar.schoolCalendar); this.context?.SaveChanges(); return(calendar); }
/// <summary> /// Delete Calendar /// </summary> /// <param name="calendar"></param> /// <returns></returns> public CalendarAddViewModel DeleteCalendar(CalendarAddViewModel calendar) { CalendarAddViewModel calendarDelete = new CalendarAddViewModel(); try { if (TokenManager.CheckToken(calendar._tenantName + calendar._userName, calendar._token)) { calendarDelete = this.calendarRepository.DeleteCalendar(calendar); } else { calendarDelete._failure = true; calendarDelete._message = TOKENINVALID; } } catch (Exception es) { calendarDelete._failure = true; calendarDelete._message = es.Message; } return(calendarDelete); }
public ActionResult Add() { CalendarAddViewModel model = new CalendarAddViewModel(); return(View("Add", model)); }
/// <summary> /// Update Calendar /// </summary> /// <param name="calendar"></param> /// <returns></returns> public CalendarAddViewModel UpdateCalendar(CalendarAddViewModel calendar) { try { var calendarRepository = this.context?.SchoolCalendars.FirstOrDefault(x => x.TenantId == calendar.schoolCalendar.TenantId && x.SchoolId == calendar.schoolCalendar.SchoolId && x.CalenderId == calendar.schoolCalendar.CalenderId); var enrollmentCalendar = this.context?.StudentEnrollment.FirstOrDefault(x => x.TenantId == calendar.schoolCalendar.TenantId && x.SchoolId == calendar.schoolCalendar.SchoolId && x.CalenderId == calendar.schoolCalendar.CalenderId && x.IsActive == true); if (enrollmentCalendar != null) { calendarRepository.Title = calendar.schoolCalendar.Title; calendar._message = "Calendar Updated Successfully"; this.context.SaveChanges(); return(calendar); } var courseSectionCalendar = this.context?.CourseSection.FirstOrDefault(x => x.TenantId == calendar.schoolCalendar.TenantId && x.SchoolId == calendar.schoolCalendar.SchoolId && x.CalendarId == calendar.schoolCalendar.CalenderId && x.IsActive == true); if (courseSectionCalendar != null) { calendarRepository.Title = calendar.schoolCalendar.Title; calendar._message = "Calendar Updated Successfully"; this.context.SaveChanges(); return(calendar); } var checkDefaultCalendar = this.context?.SchoolCalendars.Where(x => x.AcademicYear == calendar.schoolCalendar.AcademicYear && x.TenantId == calendar.schoolCalendar.TenantId && x.SchoolId == calendar.schoolCalendar.SchoolId && x.CalenderId != calendar.schoolCalendar.CalenderId).ToList().Find(x => x.DefaultCalender == true); if (checkDefaultCalendar == null) { calendar.schoolCalendar.DefaultCalender = true; } else { var enrollmentDefaultCalendar = this.context?.StudentEnrollment.FirstOrDefault(x => x.TenantId == calendar.schoolCalendar.TenantId && x.SchoolId == calendar.schoolCalendar.SchoolId && x.CalenderId == checkDefaultCalendar.CalenderId); if (enrollmentDefaultCalendar != null && calendar.schoolCalendar.DefaultCalender == true) { calendar.schoolCalendar = null; calendar._failure = true; calendar._message = "Existing Default Calendar cannot be updated because it has already enrollment."; return(calendar); } //calendarRepository.DefaultCalender = calendar.schoolCalendar.DefaultCalender; } if (calendar.schoolCalendar.DefaultCalender == true) { (from p in this.context?.SchoolCalendars where p.CalenderId != calendarRepository.CalenderId && p.AcademicYear == calendar.schoolCalendar.AcademicYear && p.TenantId == calendar.schoolCalendar.TenantId && p.SchoolId == calendar.schoolCalendar.SchoolId select p).ToList().ForEach(x => x.DefaultCalender = false); } calendar.schoolCalendar.LastUpdated = DateTime.Now; this.context.Entry(calendarRepository).CurrentValues.SetValues(calendar.schoolCalendar); this.context?.SaveChanges(); this.context?.SaveChanges(); calendar._failure = false; calendar._message = "Calendar Updated Successfully"; return(calendar); } catch (Exception ex) { calendar.schoolCalendar = null; calendar._failure = true; calendar._message = NORECORDFOUND; return(calendar); } }