public ActionResult ReportPrint(string FromDate, string ToDate, int Limit, int currentPage) { Models.BookingStatusReportModel data = new Models.BookingStatusReportModel(); List <CLayer.BookingStatusReport> Reportlist; DateTime fromD, toD; fromD = DateTime.Now; toD = DateTime.Now.AddDays(10); try { string email = User.Identity.GetUserName(); long LoginUserid = BLayer.User.GetUserId(email); DateTime.TryParse(FromDate, out fromD); DateTime.TryParse(ToDate, out toD); DateTime FromDates = Convert.ToDateTime(FromDate); DateTime ToDates = Convert.ToDateTime(ToDate); //if (data.SearchString == null) data.SearchString = ""; if (fromD >= Convert.ToDateTime("01/06/2017 00:00:00") && toD >= Convert.ToDateTime("01/06/2017 00:00:00")) { Reportlist = BLayer.Report.BookingStatusReportGST(FromDates, ToDates, (currentPage - 1) * Limit, Limit, LoginUserid); } else { Reportlist = BLayer.Report.BookingStatusReport(FromDates, ToDates, (currentPage - 1) * Limit, Limit); } ViewBag.Filter = new Models.BookingStatusReportModel(); data.BookingStatusReportList = Reportlist; Models.BookingStatusReportModel forPager = new Models.BookingStatusReportModel() { SearchString = data.SearchString, SearchValue = data.SearchValue, FromDate = FromDates, ToDate = ToDates, TotalRows = 0, Limit = 2000, currentPage = data.currentPage }; if (Reportlist.Count > 0) { forPager.TotalRows = Reportlist[0].TotalRows; } ViewBag.Filter = forPager; data.ForPrint = true; data.ForPdf = true; } catch (Exception ex) { Common.LogHandler.HandleError(ex); } if (fromD >= Convert.ToDateTime("01/06/2017 00:00:00") && toD >= Convert.ToDateTime("01/06/2017 00:00:00")) { return(View("PrintGST", data.BookingStatusReportList)); } else { return(View("Print", data.BookingStatusReportList)); } }
public ActionResult ReportPdf(string FromDate, string ToDate, int Limit, int currentPage) { //FromDate: pfromdate, ToDate: pToDate, Limit: pLimit, currentPage: pcurrentPage Models.BookingStatusReportModel data = new Models.BookingStatusReportModel(); DateTime fromD, toD; fromD = DateTime.Now; toD = DateTime.Now.AddDays(10); List <CLayer.BookingStatusReport> Reportlist; try { DateTime.TryParse(FromDate, out fromD); DateTime.TryParse(ToDate, out toD); DateTime FromDates = Convert.ToDateTime(FromDate); DateTime ToDates = Convert.ToDateTime(ToDate); //if (data.SearchString == null) data.SearchString = ""; if (fromD >= Convert.ToDateTime("01/06/2017 00:00:00") && toD >= Convert.ToDateTime("01/06/2017 00:00:00")) { Reportlist = BLayer.Report.BookingStatusReportGST(FromDates, ToDates, (currentPage - 1) * Limit, Limit); } else { Reportlist = BLayer.Report.BookingStatusReport(FromDates, ToDates, (currentPage - 1) * Limit, Limit); } ViewBag.Filter = new Models.PendingCustomerInvoiceReportModel(); data.BookingStatusReportList = Reportlist; Models.BookingStatusReportModel forPager = new Models.BookingStatusReportModel() { SearchString = data.SearchString, SearchValue = data.SearchValue, FromDate = FromDates, ToDate = ToDates, TotalRows = 0, Limit = 2000, currentPage = data.currentPage }; if (Reportlist.Count > 0) { forPager.TotalRows = Reportlist[0].TotalRows; } ViewBag.Filter = forPager; data.ForPrint = true; data.ForPdf = true; } catch (Exception ex) { Common.LogHandler.HandleError(ex); } if (fromD >= Convert.ToDateTime("01/06/2017 00:00:00") && toD >= Convert.ToDateTime("01/06/2017 00:00:00")) { return(new ViewAsPdf("PrintGST", data.BookingStatusReportList) { PageOrientation = Rotativa.Options.Orientation.Landscape }); } else { return(new ViewAsPdf("Print", data.BookingStatusReportList) { PageOrientation = Rotativa.Options.Orientation.Landscape }); } }
public ActionResult ExcelReport(string FromDate, string ToDate, int Limit, int currentPage) { Models.BookingStatusReportModel data = new Models.BookingStatusReportModel(); List <CLayer.BookingStatusReport> Reportlist; DateTime fromD, toD; fromD = DateTime.Now; toD = DateTime.Now.AddDays(10); try { string email = User.Identity.GetUserName(); long LoginUserid = BLayer.User.GetUserId(email); DateTime.TryParse(FromDate, out fromD); DateTime.TryParse(ToDate, out toD); DateTime FromDates = Convert.ToDateTime(FromDate); DateTime ToDates = Convert.ToDateTime(ToDate); //if (data.SearchString == null) data.SearchString = ""; if (fromD >= Convert.ToDateTime("01/06/2017 00:00:00") && toD >= Convert.ToDateTime("01/06/2017 00:00:00")) { Reportlist = BLayer.Report.BookingStatusReportGST(FromDates, ToDates, (currentPage - 1) * Limit, Limit, LoginUserid); } else { Reportlist = BLayer.Report.BookingStatusReport(FromDates, ToDates, (currentPage - 1) * Limit, Limit); } ViewBag.Filter = new Models.BookingStatusReportModel(); data.BookingStatusReportList = Reportlist; Models.BookingStatusReportModel forPager = new Models.BookingStatusReportModel() { SearchString = data.SearchString, SearchValue = data.SearchValue, FromDate = FromDates, ToDate = ToDates, TotalRows = 0, Limit = 2000, currentPage = data.currentPage }; if (Reportlist.Count > 0) { forPager.TotalRows = Reportlist[0].TotalRows; } ViewBag.Filter = forPager; data.ForPrint = true; data.ForPdf = true; } catch (Exception ex) { Common.LogHandler.HandleError(ex); } Response.ContentType = "application/vnd.ms-excel"; Response.AppendHeader("content-disposition", "attachment; filename=report.xls"); Response.Charset = ""; if (fromD >= Convert.ToDateTime("01/06/2017 00:00:00") && toD >= Convert.ToDateTime("01/06/2017 00:00:00")) { return(View("~/Areas/Admin/Views/BookingStatusReport/ExcelGST.cshtml", data.BookingStatusReportList)); } else { return(View("~/Areas/Admin/Views/BookingStatusReport/Excel.cshtml", data.BookingStatusReportList)); } }