public ActionResult GenerateBill(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var BagsDetail = db.AspNetBillDetails.Where(x => x.BillID == id).ToList(); ViewBag.BagsDetail = BagsDetail; AspNetBill aspNetBill = db.AspNetBills.Find(id); aspNetBill.Amount = db.AspNetBillDetails.Where(x => x.BillID == id).Sum(x => x.Amount); aspNetBill.Freight_Charges = aspNetBill.Freight_Charges; aspNetBill.Commission = (aspNetBill.Amount * 5) / 100; aspNetBill.Labour = (aspNetBill.Amount * 10) / 100; aspNetBill.Market_Fees = BagsDetail.Sum(x => x.Bags) * 2; aspNetBill.Telephone_Charges = 5; aspNetBill.Accountant = BagsDetail.Sum(x => x.Bags); aspNetBill.Total_Expenses = aspNetBill.Freight_Charges + aspNetBill.Commission + aspNetBill.Labour + aspNetBill.Market_Fees + aspNetBill.Telephone_Charges + aspNetBill.Accountant; aspNetBill.Expenses = aspNetBill.Total_Expenses; aspNetBill.Total_Amount = aspNetBill.Amount - aspNetBill.Expenses; if (aspNetBill == null) { return(HttpNotFound()); } return(View(aspNetBill)); }
public ActionResult DeleteConfirmed(int id) { AspNetBill aspNetBill = db.AspNetBills.Find(id); db.AspNetBills.Remove(aspNetBill); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,FarmerID,Date,Truck_No,Bags_Qty,Freight_Charges,Commission,Labour,Market_Fees,Telephone_Charges,Accountant,Total_Expenses,Amount,Expenses,Total_Amount")] AspNetBill aspNetBill) { if (ModelState.IsValid) { db.Entry(aspNetBill).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.FarmerID = new SelectList(db.AspNetFarmers, "Id", "Name", aspNetBill.FarmerID); return(View(aspNetBill)); }
// GET: AspNetBills/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspNetBill aspNetBill = db.AspNetBills.Find(id); if (aspNetBill == null) { return(HttpNotFound()); } return(View(aspNetBill)); }
// GET: AspNetBills/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspNetBill aspNetBill = db.AspNetBills.Find(id); if (aspNetBill == null) { return(HttpNotFound()); } ViewBag.FarmerID = new SelectList(db.AspNetFarmers, "Id", "Name", aspNetBill.FarmerID); return(View(aspNetBill)); }
public ActionResult Create([Bind(Include = "Id,FarmerID,Date,Truck_No,Bags_Qty,Freight_Charges,Commission,Labour,Market_Fees,Telephone_Charges,Accountant,Total_Expenses,Amount,Expenses,Total_Amount")] AspNetBill aspNetBill) { if (ModelState.IsValid) { aspNetBill.FarmerName = db.AspNetFarmers.Where(x => x.Id == aspNetBill.FarmerID).Select(x => x.Name).First(); aspNetBill.Bill_Status = "Not Generated"; aspNetBill.Freight_Charges = 0; db.AspNetBills.Add(aspNetBill); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.FarmerID = new SelectList(db.AspNetFarmers, "Id", "Name", aspNetBill.FarmerID); return(View(aspNetBill)); }
public ActionResult GenerateBill(AspNetBill aspNetBill) { if (ModelState.IsValid) { AspNetBill aspNetBills = db.AspNetBills.Find(aspNetBill.Id); aspNetBill.FarmerID = aspNetBill.FarmerID; aspNetBills.Accountant = aspNetBill.Accountant; aspNetBills.Amount = aspNetBill.Amount; aspNetBills.Commission = aspNetBill.Commission; aspNetBills.Expenses = aspNetBill.Expenses; aspNetBills.Freight_Charges = aspNetBill.Freight_Charges; aspNetBills.Labour = aspNetBill.Labour; aspNetBills.Market_Fees = aspNetBill.Market_Fees; aspNetBills.Telephone_Charges = aspNetBill.Telephone_Charges; aspNetBills.Total_Amount = aspNetBill.Total_Amount; aspNetBills.Total_Expenses = aspNetBill.Total_Expenses; aspNetBills.Bill_Status = "Generated"; db.SaveChanges(); var BagsDetails = db.AspNetBillDetails.Where(x => x.BillID == aspNetBill.Id).ToList(); ViewBag.BagsDetail = BagsDetails; return(View(aspNetBills)); } var BagsDetail = db.AspNetBillDetails.Where(x => x.BillID == aspNetBill.Id).ToList(); ViewBag.BagsDetail = BagsDetail; aspNetBill.Bill_Status = "Not Generated"; aspNetBill.Amount = db.AspNetBillDetails.Where(x => x.BillID == aspNetBill.Id).Sum(x => x.Amount); aspNetBill.Freight_Charges = aspNetBill.Freight_Charges; aspNetBill.Commission = (aspNetBill.Amount * 5) / 100; aspNetBill.Labour = (aspNetBill.Amount * 10) / 100; aspNetBill.Market_Fees = BagsDetail.Sum(x => x.Bags) * 2; aspNetBill.Telephone_Charges = 5; aspNetBill.Accountant = BagsDetail.Sum(x => x.Bags); aspNetBill.Total_Expenses = aspNetBill.Freight_Charges + aspNetBill.Commission + aspNetBill.Labour + aspNetBill.Market_Fees + aspNetBill.Telephone_Charges + aspNetBill.Accountant; aspNetBill.Expenses = aspNetBill.Total_Expenses; aspNetBill.Total_Amount = aspNetBill.Amount - aspNetBill.Expenses; return(View(aspNetBill)); }