//
// GET: /ChqBkFields/Details/5
public ActionResult Details(int id = 0)
{
ReportGenerator reportGen = new ReportGenerator();
String rname = "UnProcessed Requests";
chqBook_CheckBookFieldDec chqbook_checkbookfielddec = db.chqBook_CheckBookFieldDecs.Find(id);
if (chqbook_checkbookfielddec == null)
{
return HttpNotFound();
}
return View(chqbook_checkbookfielddec);
var query = reportGen.getCheckBookReports(rname);
}
public ActionResult ChequeBookReports(string fromDate, string toDate, int? page, int id = 1)
{
var reportGen = new ReportGenerator();
//string rname = userManager.getReportbyName(id);
string rname = _repository.Fetch<ChequeReport>().Single(p => p.report_Id == id).reportName;
ViewBag.toDate = toDate;
ViewBag.msgTitle = rname;
ViewBag.Title = rname;
ViewBag.pgId = id;
// return View(reportGen.getCheckBookReports(rname));
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
{
var items = reportGen.getCheckBookReports(rname);
var pageNumber = page ?? 1;
var pageObj = items.ToPagedList(pageNumber, 25);
ViewBag.pageObj = pageObj;
}
return View();
}
public ActionResult DestroyedCheckBookReportReportSearch(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 = "Destroyed 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.getdestrCheckBookReports_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();
}
//[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();
}
