public ActionResult CollectedChequeBookReportSearch(int? page, int id = 1)
{
var fromDate = Request["fromDate"];
var toDate = Request["toDate"];
string column = Request["column"];
var creteria = Request["creteria"];
var item = Request["item"];
var reportGen = new ReportGenerator();
string rname = "Collected Check Books Report";
ViewBag.msgTitle = rname;
ViewBag.Title = rname;
ViewBag.msgTitle = rname;
ViewBag.Title = rname;
ViewBag.pgId = id;
// return View(reportGen.getCheckBookReports(rname));
//put serat for the checkbooks here
if (fromDate != null && fromDate != "" && toDate != null && toDate != "") ///search that has date included
{
DateTime fromDate_ = new DateTime();
DateTime toDate_ = new DateTime();
try
{
fromDate_ = Convert.ToDateTime(fromDate);
ViewBag.fromDate = fromDate;
}
catch (Exception ex) { }
try
{
toDate_ = DateTime.Parse(toDate);
toDate_ = Convert.ToDateTime(toDate).AddDays(1.0);
ViewBag.toDate = toDate;
}
catch (Exception ex) { }
var items = reportGen.getcollectCheckBookReports_withdate(rname.Trim(), column.Trim(), item.Trim(), fromDate, toDate);
var pageNumber = page ?? 1;
var pageObj = items.ToPagedList(pageNumber, 25);
ViewBag.pageObj = pageObj;
}
else ///search without date
{
var items = reportGen.getcollecCheckBookReports(rname.Trim(), column.Trim(), item.Trim());
var pageNumber = page ?? 1;
var pageObj = items.ToPagedList(pageNumber, 25);
ViewBag.pageObj = pageObj;
}
return View();
}
