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