public ActionResult AddDetail(Models.LedgerAddDetailModel model) { using (db00ccd2da5aff4a5983c0a17b010f53a6Entities context = new db00ccd2da5aff4a5983c0a17b010f53a6Entities()) { var theLedger = context.Ledgers.FirstOrDefault(l => l.LedgerId == model.LedgerId); if (theLedger == default(Ledger)) { return View("ErrorMessage", new Models.ErrorMessageModel { Title = "No Such Ledger!", Message = "The ledger you are attempting to access does not exist in the database.", ReturnAction = "Index", ReturnRouteValues = new { } }); } else if (theLedger.UserProfile.UserName != User.Identity.Name && theLedger.Editors.FirstOrDefault(u => u.UserName == User.Identity.Name) == default(UserProfile)) { return View("ErrorMessage", new Models.ErrorMessageModel { Title = "No Permission!", Message = "You are neither the owner nor an editor of the ledger you are attempting to access.", ReturnAction = "Index", ReturnRouteValues = new { } }); } var theDetail = new LedgerDetail(); theDetail.Amount = model.Amount; theDetail.Legder_LedgerId = model.LedgerId; theDetail.Memo = model.Memo; theDetail.Payor = model.Payor; theDetail.PaySource = model.PaySource; theDetail.Category = model.Category; theDetail.When = model.When; theLedger.LedgerDetails.Add(theDetail); context.SaveChanges(); return RedirectToAction("Detail", new { id=model.LedgerId }); } }
public ActionResult DeleteConfirmed(int id) { LedgerDetail ledgerDetail = db.LedgerDetails.Find(id); db.LedgerDetails.Remove(ledgerDetail); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult CreateLedDet([Bind(Include = "LedgerDetailID,SubLedgerID,LedgerDetail1")] LedgerDetail ledgerDetail) { if (ModelState.IsValid) { db.LedgerDetails.Add(ledgerDetail); db.SaveChanges(); return(RedirectToAction("Details", new { id = ledgerDetail.SubLedgerID })); } return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "LedgerDetailID,SubLedgerID,LedgerDetail1")] LedgerDetail ledgerDetail) { if (ModelState.IsValid) { db.Entry(ledgerDetail).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.SubLedgerID = new SelectList(db.SubLedgers, "SubLedgerID", "Ledger", ledgerDetail.SubLedgerID); return(View(ledgerDetail)); }
public ActionResult EditLedDet([Bind(Include = "LedgerDetailID,SubLedgerID,LedgerDetail1")] LedgerDetail ledgerDetail) { if (ModelState.IsValid) { db.Entry(ledgerDetail).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Details", new { id = ledgerDetail.SubLedgerID })); } return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "LedgerDetailID,SubLedgerID,LedgerDetail1")] LedgerDetail ledgerDetail) { if (ModelState.IsValid) { db.LedgerDetails.Add(ledgerDetail); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.SubLedgerID = new SelectList(db.SubLedgers, "SubLedgerID", "Ledger", ledgerDetail.SubLedgerID); return(View(ledgerDetail)); }
// GET: LedgerDetails/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } LedgerDetail ledgerDetail = db.LedgerDetails.Find(id); if (ledgerDetail == null) { return(HttpNotFound()); } return(View(ledgerDetail)); }
// GET: LedgerDetails/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } LedgerDetail ledgerDetail = db.LedgerDetails.Find(id); if (ledgerDetail == null) { return(HttpNotFound()); } ViewBag.SubLedgerID = new SelectList(db.SubLedgers, "SubLedgerID", "Ledger", ledgerDetail.SubLedgerID); return(View(ledgerDetail)); }
int UpdateLedger(CustomerInvoiceModel customerInvoiceModel, bool addMode) { LedgerMaster ledgerMaster = null; if (addMode) { ledgerMaster = new LedgerMaster(); ledgerMaster.SubsidiaryLedgerAccountId = customerInvoiceModel.Customer.Value; ledgerMaster.InvoiceBillingAddress = customerInvoiceModel.BillingAddress; ledgerMaster.InvoiceNo = customerInvoiceModel.InvoiceNo; ledgerMaster.InvoiceDate = customerInvoiceModel.Date; ledgerMaster.InvoiceDueDate = customerInvoiceModel.DueDate; ledgerMaster.InvoiceTerms = customerInvoiceModel.Terms; ledgerMaster.InvoiceReference = customerInvoiceModel.Reference; ledgerMaster.InvoiceCreatedDate = DateTime.Now; ledgerMaster.InvoiceAmount = customerInvoiceModel.Amount; ledgerMaster.TransactionType = "INV"; _serverContext.LedgerMasters.Add(ledgerMaster); _serverContext.SaveChanges(); /* LedgerDetail ledgerDetail = new LedgerDetail(); * foreach (CustomerInvoiceItemModel item in customerInvoiceModel.Items) * { * ledgerDetail.Id = 0; * ledgerDetail.LedgerMasterId = ledgerMaster.Id; * ledgerDetail.InvoiceSalesItemId = item.SalesItem.Value; * ledgerDetail.InvoiceDescription = item.Description; * ledgerDetail.InvoiceQuantity = item.Qty; * ledgerDetail.InvoiceUnitPrice = item.UnitPrice; * ledgerDetail.InvoiceTaxRateId = item.TaxRateItem.Value; * ledgerDetail.InvoiceTrackingId = item.TrackingItem.Value; * _serverContext.LedgerDetails.Add(ledgerDetail); * _serverContext.SaveChanges(); * } */ } else { ledgerMaster = _serverContext.LedgerMasters.Find(customerInvoiceModel.Id); ledgerMaster.SubsidiaryLedgerAccountId = customerInvoiceModel.Customer.Value; ledgerMaster.InvoiceBillingAddress = customerInvoiceModel.BillingAddress; ledgerMaster.InvoiceNo = customerInvoiceModel.InvoiceNo; ledgerMaster.InvoiceAmount = customerInvoiceModel.Amount; ledgerMaster.InvoiceDate = customerInvoiceModel.Date; ledgerMaster.InvoiceDueDate = customerInvoiceModel.DueDate; ledgerMaster.InvoiceTerms = customerInvoiceModel.Terms; ledgerMaster.InvoiceReference = customerInvoiceModel.Reference; ledgerMaster.InvoiceModifiedDate = DateTime.Now; ledgerMaster.TransactionType = "INV"; _serverContext.SaveChanges(); } if (!addMode) { foreach (var item in _serverContext.LedgerDetails.Where(x => x.LedgerMasterId == customerInvoiceModel.Id).ToList()) { LedgerDetail ledgerDetail = new LedgerDetail(); ledgerDetail = _serverContext.LedgerDetails.Find(item.Id); if (ledgerDetail != null) { _serverContext.LedgerDetails.Remove(ledgerDetail); _serverContext.SaveChanges(); } } } foreach (CustomerInvoiceItemModel item in customerInvoiceModel.Items) { LedgerDetail ledgerDetail = new LedgerDetail(); ledgerDetail.Id = 0; ledgerDetail.LedgerMasterId = ledgerMaster.Id; ledgerDetail.InvoiceSalesItemId = item.SalesItem.Value; ledgerDetail.InvoiceDescription = item.Description; ledgerDetail.InvoiceQuantity = item.Qty; ledgerDetail.InvoiceUnitPrice = item.UnitPrice; ledgerDetail.InvoiceTaxRateId = item.TaxRateItem.Value; ledgerDetail.InvoiceTrackingId = item.TrackingItem.Value; _serverContext.LedgerDetails.Add(ledgerDetail); _serverContext.SaveChanges(); } if (!addMode) { var tempGl = _serverContext.GeneralLedgers.Where(x => x.LedgerMasterId == customerInvoiceModel.Id).SingleOrDefault(); _serverContext.GeneralLedgers.Remove(tempGl); } return(ledgerMaster.Id); }