/// <summary>
///
/// </summary>
/// <param name="calendarId"></param>
/// <param name="calendarType"></param>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <param name="group"></param>
/// <param name="reportOnGroupedEventsOnly">when true, it reports on events attached to the group only.</param>
/// <returns></returns>
public static CalendarReport GetReportForCalendar(Guid calendarId, string calendarType, DateTime startDate, DateTime endDate, long group, bool reportOnGroupedEventsOnly)
{
CalendarReport report = new CalendarReport();
var memId = RDN.Library.Classes.Account.User.GetMemberId();
var leagueId = MemberCache.GetLeagueIdOfMember(memId);
try
{
report.EndDateSelected = new DateTime(endDate.Year, endDate.Month, endDate.Day, 23, 59, 59);
report.StartDateSelected = startDate;
report.CalendarId = calendarId;
report.EntityName = calendarType;
report.IsSubmitted = true;
report.TotalPointsAllowed = 0;
TimeSpan daysReporting = endDate - startDate;
report.DaysBackwards = daysReporting.Days;
var dc = new ManagementContext();
var cal = (from xx in dc.Calendar
where xx.CalendarId == calendarId
select xx).FirstOrDefault();
report.NotPresentForCheckIn = cal.NotPresentCheckIn;
List<DataModels.Calendar.CalendarEvent> events = new List<DataModels.Calendar.CalendarEvent>();
List<MemberDisplay> members = new List<MemberDisplay>();
if (group == 0) //no grops were selected
{
members = MemberCache.GetLeagueMembers(memId, leagueId);
events = cal.CalendarEvents.Where(x => x.StartDate >= startDate).Where(x => x.EndDate < endDate).Where(x => x.IsRemovedFromCalendar == false).Where(x => x.Groups.Count == 0).ToList();
}
else
{
var groups = MemberCache.GetLeagueGroupsOfMember(memId);
var groupTemp = groups.Where(x => x.Id == group).FirstOrDefault();
if (groupTemp != null)
foreach (var mem in groupTemp.GroupMembers)
{
MemberDisplay m = new MemberDisplay();
m.DerbyName = mem.DerbyName;
m.Firstname = mem.Firstname;
m.LastName = mem.LastName;
m.MemberId = mem.MemberId;
m.PlayerNumber = mem.PlayerNumber;
members.Add(m);
}
if (reportOnGroupedEventsOnly)
events = cal.CalendarEvents.Where(x => x.StartDate >= startDate).Where(x => x.EndDate < endDate).Where(x => x.IsRemovedFromCalendar == false).Where(x => x.Groups.Select(y => y.Group.Id).Contains(group)).ToList();
else
events = cal.CalendarEvents.Where(x => x.StartDate >= startDate).Where(x => x.EndDate < endDate).Where(x => x.IsRemovedFromCalendar == false).ToList();
}
foreach (var calEvent in events)
{
int eventTypeOccured = 0;
EventForReport blah = new EventForReport();
blah.AllowSelfCheckIn = calEvent.AllowSelfCheckIn;
blah.CalendarItemId = calEvent.CalendarItemId;
blah.Name = calEvent.Name;
blah.Notes = calEvent.Notes;
if (!calEvent.IsInUTCTime)
{
blah.StartDate = calEvent.StartDate;
blah.EndDate = calEvent.EndDate;
}
else
{
blah.StartDate = calEvent.StartDate + new TimeSpan(cal.TimeZone, 0, 0);
blah.EndDate = calEvent.EndDate + new TimeSpan(cal.TimeZone, 0, 0);
}
blah.TimeSpan = (blah.EndDate - blah.StartDate).Ticks;
if (calEvent.EventType != null)
{
blah.EventType.EventTypeName = calEvent.EventType.EventTypeName;
blah.EventType.PointsForExcused = calEvent.EventType.PointsForExcused;
blah.EventType.PointsForNotPresent = calEvent.EventType.PointsForNotPresent;
blah.EventType.PointsForPartial = calEvent.EventType.PointsForPartial;
blah.EventType.PointsForPresent = calEvent.EventType.PointsForPresent;
blah.EventType.PointsForTardy = calEvent.EventType.PointsForTardy;
blah.EventType.CalendarEventTypeId = calEvent.EventType.CalendarEventTypeId;
var eventTypeReporting = report.EventTypesReport.Where(x => x.CalendarEventTypeId == calEvent.EventType.CalendarEventTypeId).FirstOrDefault();
if (eventTypeReporting == null)
{
EventTypeForReport evForReport = new EventTypeForReport();
evForReport.EventTypeName = calEvent.EventType.EventTypeName;
evForReport.PointsForExcused = calEvent.EventType.PointsForExcused;
evForReport.PointsForNotPresent = calEvent.EventType.PointsForNotPresent;
evForReport.PointsForPartial = calEvent.EventType.PointsForPartial;
evForReport.PointsForPresent = calEvent.EventType.PointsForPresent;
evForReport.PointsForTardy = calEvent.EventType.PointsForTardy;
evForReport.CalendarEventTypeId = calEvent.EventType.CalendarEventTypeId;
evForReport.TotalTimesEventTypeOccured = 1;
eventTypeOccured = evForReport.TotalTimesEventTypeOccured;
report.EventTypesReport.Add(evForReport);
}
else
{
eventTypeReporting.TotalTimesEventTypeOccured += 1;
eventTypeOccured = eventTypeReporting.TotalTimesEventTypeOccured;
}
}
if (report.NotPresentForCheckIn == false)
{
SaveAttendeesWithNotPresentCheckIn(members, report, calEvent, blah);
}
else
{
SaveAttendeesWithNotPresentNeeded(members, report, calEvent, blah);
}
report.Events.Add(blah);
}
report.Attendees = report.Attendees.OrderBy(x => x.MemberName).ToList();
report.TotalEventsCount = report.Events.Count;
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
return report;
}
/// <summary>
/// for the attendees of a report where Not Present attendance checkin isn't needed
/// to adjust attendance percentage.
/// cycles through all the members of the league. So that we can check who attended and who didn't.
/// Not Efficient.
/// Needs to be Mirrored with SaveAttendeesWithNotPresentCheckIn
///
/// for each event, we cycle through all the members.
/// </summary>
/// <param name="report"></param>
/// <param name="calEvent"></param>
/// <param name="blah"></param>
private static void SaveAttendeesWithNotPresentNeeded(List<MemberDisplay> members, CalendarReport report, DataModels.Calendar.CalendarEvent calEvent, EventForReport blah)
{
int eventTypeCount = report.EventTypesReport.Where(x => x.CalendarEventTypeId == blah.EventType.CalendarEventTypeId).Sum(x => x.TotalTimesEventTypeOccured);
foreach (var mem in members)
{
MembersReport nAtt = new MembersReport();
var attendant = calEvent.Attendees.Where(x => x.Attendant.MemberId == mem.MemberId).FirstOrDefault();
nAtt.MemberId = mem.MemberId;
nAtt.MemberName = mem.DerbyName;
nAtt.FullName = mem.Firstname + " " + mem.LastName;
nAtt.MemberNumber = mem.PlayerNumber;
if (attendant != null)
{
nAtt.Note = attendant.Note;
nAtt.AdditionalPoints = attendant.AdditionalPoints;
nAtt.PointType = (CalendarEventPointTypeEnum)Enum.Parse(typeof(CalendarEventPointTypeEnum), attendant.PointTypeEnum.ToString());
nAtt.SecondaryPointType = (CalendarEventPointTypeEnum)Enum.Parse(typeof(CalendarEventPointTypeEnum), attendant.SecondaryPointTypeEnum.ToString());
nAtt.Availability = (AvailibilityEnum)Enum.Parse(typeof(AvailibilityEnum), attendant.AvailibityEnum.ToString());
}
else
{
nAtt.PointType = CalendarEventPointTypeEnum.Not_Present;
}
//helps debug
//if (nAtt.MemberName == "Ann G")
// nAtt.MemberName = att.Attendant.DerbyName;
var evTp = new EventTypeForReport();
evTp.PointsForExcused = blah.EventType.PointsForExcused;
evTp.PointsForNotPresent = blah.EventType.PointsForNotPresent;
evTp.PointsForPartial = blah.EventType.PointsForPartial;
evTp.PointsForPresent = blah.EventType.PointsForPresent;
evTp.PointsForTardy = blah.EventType.PointsForTardy;
evTp.EventTypeName = blah.EventType.EventTypeName;
evTp.CalendarEventTypeId = blah.EventType.CalendarEventTypeId;
if (nAtt.PointType == CalendarEventPointTypeEnum.Excused)
{
nAtt.TotalPoints += evTp.PointsForExcused + nAtt.AdditionalPoints;
evTp.TotalPointsAccruedForType += evTp.PointsForExcused + nAtt.AdditionalPoints;
nAtt.PointsForEvent += evTp.PointsForExcused + nAtt.AdditionalPoints;
evTp.TotalTimesBeenExcused += 1;
}
else if (nAtt.PointType == CalendarEventPointTypeEnum.Not_Present)
{
nAtt.TotalPoints += evTp.PointsForNotPresent + nAtt.AdditionalPoints;
evTp.TotalPointsAccruedForType += evTp.PointsForNotPresent + nAtt.AdditionalPoints;
nAtt.PointsForEvent += evTp.PointsForNotPresent + nAtt.AdditionalPoints;
evTp.TotalTimesBeenAbsent += 1;
}
else if (nAtt.PointType == CalendarEventPointTypeEnum.Partial)
{
evTp.TotalHoursAttendedEventType = blah.TimeSpan;
nAtt.TotalHoursAttendedEventType = blah.TimeSpan;
evTp.TotalTimesAttendedEventType = 1;
nAtt.TotalPoints += evTp.PointsForPartial + nAtt.AdditionalPoints;
evTp.TotalPointsAccruedForType += evTp.PointsForPartial + nAtt.AdditionalPoints;
nAtt.PointsForEvent += evTp.PointsForPartial + nAtt.AdditionalPoints;
}
else if (nAtt.PointType == CalendarEventPointTypeEnum.Present)
{
nAtt.TotalPoints += evTp.PointsForPresent + nAtt.AdditionalPoints;
evTp.TotalPointsAccruedForType += evTp.PointsForPresent + nAtt.AdditionalPoints;
evTp.TotalPointsPossible += evTp.PointsForPresent;
nAtt.PointsForEvent += evTp.PointsForPresent + nAtt.AdditionalPoints;
evTp.TotalTimesAttendedEventType = 1;
evTp.TotalHoursAttendedEventType = blah.TimeSpan;
nAtt.TotalHoursAttendedEventType = blah.TimeSpan;
}
if (nAtt.SecondaryPointType == CalendarEventPointTypeEnum.Tardy)
{
nAtt.TotalPoints += evTp.PointsForTardy;
evTp.TotalPointsAccruedForType += evTp.PointsForTardy;
evTp.TotalTimesBeenTardy += 1;
nAtt.PointsForEvent += evTp.PointsForTardy;
//evTp.TotalTimesAttendedEventType = 1;
}
//this adds the events attended to this persons list.
nAtt.EventsAttended.Add(blah);
nAtt.EventTypes.Add(evTp);
//adds the attendee to the event.
blah.Attendees.Add(nAtt);
var getEventTypeForReport = report.EventTypesReport.Where(x => x.CalendarEventTypeId == evTp.CalendarEventTypeId).FirstOrDefault();
if (getEventTypeForReport != null)
{
getEventTypeForReport.TotalMembersAttendedEventType += 1;
}
//if the attendee doesn't already exist in the list of attendees.
//we add the attendee plus the points.
var attend = report.Attendees.Where(x => x.MemberId == mem.MemberId).FirstOrDefault();
if (attend == null)
{
report.Attendees.Add(nAtt);
}
else
{ //attendee exists, so we just need to add the points already earned by the attendee.
var eventType = attend.EventTypes.Where(x => x.CalendarEventTypeId == blah.EventType.CalendarEventTypeId).FirstOrDefault();
//this adds the events attended to this persons list.
attend.EventsAttended.Add(blah);
//if the event type doesn't actually exist in the list of events teh attendee has been to.
if (eventType == null)
{
if (nAtt.PointType == CalendarEventPointTypeEnum.Excused)
{
attend.TotalPoints += evTp.PointsForExcused + nAtt.AdditionalPoints;
}
else if (nAtt.PointType == CalendarEventPointTypeEnum.Not_Present)
{
attend.TotalPoints += evTp.PointsForNotPresent + nAtt.AdditionalPoints;
}
else if (nAtt.PointType == CalendarEventPointTypeEnum.Partial)
{
attend.TotalPoints += evTp.PointsForPartial + nAtt.AdditionalPoints;
}
else if (nAtt.PointType == CalendarEventPointTypeEnum.Present)
{
attend.TotalPoints += evTp.PointsForPresent + nAtt.AdditionalPoints;
}
if (nAtt.SecondaryPointType == CalendarEventPointTypeEnum.Tardy)
{
attend.TotalPoints += evTp.PointsForTardy;
}
evTp.TotalPointsPossibleForEventTypeFromAllEventsOfType = evTp.TotalPointsPossible * eventTypeCount;
if (evTp.TotalTimesAttendedEventType > 0 && eventTypeCount != 0)
{
evTp.TotalAllPointsPossiblePercentage = evTp.TotalTimesAttendedEventType / Convert.ToDecimal(eventTypeCount) * 100;
evTp.TotalCountedPointsPossiblePercentage = evTp.TotalTimesAttendedEventType / Convert.ToDecimal(eventTypeCount - evTp.TotalTimesBeenExcused) * 100;
}
else
{
evTp.TotalAllPointsPossiblePercentage = 0;
evTp.TotalCountedPointsPossiblePercentage = 0;
}
attend.EventTypes.Add(evTp);
}
else
{
if (nAtt.PointType == CalendarEventPointTypeEnum.Excused)
{
attend.TotalPoints += eventType.PointsForExcused + nAtt.AdditionalPoints;
eventType.TotalPointsAccruedForType += eventType.PointsForExcused + nAtt.AdditionalPoints;
eventType.TotalTimesBeenExcused += 1;
}
else if (nAtt.PointType == CalendarEventPointTypeEnum.Not_Present)
{
attend.TotalPoints += eventType.PointsForNotPresent + nAtt.AdditionalPoints;
eventType.TotalPointsAccruedForType += eventType.PointsForNotPresent + nAtt.AdditionalPoints;
eventType.TotalTimesBeenAbsent += 1;
}
else if (nAtt.PointType == CalendarEventPointTypeEnum.Partial)
{
attend.TotalPoints += eventType.PointsForPartial + nAtt.AdditionalPoints;
eventType.TotalPointsAccruedForType += eventType.PointsForPartial + nAtt.AdditionalPoints;
eventType.TotalTimesAttendedEventType += 1;
eventType.TotalHoursAttendedEventType += blah.TimeSpan;
attend.TotalHoursAttendedEventType += blah.TimeSpan;
}
else if (nAtt.PointType == CalendarEventPointTypeEnum.Present)
{
attend.TotalPoints += eventType.PointsForPresent + nAtt.AdditionalPoints;
eventType.TotalPointsAccruedForType += eventType.PointsForPresent + nAtt.AdditionalPoints;
eventType.TotalTimesAttendedEventType += 1;
eventType.TotalHoursAttendedEventType += blah.TimeSpan;
attend.TotalHoursAttendedEventType += blah.TimeSpan;
}
if (nAtt.SecondaryPointType == CalendarEventPointTypeEnum.Tardy)
{
attend.TotalPoints += eventType.PointsForTardy;
eventType.TotalPointsAccruedForType += eventType.PointsForTardy;
eventType.TotalTimesBeenTardy += 1;
//eventType.TotalTimesAttendedEventType += 1;
}
if (attend.MemberName == "Velocirapture" || attend.MemberName == "Slamtana Lopez")
{ }
eventType.TotalPointsPossibleForEventTypeFromAllEventsOfType = evTp.TotalPointsPossible * eventTypeCount;
if (eventType.TotalTimesAttendedEventType > 0 && eventTypeCount > 0)
{
eventType.TotalAllPointsPossiblePercentage = eventType.TotalTimesAttendedEventType / Convert.ToDecimal(eventTypeCount) * 100;
eventType.TotalCountedPointsPossiblePercentage = eventType.TotalTimesAttendedEventType / Convert.ToDecimal(eventTypeCount - evTp.TotalTimesBeenExcused) * 100;
}
else
{
eventType.TotalAllPointsPossiblePercentage = 0;
eventType.TotalCountedPointsPossiblePercentage = 0;
}
}
}
}
}
public ActionResult CalendarReport(CalendarReport report)
{
CalendarReport cal = new CalendarReport();
try
{
long groupId = 0;
if (!String.IsNullOrEmpty(report.ToGroupIds))
{
foreach (string guid in report.ToGroupIds.Split(','))
{
if (Int64.TryParse(guid, out groupId))
break;
}
}
if (HttpContext.Request.Form["byDate"] != null || HttpContext.Request.Form["byDateExport"] != null)
{
cal = RDN.Library.Classes.Calendar.Report.CalendarReport.GetReportForCalendar(report.CalendarId, report.EntityName, Convert.ToDateTime(report.StartDateSelectedDisplay), Convert.ToDateTime(report.EndDateSelectedDisplay), groupId, report.PullGroupEventsOnly);
}
else if (HttpContext.Request.Form["byDays"] != null || HttpContext.Request.Form["byDaysExport"] != null)
{
DateTime dt = DateTime.UtcNow.AddDays(-report.DaysBackwards);
cal = RDN.Library.Classes.Calendar.Report.CalendarReport.GetReportForCalendar(report.CalendarId, report.EntityName, dt, DateTime.UtcNow, groupId, report.PullGroupEventsOnly);
}
cal.StartDateSelectedDisplay = cal.StartDateSelected.ToShortDateString();
cal.EndDateSelectedDisplay = cal.EndDateSelected.ToShortDateString();
cal.IsSubmitted = true;
if (HttpContext.Request.Form["byDateExport"] != null || HttpContext.Request.Form["byDaysExport"] != null)
{
return ExportExcelReport(cal);
}
return View(cal);
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType(), additionalInformation: report.EndDateSelectedDisplay + ":" + report.StartDateSelectedDisplay);
}
return View(cal);
}
/// <summary>
/// exports the calendar report to the excel spreadsheet.
/// </summary>
/// <param name="cal"></param>
/// <returns></returns>
private ActionResult ExportExcelReport(CalendarReport cal)
{
using (ExcelPackage p = new ExcelPackage())
{
try
{
p.Workbook.Properties.Author = "RDNation.com";
p.Workbook.Properties.Title = "Calendar Report For " + cal.EntityName;
//we create the first sheet.
ExcelWorksheet reportSheet = p.Workbook.Worksheets.Add("Report Totals");
reportSheet.Name = "Report Totals"; //Setting Sheet's name
reportSheet.Cells.Style.Font.Size = 11; //Default font size for whole sheet
reportSheet.Cells.Style.Font.Name = "Calibri"; //Default Font name for whole sheet
reportSheet.Cells[1, 1].Value = "Member";
reportSheet.Cells[1, 2].Value = "Total Points For Events Attended";
reportSheet.Cells[1, 3].Value = "Points Earned";
reportSheet.Cells[1, 4].Value = "Percentage";
reportSheet.Cells[1, 5].Value = "Total Hours";
int rowReport = 2;
//create the remaining sheets with the names.
foreach (var attendee in cal.Attendees)
{
try
{
string memberName = "NONAME";
if (!String.IsNullOrEmpty(attendee.MemberName))
memberName = attendee.MemberName;
reportSheet.Cells[rowReport, 1].Value = memberName;
ExcelWorksheet ws;
try
{
ws = p.Workbook.Worksheets.Add(StringExt.ToExcelFriendly(memberName));
ws.Name = StringExt.ToExcelFriendly(memberName); //Setting Sheet's name
}
catch
{
ws = p.Workbook.Worksheets.Add(StringExt.ToExcelFriendly(memberName + "-1"));
ws.Name = StringExt.ToExcelFriendly(memberName + "-1"); //Setting Sheet's name
}
ws.Cells.Style.Font.Size = 11; //Default font size for whole sheet
ws.Cells.Style.Font.Name = "Calibri"; //Default Font name for whole sheet
ws.Cells[1, 1].Value = "Event Name";
ws.Cells[1, 2].Value = "Event Type";
ws.Cells[1, 3].Value = "Date Start";
ws.Cells[1, 4].Value = "Date End";
ws.Cells[1, 5].Value = "Points Possible";
ws.Cells[1, 6].Value = "Points Earned";
ws.Cells[1, 7].Value = "Percentage";
ws.Cells[1, 8].Value = "Total Hours";
ws.Cells[1, 9].Value = "Notes";
// write the details
int totalPoints = 0;
int pointsEarned = 0;
//long totalHours = 0;
int index = 2;
foreach (var evAttend in attendee.EventsAttended)
{
ws.Cells[index, 1].Value = evAttend.Name;
ws.Cells[index, 2].Value = evAttend.EventType.EventTypeName;
ws.Cells[index, 3].Value = evAttend.StartDate.ToShortDateString() + " " + evAttend.StartDate.ToShortTimeString();
ws.Cells[index, 4].Value = evAttend.EndDate.ToShortDateString() + " " + evAttend.EndDate.ToShortTimeString();
ws.Cells[index, 5].Value = evAttend.EventType.PointsForPresent;
totalPoints += evAttend.EventType.PointsForPresent;
if (evAttend.Attendees.Where(x => x.MemberId == attendee.MemberId).FirstOrDefault() != null)
{
var person = evAttend.Attendees.Where(x => x.MemberId == attendee.MemberId).FirstOrDefault();
ws.Cells[index, 6].Value = person.PointsForEvent;
pointsEarned += person.PointsForEvent;
ws.Cells[index, 8].Value = RDN.Utilities.Dates.DateTimeExt.ToHumanReadableHours(person.TotalHoursAttendedEventType);
ws.Cells[index, 9].Value = person.Note;
}
else
ws.Cells[index, 8].Value = "0:00";
//calculates the pointsEarned / PointsForPResent
//=IF(Score!B10="", "",Score!B10)
ws.Cells[index, 7].Formula = "=F" + index + " / E" + index;
index += 1;
}
ws.Cells[index, 1].Value = "";
ws.Cells[index, 3].Value = "";
ws.Cells[index, 4].Value = "";
ws.Cells[index, 5].Value = totalPoints;
ws.Cells[index, 6].Value = pointsEarned;
//pointsEarned/TotalPoints
ws.Cells[index, 7].Formula = "=F" + index + " / E" + index;
ws.Cells[index, 8].Value = RDN.Utilities.Dates.DateTimeExt.ToHumanReadableHours(attendee.TotalHoursAttendedEventType);
reportSheet.Cells[rowReport, 2].Formula = "='" + ws.Name + "'!" + StringExt.GetExcelColumnName(5) + index;
reportSheet.Cells[rowReport, 3].Formula = "='" + ws.Name + "'!" + StringExt.GetExcelColumnName(6) + index;
reportSheet.Cells[rowReport, 4].Formula = "=C" + rowReport + " / B" + rowReport;
reportSheet.Cells[rowReport, 5].Value = RDN.Utilities.Dates.DateTimeExt.ToHumanReadableHours(attendee.TotalHoursAttendedEventType);
ws.Cells["A1:K20"].AutoFitColumns();
rowReport += 1;
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
}
reportSheet.Cells["A1:K20"].AutoFitColumns();
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
//Generate A File with Random name
Byte[] bin = p.GetAsByteArray();
string file = "CalendarReport_" + DateTime.UtcNow.ToString("yyyyMMdd") + ".xlsx";
return File(bin, RDN.Utilities.IO.FileExt.GetMIMEType(file), file);
}
}
public ActionResult CalendarReport(string type, string id)
{
CalendarReport cal = new CalendarReport();
try
{
var memId = RDN.Library.Classes.Account.User.GetMemberId();
var groups = MemberCache.GetLeagueGroupsOfMember(memId);
cal.GroupsForReport = groups;
cal.CalendarId = new Guid(id);
cal.EntityName = type;
cal.IsSubmitted = false;
cal.DaysBackwards = 60;
cal.StartDateSelected = DateTime.UtcNow;
cal.EndDateSelected = DateTime.UtcNow;
cal.StartDateSelectedDisplay = DateTime.UtcNow.AddDays(-60).ToShortDateString();
cal.EndDateSelectedDisplay = DateTime.UtcNow.ToShortDateString();
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
return View(cal);
}