public ActionResult PaymentBooking(Models.CreditBookingModel data) { try { CLayer.CreditBooking corporatebook = new CLayer.CreditBooking(); corporatebook.bookid = data.bookid; corporatebook.Paymentdate = data.Paymentdate; //corporatebook.Paid = data.Paid; if (data.CreditComment == null) { data.CreditComment = " "; } corporatebook.CreditComment = data.CreditComment; string userid = User.Identity.GetUserId(); corporatebook.UpdatedBy = Convert.ToInt32(userid); BLayer.CreditBooking.SaveCorBookingPayment(corporatebook); //if (data.Paid == true) //{ // BLayer.CreditBooking.SetCreditBookingstatus((int)CLayer.ObjectStatus.Corpcreditbookstatus.Paid, data.bookid); //} } catch (Exception ex) { Common.LogHandler.HandleError(ex); } //List<CLayer.Booking> users = BLayer.Transaction.GetAllCorporateCreditBookingsForSearch((int)CLayer.ObjectStatus.Corpcreditbookstatus.All, "", 0, 0, 25); return(null); }
public ActionResult Filter(Models.CreditBookingModel data) { if (data.SearchString == null) { data.SearchString = " "; } if (data.SearchString == " ") { data.SearchValue = 0; } List <CLayer.Booking> users = BLayer.Transaction.GetAllCorporateCreditBookingsRequestForSearch(data.Status, data.SearchString, data.SearchValue, 0, 25); ViewBag.Filter = new Models.CreditBookingModel(); Models.CreditBookingModel forPager = new Models.CreditBookingModel() { Status = data.Status, SearchString = data.SearchString, SearchValue = data.SearchValue, TotalRows = 0, Limit = 25, currentPage = 1 }; if (users.Count > 0) { forPager.TotalRows = users[0].TotalRows; } ViewBag.Filter = forPager; return(PartialView("_List", users)); }
public ActionResult MarkAsPayment(long BId, Models.CreditBookingModel data) { try { bool Paid = true; BLayer.CreditBooking.SetCreditBookingPaid(Paid, BId); BLayer.CreditBooking.SetCreditBookingstatus((int)CLayer.ObjectStatus.Corpcreditbookstatus.Paid, BId); } catch (Exception ex) { Common.LogHandler.HandleError(ex); } List <CLayer.Booking> users = BLayer.Transaction.GetAllCorporateCreditBookingsRequestForSearch((int)CLayer.ObjectStatus.Corpcreditbookstatus.Paid, "", 0, 0, 25); ViewBag.Filter = new Models.CreditBookingModel(); Models.CreditBookingModel forPager = new Models.CreditBookingModel() { Status = data.Status, SearchString = data.SearchString, SearchValue = data.SearchValue, TotalRows = 0, Limit = 25, currentPage = data.currentPage }; if (users.Count > 0) { forPager.TotalRows = users[0].TotalRows; } ViewBag.Filter = forPager; return(PartialView("_List", users)); }
public ActionResult Pager(Models.CreditBookingModel data) { if (data.SearchString == null) { data.SearchString = ""; } List <CLayer.CreditBookingReport> Reportlist = BLayer.Report.CorporateCreditBookingsReport(data.FromDate, data.ToDate, (data.currentPage - 1) * data.Limit, data.Limit); ViewBag.Filter = new Models.CreditBookingModel(); Models.CreditBookingModel forPager = new Models.CreditBookingModel() { SearchString = data.SearchString, SearchValue = data.SearchValue, FromDate = data.FromDate, ToDate = data.ToDate, TotalRows = 0, Limit = 25, currentPage = data.currentPage }; if (Reportlist.Count > 0) { forPager.TotalRows = Reportlist[0].TotalRows; } ViewBag.Filter = forPager; return(PartialView("_Report", Reportlist)); }
public ActionResult ReportPdf(string FromDate, string ToDate, int Limit, int currentPage) { //FromDate: pfromdate, ToDate: pToDate, Limit: pLimit, currentPage: pcurrentPage Models.CreditBookingModel data = new Models.CreditBookingModel(); List <CLayer.CreditBookingReport> Reportlist = null; try { DateTime fromD, toD; fromD = DateTime.Now; toD = DateTime.Now.AddDays(10); DateTime.TryParse(FromDate, out fromD); DateTime.TryParse(ToDate, out toD); //if (data.SearchString == null) data.SearchString = ""; Reportlist = BLayer.Report.CorporateCreditBookingsReport(fromD, toD, (currentPage - 1) * Limit, Limit); ViewBag.Filter = new Models.CreditBookingModel(); data.CreditBookingList = Reportlist; Models.CreditBookingModel forPager = new Models.CreditBookingModel() { SearchString = data.SearchString, SearchValue = data.SearchValue, FromDate = fromD, ToDate = toD, TotalRows = 0, Limit = 25, currentPage = data.currentPage }; if (Reportlist.Count > 0) { forPager.TotalRows = Reportlist[0].TotalRows; } ViewBag.Filter = forPager; // PartialView("_Report", Reportlist); data.ForPrint = true; data.ForPdf = true; } catch (Exception ex) { Common.LogHandler.HandleError(ex); } return(new ViewAsPdf("Print", Reportlist) { PageOrientation = Rotativa.Options.Orientation.Landscape }); }
public ActionResult ExcelReport(string FromDate, string ToDate, int Limit, int currentPage) { Models.CreditBookingModel data = new Models.CreditBookingModel(); List <CLayer.CreditBookingReport> Reportlist; try { DateTime fromD, toD; fromD = DateTime.Now; toD = DateTime.Now.AddDays(10); DateTime.TryParse(FromDate, out fromD); DateTime.TryParse(ToDate, out toD); //if (data.SearchString == null) data.SearchString = ""; Reportlist = BLayer.Report.CorporateCreditBookingsReport(fromD, toD, (currentPage - 1) * Limit, Limit); ViewBag.Filter = new Models.CreditBookingModel(); data.CreditBookingList = Reportlist; Models.CreditBookingModel forPager = new Models.CreditBookingModel() { SearchString = data.SearchString, SearchValue = data.SearchValue, FromDate = data.FromDate, ToDate = data.ToDate, TotalRows = 0, Limit = 25, 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 = ""; return(View("~/Areas/Admin/Views/CorporateCreditBookingsReport/Excel.cshtml", data.CreditBookingList)); }
public ActionResult Index() { Models.CreditBookingModel search = new Models.CreditBookingModel(); List <CLayer.Booking> users = BLayer.Transaction.GetAllCorporateCreditBookingsRequestForSearch((int)CLayer.ObjectStatus.Corpcreditbookstatus.All, "", 0, 0, 25); search.Status = (int)CLayer.ObjectStatus.Corpcreditbookstatus.All; search.SearchString = ""; search.SearchValue = 1; search.TotalRows = 0; search.Bookinglist = users; if (users.Count > 0) { search.TotalRows = users[0].TotalRows; } search.Limit = 25; search.currentPage = 1; ViewBag.Filter = search; return(View(search)); }
public ActionResult GetDetails(long BId) { Models.CreditBookingModel data = new Models.CreditBookingModel(); try { CLayer.CreditBooking dt = BLayer.CreditBooking.GetAllCredBookDetailsbyBookid(BId); if (dt != null) { data.CreditComment = dt.CreditComment; data.Paymentdate = dt.Paymentdate; } if (data.Paymentdate == null) { data.Paymentdate = DateTime.Now.ToShortDateString(); } data.bookid = BId; } catch (Exception ex) { Common.LogHandler.HandleError(ex); } return(View("_paypopup", data)); }
public ActionResult Index() { Models.CreditBookingModel data = new Models.CreditBookingModel(); ViewBag.Filter = new Models.CreditBookingModel(); return(View(data)); }