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));
}
}
