//[HttpPost]
        public ActionResult ChequeBookReportsSearch(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"];
            string reportType = Request["reportType"];
            int reportId = Int32.Parse(reportType);
            //int reportId = Int32.Parse(reportType);
            ReportGenerator reportGen = new ReportGenerator();
            //string rname = userManager.getReportbyName(reportId);
            string rname = _repository.Fetch<ChequeReport>().Single(p => p.report_Id == reportId).reportName;
            ViewBag.msgTitle = rname;
            ViewBag.Title = rname;

            ViewBag.msgTitle = rname;
            ViewBag.Title = rname;
            ViewBag.pgId = reportId;
            if (rname.Contains("Collected Check Books Report"))
            {

                return RedirectToAction("CollectedChequeBookReport");
                //var itemz = reportGen.getCollecetdCheckBookReports(rname);
                //var pageNumber = page ?? 1;
                //var pageObj = itemz.ToPagedList(pageNumber, 25);
                //ViewBag.pageObj = pageObj;

            }
            if (rname.Contains("Destroyed Check Books Report"))
            {

                return RedirectToAction("DestroyedCheckBookReport");
                //var itemz = reportGen.getCollecetdCheckBookReports(rname);
                //var pageNumber = page ?? 1;
                //var pageObj = itemz.ToPagedList(pageNumber, 25);
                //ViewBag.pageObj = pageObj;

            }
            else

                //     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.getCheckBookReports_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.getCheckBookReports(rname.Trim(), column.Trim(), item.Trim());
                    var pageNumber = page ?? 1;
                    var pageObj = items.ToPagedList(pageNumber, 25);
                    ViewBag.pageObj = pageObj;

                }
            return View();
        }