public ActionResult UpdateInvoice(Invoice invoice) { using (RMTechAdminDb db = new RMTechAdminDb()) { foreach (InvoiceLine l in invoice.Lines) { if (l.Id == 0) { db.InvoiceLines.Add(l); invoice.InvoiceDate = DateTime.Now; db.SaveChanges(); } else { db.Entry(l).State = System.Data.Entity.EntityState.Modified; } } db.Entry(invoice).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(Content(Newtonsoft.Json.JsonConvert.SerializeObject(invoice))); } }
public ActionResult EditInvoice(int invoiceId) { using (RMTechAdminDb db = new RMTechAdminDb()) { var invoice = db.Invoices.Include("Lines").Where(x => x.Id == invoiceId).FirstOrDefault(); return(View("EditInvoice", invoice)); } }
public ActionResult Index() { using (RMTechAdminDb db = new RMTechAdminDb()) { var customers = db.Customers.ToList(); return(View(customers)); } }
public ActionResult CreateInvoice(Invoice invoice) { using (RMTechAdminDb db = new RMTechAdminDb()) { invoice.Total = invoice.InvoiceTotal; invoice.InvStatus = "N"; db.Invoices.Add(invoice); db.SaveChanges(); } return(Json(invoice.Id)); }
public ActionResult RecentInvoices() { using (RMTechAdminDb db = new RMTechAdminDb()) { var invoices = db.Invoices.Include("Lines") .OrderByDescending(x => x.Id).Take(10).ToList(); return(Content(Newtonsoft.Json.JsonConvert.SerializeObject(invoices))); } }
public ActionResult DeleteInvoiceLine(InvoiceLine line) { using (RMTechAdminDb db = new RMTechAdminDb()) { var dbLine = db.InvoiceLines.Find(line.Id); db.InvoiceLines.Remove(dbLine); db.SaveChanges(); return(Json("OK")); } }
public ActionResult SaveCustomer(Customer customer) { using (RMTechAdminDb db = new RMTechAdminDb()) { if (customer.Id == 0) { db.Customers.Add(customer); } else { db.Entry(customer).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); return(Json("OK")); } }