/// <summary>
/// Get Calender Event By Id
/// </summary>
/// <param name="calendarEvent"></param>
/// <returns></returns>
public CalendarEventAddViewModel ViewCalendarEvent(CalendarEventAddViewModel calendarEvent)
{
try
{
CalendarEventAddViewModel calendarEventAddViewModel = new CalendarEventAddViewModel();
var calendarEventRepository = this.context?.CalendarEvents.FirstOrDefault(x => x.TenantId == calendarEvent.schoolCalendarEvent.TenantId && x.SchoolId == calendarEvent.schoolCalendarEvent.SchoolId && x.EventId == calendarEvent.schoolCalendarEvent.EventId);
if (calendarEventRepository != null)
{
calendarEventAddViewModel.schoolCalendarEvent = calendarEventRepository;
calendarEventAddViewModel._tenantName = calendarEvent._tenantName;
calendarEventAddViewModel._failure = false;
return(calendarEventAddViewModel);
}
else
{
calendarEventAddViewModel._failure = true;
calendarEventAddViewModel._message = NORECORDFOUND;
return(calendarEventAddViewModel);
}
}
catch (Exception es)
{
throw;
}
}
/// <summary>
/// Update Calendar Event
/// </summary>
/// <param name="calendarEvent"></param>
/// <returns></returns>
public CalendarEventAddViewModel UpdateCalendarEvent(CalendarEventAddViewModel calendarEvent)
{
try
{
var calendarEventRepository = this.context?.CalendarEvents.FirstOrDefault(x => x.TenantId == calendarEvent.schoolCalendarEvent.TenantId && x.SchoolId == calendarEvent.schoolCalendarEvent.SchoolId && x.EventId == calendarEvent.schoolCalendarEvent.EventId);
calendarEventRepository.SchoolId = calendarEvent.schoolCalendarEvent.SchoolId;
calendarEventRepository.TenantId = calendarEvent.schoolCalendarEvent.TenantId;
calendarEventRepository.Title = calendarEvent.schoolCalendarEvent.Title;
calendarEventRepository.AcademicYear = calendarEvent.schoolCalendarEvent.AcademicYear;
calendarEventRepository.Description = calendarEvent.schoolCalendarEvent.Description;
calendarEventRepository.VisibleToMembershipId = calendarEvent.schoolCalendarEvent.VisibleToMembershipId;
calendarEventRepository.SchoolDate = calendarEvent.schoolCalendarEvent.SchoolDate;
calendarEventRepository.LastUpdated = DateTime.UtcNow;
calendarEventRepository.EventColor = calendarEvent.schoolCalendarEvent.EventColor;
calendarEventRepository.SystemWideEvent = calendarEvent.schoolCalendarEvent.SystemWideEvent;
calendarEventRepository.StartDate = calendarEvent.schoolCalendarEvent.StartDate;
calendarEventRepository.EndDate = calendarEvent.schoolCalendarEvent.EndDate;
calendarEventRepository.UpdatedBy = calendarEvent.schoolCalendarEvent.UpdatedBy;
this.context?.SaveChanges();
calendarEvent._failure = false;
return(calendarEvent);
}
catch (Exception ex)
{
calendarEvent.schoolCalendarEvent = null;
calendarEvent._failure = true;
calendarEvent._message = NORECORDFOUND;
return(calendarEvent);
}
}
/// <summary>
/// Add new Calendar Event
/// </summary>
/// <param name="calendarEvent"></param>
/// <returns></returns>
public CalendarEventAddViewModel AddCalendarEvent(CalendarEventAddViewModel calendarEvent)
{
int?eventId = Utility.GetMaxPK(this.context, new Func <CalendarEvents, int>(x => x.EventId));
calendarEvent.schoolCalendarEvent.EventId = (int)eventId;
calendarEvent.schoolCalendarEvent.LastUpdated = DateTime.UtcNow;
this.context?.CalendarEvents.Add(calendarEvent.schoolCalendarEvent);
this.context?.SaveChanges();
return(calendarEvent);
}
public ActionResult <CalendarEventAddViewModel> DeleteCalendarEvent(CalendarEventAddViewModel calendarEvent)
{
CalendarEventAddViewModel deleteCalendarEvent = new CalendarEventAddViewModel();
try
{
deleteCalendarEvent = _calendarEventService.DeleteCalendarEvent(calendarEvent);
}
catch (Exception es)
{
deleteCalendarEvent._failure = true;
deleteCalendarEvent._message = es.Message;
}
return(deleteCalendarEvent);
}
public ActionResult <CalendarEventAddViewModel> UpdateCalendarEvent(CalendarEventAddViewModel calendar)
{
CalendarEventAddViewModel calendarEventUpdate = new CalendarEventAddViewModel();
try
{
calendarEventUpdate = _calendarEventService.UpdateCalendarEvent(calendar);
}
catch (Exception es)
{
calendarEventUpdate._failure = true;
calendarEventUpdate._message = es.Message;
}
return(calendarEventUpdate);
}
public ActionResult <CalendarEventAddViewModel> ViewCalendarEvent(CalendarEventAddViewModel calendarEvent)
{
CalendarEventAddViewModel viewCalendar = new CalendarEventAddViewModel();
try
{
viewCalendar = _calendarEventService.ViewCalendarEvent(calendarEvent);
}
catch (Exception es)
{
viewCalendar._failure = true;
viewCalendar._message = es.Message;
}
return(viewCalendar);
}
public ActionResult <CalendarEventAddViewModel> AddCalendarEvent(CalendarEventAddViewModel calendarEvent)
{
CalendarEventAddViewModel calendarEventAdd = new CalendarEventAddViewModel();
try
{
calendarEventAdd = _calendarEventService.AddCalendarEvent(calendarEvent);
}
catch (Exception es)
{
calendarEventAdd._failure = true;
calendarEventAdd._message = es.Message;
}
return(calendarEventAdd);
}
/// <summary>
/// Update Calendar Event
/// </summary>
/// <param name="calendarEvent"></param>
/// <returns></returns>
public CalendarEventAddViewModel UpdateCalendarEvent(CalendarEventAddViewModel calendarEvent)
{
CalendarEventAddViewModel CalendarEventAddViewModel = new CalendarEventAddViewModel();
if (TokenManager.CheckToken(calendarEvent._tenantName + calendarEvent._userName, calendarEvent._token))
{
CalendarEventAddViewModel = this.calendarEventRepository.UpdateCalendarEvent(calendarEvent);
return(CalendarEventAddViewModel);
}
else
{
CalendarEventAddViewModel._failure = true;
CalendarEventAddViewModel._message = TOKENINVALID;
return(CalendarEventAddViewModel);
}
}
/// <summary>
/// Delete Calendar Event
/// </summary>
/// <param name="calendarEvent"></param>
/// <returns></returns>
public CalendarEventAddViewModel DeleteCalendarEvent(CalendarEventAddViewModel calendarEvent)
{
CalendarEventAddViewModel deleteCalendarEvent = new CalendarEventAddViewModel();
if (TokenManager.CheckToken(calendarEvent._tenantName, calendarEvent._token))
{
deleteCalendarEvent = this.calendarEventRepository.DeleteCalendarEvent(calendarEvent);
return(deleteCalendarEvent);
}
else
{
deleteCalendarEvent._failure = true;
deleteCalendarEvent._message = TOKENINVALID;
return(deleteCalendarEvent);
}
}
/// <summary>
/// Add new Calendar Event
/// </summary>
/// <param name="calendarEvent"></param>
/// <returns></returns>
public CalendarEventAddViewModel AddCalendarEvent(CalendarEventAddViewModel calendarEvent)
{
//int? eventId = Utility.GetMaxPK(this.context, new Func<CalendarEvents, int>(x => x.EventId));
int?eventId = 1;
var eventData = this.context?.CalendarEvents.Where(x => x.TenantId == calendarEvent.schoolCalendarEvent.TenantId && x.SchoolId == calendarEvent.schoolCalendarEvent.SchoolId).OrderByDescending(x => x.EventId).FirstOrDefault();
if (eventData != null)
{
eventId = eventData.EventId + 1;
}
calendarEvent.schoolCalendarEvent.EventId = (int)eventId;
calendarEvent.schoolCalendarEvent.LastUpdated = DateTime.UtcNow;
this.context?.CalendarEvents.Add(calendarEvent.schoolCalendarEvent);
this.context?.SaveChanges();
calendarEvent._failure = false;
calendarEvent._message = "Calendar Event Added Successfully";
return(calendarEvent);
}
/// <summary>
/// Delete Calendar Event
/// </summary>
/// <param name="calendarEvent"></param>
/// <returns></returns>
public CalendarEventAddViewModel DeleteCalendarEvent(CalendarEventAddViewModel calendarEvent)
{
try
{
var calendarEventRepository = this.context?.CalendarEvents.Where(x => x.EventId == calendarEvent.schoolCalendarEvent.EventId).ToList().OrderBy(x => x.EventId).LastOrDefault();
if (calendarEventRepository != null)
{
this.context?.CalendarEvents.Remove(calendarEventRepository);
this.context?.SaveChanges();
calendarEvent._failure = false;
calendarEvent._message = "Calendar Event Deleted Successfully";
}
}
catch (Exception ex)
{
calendarEvent._message = ex.Message;
calendarEvent._failure = true;
}
return(calendarEvent);
}
/// <summary>
/// Update Calendar Event
/// </summary>
/// <param name="calendarEvent"></param>
/// <returns></returns>
public CalendarEventAddViewModel UpdateCalendarEvent(CalendarEventAddViewModel calendarEvent)
{
try
{
var calendarEventRepository = this.context?.CalendarEvents.FirstOrDefault(x => x.TenantId == calendarEvent.schoolCalendarEvent.TenantId && x.SchoolId == calendarEvent.schoolCalendarEvent.SchoolId && x.EventId == calendarEvent.schoolCalendarEvent.EventId);
calendarEvent.schoolCalendarEvent.LastUpdated = DateTime.Now;
this.context.Entry(calendarEventRepository).CurrentValues.SetValues(calendarEvent.schoolCalendarEvent);
this.context?.SaveChanges();
calendarEvent._failure = false;
calendarEvent._message = "Calendar Event Updated Successfully";
return(calendarEvent);
}
catch (Exception ex)
{
calendarEvent.schoolCalendarEvent = null;
calendarEvent._failure = true;
calendarEvent._message = NORECORDFOUND;
return(calendarEvent);
}
}
