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