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