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