// GET: Customer/Details/5 public async Task <ActionResult> Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } sal_Customer sal_Customer = await db.sal_Customer.FindAsync(id); if (sal_Customer == null) { return(HttpNotFound()); } ViewBag.Reciept = db.sal_Reciept.Where(I => I.CustomerID == id).ToList(); var vv = db.sal_Reciept.Where(I => I.CustomerID == id).ToList(); ViewBag.Remaining = vv.Sum(x => (decimal)x.RecieptRemaining); ViewBag.RecieptCount = vv.Count(); ViewBag.NotPaidReciept = vv.Where(I => I.RecieptPaymentStatus == 2).ToList().Count(); // Not return(View(sal_Customer)); }
public async Task <ActionResult> DeleteConfirmed(int id) { sal_Customer sal_Customer = await db.sal_Customer.FindAsync(id); db.sal_Customer.Remove(sal_Customer); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task <ActionResult> Edit([Bind(Include = "CustomerID,CustomerName,CustomerPhone,CustomerEmail,CustomerBankAcount,CustomerRegisterationDate")] sal_Customer sal_Customer) { if (ModelState.IsValid) { db.Entry(sal_Customer).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(sal_Customer)); }
// GET: Customer/Delete/5 public async Task <ActionResult> Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } sal_Customer sal_Customer = await db.sal_Customer.FindAsync(id); if (sal_Customer == null) { return(HttpNotFound()); } return(View(sal_Customer)); }
public ActionResult Save(sal_Customer Customer) { int status = 0; string[] ErrorList = new string[400]; // Start Validation cheack if (ModelState.IsValid) { //################### Edit Customer Page ###################// if (Customer.CustomerID > 0) { var v = db.sal_Customer.Where(I => I.CustomerID == Customer.CustomerID).FirstOrDefault(); if (v != null) { var CustomerPhone = db.sal_Customer.Where(I => I.CustomerPhone == Customer.CustomerPhone && I.CustomerID != v.CustomerID).FirstOrDefault(); if (CustomerPhone != null) { status = 3; // error -> trucks exist } else { v.CustomerID = Customer.CustomerID; v.CustomerName = Customer.CustomerName; v.CustomerPhone = Customer.CustomerPhone; v.CustomerBankAcount = Customer.CustomerBankAcount; status = 1; // 1 for update db.SaveChanges(); } } } // Edit Customer Page //################### Save New Customer Pahe ################### else { // Check Customer Exist var CustomerPhone = db.sal_Customer.Where(I => I.CustomerPhone == Customer.CustomerPhone).FirstOrDefault(); if (CustomerPhone != null) { status = 3; // Error -> Customer phone exist } else { db.sal_Customer.Add(Customer); db.SaveChanges(); status = 2; // 2 } } // Save New Customer return(new JsonResult { Data = new { status = status } }); } // End Validation cheack // Start Send validation error else { var errorList = ModelState.Values.SelectMany(m => m.Errors).Select(e => e.ErrorMessage).ToList(); return(new JsonResult { Data = new { status = errorList } }); } // End Send validation error }