public ActionResult EditDet([Bind(Include = "VPRentID,Month,Arrears,Current,RecoveryAmt,RecoveryDate,BalanceArrears,BalanceCurrent,ReceiptNo")] VPRentDetail vPRentDetail)
{
if (ModelState.IsValid)
{
db.Entry(vPRentDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(vPRentDetail));
}
public ActionResult CreateDet([Bind(Include = "VPRentID,Month,Arrears,Current,RecoveryAmt,RecoveryDate,BalanceArrears,BalanceCurrent")] VPRentDetail vPRentDetail)
{
if (ModelState.IsValid)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
var payerName = db.VPRents.Find(vPRentDetail.VPRentID).RentPayerName;
var item = new Form4 {
Amount = vPRentDetail.RecoveryAmt, LedgerID = 7, PayDate = DateTime.Today, RecvdFrom = "Property Rent: " + payerName, SubLedgerID = 30
}; //Shop rent
db.Form4.Add(item);
db.VPRentDetails.Add(vPRentDetail);
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
return(RedirectToAction("Index"));
}
}
//if not valid model
VPRent vPRent = db.VPRents.Find(vPRentDetail.VPRentID);
if (vPRent == null)
{
return(HttpNotFound());
}
ViewBag.vpRent = vPRent;
ViewBag.rd = db.VPRentDetails.Where(r => r.VPRentID == vPRentDetail.VPRentID).OrderBy(r => r.Month);
ViewBag.MonthBox = MyExtensions.MonthList();
return(View("Details", vPRentDetail));
}