public IActionResult Add(int customerId) { InvoiceModels model = new InvoiceModels(); model.CustomerId = customerId; return(View(model)); }
public IActionResult Index(int customerId = 0) { InvoiceAdapter adapter = new InvoiceAdapter(); List <Invoice> invoices = new List <Invoice>(); if (customerId == 0) { invoices = adapter.GetAll(); } else { invoices = adapter.GetByCustomerId(customerId); } AllInvoicesModel model = new AllInvoicesModel(); List <InvoiceModels> invoiceModels = new List <InvoiceModels>(); foreach (Invoice invoice in invoices) { InvoiceModels invoiceModel = new InvoiceModels(); invoiceModel.InvoiceId = invoice.InvoiceId; invoiceModel.CustomerId = invoice.CustomerId; invoiceModel.Total = invoice.Total; invoiceModel.InvoiceDate = invoice.InvoiceDate; invoiceModels.Add(invoiceModel); } model.Invoices = invoiceModels; return(View(model)); }
public ActionResult NewMonthInvoices() { var Flats = db.FlatModels.ToList(); float totalSuppliers = db.ContratModels.Sum(s => s.Value); float totalSalaries = db.EmployeeModels.Sum(s => s.Salary); float numberOfFlats = db.FlatModels.Count(); float rate = 0.5F; foreach (var item in Flats) { float InvoiceAmount = ((totalSuppliers + totalSalaries) / numberOfFlats) * item.NumberOfRooms * (item.NumberOfPersons * rate); var newInvoice = new InvoiceModels(); newInvoice.FlatId = item.Id; newInvoice.InvoiceDate = DateTime.Now; newInvoice.Value = InvoiceAmount; newInvoice.Paid = false; db.InvoiceModels.Add(newInvoice); db.SaveChanges(); } string redirectUrl = "/Flat/Index"; return(Redirect(redirectUrl)); }
// GET: Invoice/Create public ActionResult Create() { ViewBag.ClientID = new SelectList(db.Client, "ClientID", "CompanyName"); var model = new InvoiceModels(); return(View(model)); }
public ActionResult AddInvoice([Bind(Include = "Id,FlatId,Value,InvoiceDate")] InvoiceModels invoiceModels) { if (ModelState.IsValid) { invoiceModels.Paid = false; db.InvoiceModels.Add(invoiceModels); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(invoiceModels)); }
public ActionResult DeleteConfirmed(int id) { InvoiceModels invoiceModels = db.Invoice.Find(id); db.Invoice.Remove(invoiceModels); //TODO: Remove SaleItems from db when Invoice is removed //List<SaleItemModels> saleItems = db.SaleItem.Where(s => s.InvoiceID == invoiceModels.InvoiceID).ToList(); //saleItems.ForEach(si => saleItems.Remove(si)); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "InvoiceID,ClientID,TotalAmount,PurchaseOrder,InvoiceStatus,InvoiceDate,ShipDate")] InvoiceModels invoice) { if (ModelState.IsValid) { if (db.Invoice.Any(i => i.InvoiceID == invoice.InvoiceID && (int)i.InvoiceStatus != 2 && (int)invoice.InvoiceStatus == 2)) { invoice.ShipDate = DateTime.Now.ToString("MM/dd/yyyy"); } db.Entry(invoice).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ClientID = new SelectList(db.Client, "ClientID", "CompanyName", invoice.ClientID); return(View(invoice)); }
public ActionResult Create([Bind(Include = "InvoiceID,ClientID,PurchaseOrder")] InvoiceModels invoice) { if (ModelState.IsValid) { invoice.InvoiceDate = DateTime.Now.ToString("MM/dd/yyyy"); db.Invoice.Add(invoice); db.SaveChanges(); return(RedirectToAction("Edit", "Invoice", new { id = invoice.InvoiceID })); } ViewBag.ClientID = new SelectList(db.Client, "ClientID", "CompanyName", invoice.ClientID); return(View(invoice)); }
// GET: Invoice/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } InvoiceModels invoiceModels = db.Invoice.Find(id); if (invoiceModels == null) { return(HttpNotFound()); } ClientModels client = db.Client.Find(invoiceModels.ClientID); ViewBag.CompanyName = client.CompanyName; return(View(invoiceModels)); }
public IActionResult Edit(int invoiceId) { InvoiceAdapter invoiceAdapter = new InvoiceAdapter(); Invoice invoice = invoiceAdapter.GetById(invoiceId); if (invoice == null) { return(RedirectToAction("Index")); } else { InvoiceModels model = new InvoiceModels(); model.InvoiceId = invoice.InvoiceId; model.CustomerId = invoice.CustomerId; model.Total = invoice.Total; model.InvoiceDate = invoice.InvoiceDate; return(View(model)); } }
// GET: Invoice/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } InvoiceModels invoiceModels = db.Invoice.Find(id); if (invoiceModels == null) { return(HttpNotFound()); } ViewBag.ClientID = new SelectList(db.Client, "ClientID", "CompanyName", invoiceModels.ClientID); ViewBag.InvoiceID = invoiceModels.InvoiceID; ViewBag.Products = db.Products.ToList().OrderBy(p => p.Name); invoiceModels.LineItems = db.SaleItem.Where(i => i.InvoiceID == invoiceModels.InvoiceID).ToList(); return(View(invoiceModels)); }
// GET: Invoice/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } InvoiceModels invoiceModels = db.Invoice.Find(id); if (invoiceModels == null) { return(HttpNotFound()); } ClientModels client = db.Client.Find(invoiceModels.ClientID); ViewBag.LineItems = db.SaleItem.Where(li => li.InvoiceID == invoiceModels.InvoiceID).ToList(); ViewBag.CompanyName = client.CompanyName; return(View(invoiceModels)); }
public ActionResult Add(InvoiceModels model) { if (ModelState.IsValid) { InvoiceAdapter customerAdapter = new InvoiceAdapter(); Invoice invoice = new Invoice(); invoice.CustomerId = model.CustomerId; invoice.Total = model.Total; invoice.InvoiceDate = model.InvoiceDate; bool returnValue = customerAdapter.InsertInvoice(invoice); if (returnValue) { return(RedirectToAction("Index")); } else { return(View(model)); } } return(View(model)); }