public ActionResult Index(int?page) { SegmentCountReportModel model = new SegmentCountReportModel(); int currentPageIndex = page.HasValue ? page.Value : 1; int defaultPageSize = 30; model.SegmentCountReportList = ser.ListSegmentCountReport(model.YearId, model.ServiceProviderId, model.AgentId).ToPagedList(currentPageIndex, defaultPageSize);; return(View(model)); }
public List <SegmentCountReportModel> ListSegmentCountReport(int YearId, int ServiceProviderId, int?AgentId) { var data = ent.Air_GetSegmentCountReport(YearId, ServiceProviderId, AgentId); List <SegmentCountReportModel> model = new List <SegmentCountReportModel>(); int totalBookJan = 0; int totalCancelJan = 0; int totalBookFeb = 0; int totalCancelFeb = 0; int totalBookMarch = 0; int totalCancelMarch = 0; int totalBookApril = 0; int totalCancelApril = 0; int totalBookMay = 0; int totalCancelMay = 0; int totalBookJune = 0; int totalCancelJune = 0; int totalBookJuly = 0; int totalCancelJuly = 0; int totalBookAugust = 0; int totalCancelAugust = 0; int totalBookSep = 0; int totalCancelSep = 0; int totalBookOct = 0; int totalCancelOct = 0; int totalBookNov = 0; int totalCancelNov = 0; int totalBookDec = 0; int totalCancelDec = 0; foreach (var item in data.Select(x => x)) { var SegmentCountReportModel = new SegmentCountReportModel(); SegmentCountReportModel.Info = item.Info; SegmentCountReportModel.Jan = item.Jan; if (item.Info == "Booked") { totalBookJan = int.Parse(item.Jan); } else { totalCancelJan = int.Parse(item.Jan); } SegmentCountReportModel.SumJan = totalBookJan - totalCancelJan; SegmentCountReportModel.Feb = item.Feb; if (item.Info == "Booked") { totalBookFeb = int.Parse(item.Feb); } else { totalCancelFeb = int.Parse(item.Feb); } SegmentCountReportModel.SumFeb = totalBookFeb - totalCancelFeb; SegmentCountReportModel.Mar = item.March; if (item.Info == "Booked") { totalBookMarch = int.Parse(item.March); } else { totalCancelMarch = int.Parse(item.March); } SegmentCountReportModel.SumMarch = totalBookMarch - totalCancelMarch; SegmentCountReportModel.April = item.April; if (item.Info == "Booked") { totalBookApril = int.Parse(item.April); } else { totalCancelApril = int.Parse(item.April); } SegmentCountReportModel.SumApril = totalBookApril - totalCancelApril; SegmentCountReportModel.May = item.May; if (item.Info == "Booked") { totalBookMay = int.Parse(item.May); } else { totalCancelMay = int.Parse(item.May); } SegmentCountReportModel.SumMay = totalBookMay - totalCancelMay; SegmentCountReportModel.Jun = item.June; if (item.Info == "Booked") { totalBookJune = int.Parse(item.June); } else { totalCancelJune = int.Parse(item.June); } SegmentCountReportModel.SumJune = totalBookJune - totalCancelJune; SegmentCountReportModel.July = item.July; if (item.Info == "Booked") { totalBookJuly = int.Parse(item.July); } else { totalCancelJuly = int.Parse(item.July); } SegmentCountReportModel.SumJuly = totalBookJuly - totalCancelJuly; SegmentCountReportModel.Aug = item.Aug; if (item.Info == "Booked") { totalBookAugust = int.Parse(item.Aug); } else { totalCancelAugust = int.Parse(item.Aug); } SegmentCountReportModel.SumAug = totalBookAugust - totalCancelAugust; SegmentCountReportModel.Sep = item.Sept; if (item.Info == "Booked") { totalBookSep = int.Parse(item.Sept); } else { totalCancelSep = int.Parse(item.Sept); } SegmentCountReportModel.SumSep = totalBookSep - totalCancelSep; SegmentCountReportModel.Oct = item.Oct; if (item.Info == "Booked") { totalBookOct = int.Parse(item.Oct); } else { totalCancelOct = int.Parse(item.Oct); } SegmentCountReportModel.SumOct = totalBookOct - totalCancelOct; SegmentCountReportModel.Nov = item.Nov; if (item.Info == "Booked") { totalBookNov = int.Parse(item.Nov); } else { totalCancelNov = int.Parse(item.Nov); } SegmentCountReportModel.SumNov = totalBookNov - totalCancelNov; SegmentCountReportModel.Dec = item.Dec; if (item.Info == "Booked") { totalBookDec = int.Parse(item.Dec); } else { totalCancelDec = int.Parse(item.Dec); } SegmentCountReportModel.SumDec = totalBookDec - totalCancelDec; if (item.Info == "Booked") { TotalBooked = TotalBooked + double.Parse(item.Jan) + double.Parse(item.Feb) + double.Parse(item.March) + double.Parse(item.April) + double.Parse(item.May) + double.Parse(item.June) + double.Parse(item.July) + double.Parse(item.Aug) + double.Parse(item.Sept) + double.Parse(item.Oct) + double.Parse(item.Nov) + double.Parse(item.Dec); SegmentCountReportModel.SumBooked = TotalBooked; } else if (item.Info == "Cancelled") { TotalCanceled = TotalCanceled + double.Parse(item.Jan) + double.Parse(item.Feb) + double.Parse(item.March) + double.Parse(item.April) + double.Parse(item.May) + double.Parse(item.June) + double.Parse(item.July) + double.Parse(item.Aug) + double.Parse(item.Sept) + double.Parse(item.Oct) + double.Parse(item.Nov) + double.Parse(item.Dec); SegmentCountReportModel.SumCancelled = TotalCanceled; } SegmentCountReportModel.SumAllMonths = TotalBooked - TotalCanceled; model.Add(SegmentCountReportModel); } return(model); }
public ActionResult Index(ExportModel Expmodel, SegmentCountReportModel model, FormCollection frm, int?page) { int currentPageIndex = page.HasValue ? page.Value : 1; int defaultPageSize = 30; model.SegmentCountReportList = ser.ListSegmentCountReport(model.YearId, model.ServiceProviderId, model.hdfAgentId).ToPagedList(currentPageIndex, defaultPageSize); //export BookedTicketReportController crtBKT = new BookedTicketReportController(); crtBKT.GetExportTypeClicked(Expmodel, frm); if (Expmodel != null && (Expmodel.ExportTypeExcel != null || Expmodel.ExportTypeWord != null || Expmodel.ExportTypeCSV != null || Expmodel.ExportTypePdf != null)) { try { if (Expmodel.ExportTypeExcel != null) { Expmodel.ExportTypeExcel = Expmodel.ExportTypeExcel; } else if (Expmodel.ExportTypeWord != null) { Expmodel.ExportTypeWord = Expmodel.ExportTypeWord; } else if (Expmodel.ExportTypePdf != null) { Expmodel.ExportTypePdf = Expmodel.ExportTypePdf; } var exportData = new List <SegmentCountReportExportModel>(); foreach (var item in model.SegmentCountReportList) { var rpt = new SegmentCountReportExportModel(); rpt.Info = item.Info; rpt.Jan = item.Jan; rpt.Feb = item.Feb; rpt.March = item.Mar; rpt.April = item.April; rpt.May = item.May; rpt.Jun = item.Jun; rpt.July = item.July; rpt.Aug = item.Aug; rpt.Sep = item.Sep; rpt.Oct = item.Oct; rpt.Nov = item.Nov; rpt.Dec = item.Dec; exportData.Add(rpt); } App_Class.AppCollection.Export(Expmodel, exportData, "SegmentCount"); } catch { } } return(View(model)); }