public ActionResult Create([Bind(Include = "VPRentID,RentYear,RentPayerName,RentedPropertyName")] VPRent vPRent)
{
if (ModelState.IsValid)
{
db.VPRents.Add(vPRent);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(vPRent));
}
public ActionResult Edit([Bind(Include = "VPRentID,RentYear,RentPayerName,RentedPropertyName")] VPRent vPRent)
{
if (ModelState.IsValid)
{
db.Entry(vPRent).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.YearBox = MyExtensions.MakeYrRq(8, 1, DateTime.Today.Year);
return(View(vPRent));
}
// GET: VPRents/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VPRent vPRent = db.VPRents.Find(id);
if (vPRent == null)
{
return(HttpNotFound());
}
ViewBag.YearBox = MyExtensions.MakeYrRq(8, 1, DateTime.Today.Year);
return(View(vPRent));
}
// GET: VPRents/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VPRent vPRent = db.VPRents.Find(id);
if (vPRent == null)
{
return(HttpNotFound());
}
ViewBag.vpRent = vPRent;
ViewBag.rd = db.VPRentDetails.Where(r => r.VPRentID == id).OrderBy(r => r.Month);
ViewBag.MonthBox = MyExtensions.MonthList();
return(View());
}
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));
}
