public ActionResult PrintDetails(int?id)
{
using (db_lendingEntities db = new db_lendingEntities())
{
tbl_end_of_day_transactions tbl = db.tbl_end_of_day_transactions.Find(id);
DateTime?date = null;
if (tbl != null)
{
ViewBag.CashBeginning = String.Format("{0:n}", decimal.Round((decimal)tbl.cash_begin, 2, MidpointRounding.AwayFromZero));
ViewBag.CashCollection = String.Format("{0:n}", decimal.Round((decimal)tbl.cash_collected, 2, MidpointRounding.AwayFromZero));
ViewBag.CashEnd = String.Format("{0:n}", decimal.Round((decimal)tbl.cash_end, 2, MidpointRounding.AwayFromZero));
ViewBag.CashRelease = String.Format("{0:n}", decimal.Round((decimal)tbl.cash_release, 2, MidpointRounding.AwayFromZero));
ViewBag.CashReplenished = String.Format("{0:n}", decimal.Round((decimal)tbl.cash_replenished, 2, MidpointRounding.AwayFromZero));
ViewBag.CashPullOut = String.Format("{0:n}", decimal.Round((decimal)tbl.cash_pulled_out, 2, MidpointRounding.AwayFromZero));
date = tbl.date_trans;
}
ViewBag.dateString = String.Format("{0:MMMM dd, yyyy}", date);
var result1 = db.tbl_loan_processing.Where(d => d.status == "Released" && (d.loan_date >= date && d.loan_date <= date)).ToList();
ViewBag.ReleaseList = result1;
var result2 = db.tbl_payment.Where(d => (d.date_trans >= date && d.date_trans <= date)).ToList();
ViewBag.CollectionList = result2;
}
return(PartialView("PrintDetails"));
}
public ActionResult Save(tbl_end_of_day_transactions model)
{
try
{
db_lendingEntities db = new db_lendingEntities();
var datetimenow = DateTime.Now;
var datenow = datetimenow.Date;
var result = from d in db.tbl_end_of_day_transactions where (d.date_trans >= datenow && d.date_trans <= datenow) orderby d.autonum ascending select d;
if (result.Count() == 0)
{
tbl_end_of_day_transactions tbl = new tbl_end_of_day_transactions();
tbl.date_trans = model.date_trans;
tbl.cash_begin = model.cash_begin;
tbl.cash_release = model.cash_release;
tbl.cash_collected = model.cash_collected;
tbl.cash_replenished = model.cash_replenished;
tbl.cash_pulled_out = model.cash_pulled_out;
tbl.cash_end = model.cash_end;
tbl.created_by = Session["UserName"].ToString();
tbl.date_created = DateTime.Now;
db.tbl_end_of_day_transactions.Add(tbl);
db.SaveChanges();
return(Json("Success", JsonRequestBehavior.AllowGet));
}
else
{
//"date_trans", "cash_begin", "cash_release", "cash_collected", "cash_pulled_out", "cash_end"
var update = db.tbl_end_of_day_transactions.SingleOrDefault(d => d.date_trans >= datenow && d.date_trans <= datenow);
if (TryUpdateModel(update, "",
new string[] { "date_trans", "cash_begin", "cash_release", "cash_collected", "cash_replenished", "cash_pulled_out", "cash_end" }))
{
db.SaveChanges();
}
}
return(Json("Success", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json("Failed", JsonRequestBehavior.DenyGet));
throw ex;
}
}
public ActionResult Print(int?id)
{
try
{
using (db_lendingEntities db = new db_lendingEntities())
{
tbl_end_of_day_transactions tbl_end_of_day_transactions = db.tbl_end_of_day_transactions.Find(id);
if (Session["UserId"] != null)
{
return(View(tbl_end_of_day_transactions));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
}
catch (Exception)
{
throw;
}
}