// GET: AgentAdminReport
public ActionResult Report()
{
var hodReportViewModel = new HodReportViewModel();
hodReportViewModel.ListofAgent = _exportReport.GetAllAgentandAgentAdminListByCategoryId(_sessionHandler.HodCategoryId);
hodReportViewModel.ListofReport = ReportList();
hodReportViewModel.ListofOverdueTypes = _overdueTypes.GetAllActiveOverdueTypes();
hodReportViewModel.ListofPriority = _priority.GetAllPrioritySelectListItem();
return(View(hodReportViewModel));
}
public ActionResult Report(HodReportViewModel reportViewModel)
{
if (ModelState.IsValid)
{
if (reportViewModel.ReportId == 1)
{
var reportDetailTicketStatusReport = _exportReport.GetDetailTicketStatusReport(
reportViewModel.Fromdate,
reportViewModel.Todate, reportViewModel.AgentId);
if (reportDetailTicketStatusReport != null && reportDetailTicketStatusReport.Count > 0)
{
ExporttoExcel(reportDetailTicketStatusReport, "Report", "AgentDetailTicketStatusReport.xlsx");
}
else
{
TempData["ReportMessages"] = "No Data to Export";
}
}
if (reportViewModel.ReportId == 2)
{
var reportCategoryWiseTicketStatuReport = _exportReport.GetCategoryWiseTicketStatusReport(
reportViewModel.Fromdate,
reportViewModel.Todate, _sessionHandler.HodCategoryId);
if (reportCategoryWiseTicketStatuReport != null && reportCategoryWiseTicketStatuReport.Count > 0)
{
ExporttoExcel(reportCategoryWiseTicketStatuReport, "Report", "CategoryWiseTicketStatusReport.xlsx");
}
else
{
TempData["ReportMessages"] = "No Data to Export";
}
}
if (reportViewModel.ReportId == 3)
{
var reportTicketOverduesbyCategorReport = _exportReport.GetTicketOverduesbyCategoryReport(
reportViewModel.Fromdate,
reportViewModel.Todate, reportViewModel.OverdueTypeId, _sessionHandler.HodCategoryId);
if (reportTicketOverduesbyCategorReport != null && reportTicketOverduesbyCategorReport.Count > 0)
{
ExporttoExcel(reportTicketOverduesbyCategorReport, "Report", "TicketOverduesReport.xlsx");
}
else
{
TempData["ReportMessages"] = "No Data to Export";
}
}
if (reportViewModel.ReportId == 4)
{
var reportTicketOverdueReport = _exportReport.GetTicketOverduesbyCategoryReport(
reportViewModel.Fromdate,
reportViewModel.Todate, reportViewModel.OverdueTypeId, _sessionHandler.HodCategoryId);
if (reportTicketOverdueReport != null && reportTicketOverdueReport.Count > 0)
{
ExporttoExcel(reportTicketOverdueReport, "Report", "TicketOverduesReport.xlsx");
}
else
{
TempData["ReportMessages"] = "No Data to Export";
}
}
if (reportViewModel.ReportId == 5)
{
var reportEscalationReport = _exportReport.GetEscalationbyCategoryReport(
reportViewModel.Fromdate,
reportViewModel.Todate, _sessionHandler.HodCategoryId);
if (reportEscalationReport != null && reportEscalationReport.Count > 0)
{
ExporttoExcel(reportEscalationReport, "Report", "EscalationbyCategoryReport.xlsx");
}
else
{
TempData["ReportMessages"] = "No Data to Export";
}
}
if (reportViewModel.ReportId == 6)
{
var reportDeletedReport = _exportReport.GetDeletedTicketHistoryByCategoryReport(
reportViewModel.Fromdate,
reportViewModel.Todate, _sessionHandler.HodCategoryId);
if (reportDeletedReport != null && reportDeletedReport.Count > 0)
{
ExporttoExcel(reportDeletedReport, "Report", "DeletedTicketHistoryByCategoryRepor.xlsx");
}
else
{
TempData["ReportMessages"] = "No Data to Export";
}
}
if (reportViewModel.ReportId == 7)
{
var reportPriorityReport = _exportReport.GetPriorityWiseTicketStatusReport(
reportViewModel.Fromdate,
reportViewModel.Todate, reportViewModel.PriorityId);
if (reportPriorityReport != null && reportPriorityReport.Count > 0)
{
ExporttoExcel(reportPriorityReport, "Report", "PriorityWiseTicketStatusReport.xlsx");
}
else
{
TempData["ReportMessages"] = "No Data to Export";
}
}
if (reportViewModel.ReportId == 8)
{
var reportUserReport = _exportReport.GetUsersDetailsReport(
reportViewModel.AgentId
);
if (reportUserReport != null && reportUserReport.Count > 0)
{
ExporttoExcel(reportUserReport, "Report", "UsersDetailsReport.xlsx");
}
else
{
TempData["ReportMessages"] = "No Data to Export";
}
}
if (reportViewModel.ReportId == 9)
{
var checkinCheckOutReport = _exportReport.UserWiseCheckinCheckOutReport(
reportViewModel.Fromdate,
reportViewModel.Todate, reportViewModel.AgentId
);
if (checkinCheckOutReport != null && checkinCheckOutReport.Count > 0)
{
ExporttoExcel(checkinCheckOutReport, "Report", "UserWiseCheckinCheckOutReport.xlsx");
}
else
{
TempData["ReportMessages"] = "No Data to Export";
}
}
}
reportViewModel.ListofAgent = _exportReport.GetAllAgentandAgentAdminListByCategoryId(_sessionHandler.HodCategoryId);
reportViewModel.ListofReport = ReportList();
reportViewModel.ListofOverdueTypes = _overdueTypes.GetAllActiveOverdueTypes();
reportViewModel.ListofPriority = _priority.GetAllPrioritySelectListItem();
return(View(reportViewModel));
}