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