// GET: Supliers/Edit/5 public ActionResult Edit(int?id) { if (Session["UserName"] == null) { return(RedirectToAction("Index", "Login")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } pur_Supliers pur_Supliers = db.pur_Supliers.Find(id); if (pur_Supliers == null) { return(HttpNotFound()); } var bilsNo = db.pur_Bills.Where(b => b.SuplierID == id && b.BillIsReturned == false).Count(); var bilsAmont = db.pur_Bills.Where(b => b.SuplierID == id && b.BillIsReturned == false).Sum(s => s.BillTotalAmount) ?? 0; var bilsPayed = db.pur_Bills.Where(b => b.SuplierID == id && b.BillIsReturned == false).Sum(s => s.BillPaidAmount) ?? 0; var billrimainig = bilsAmont - bilsPayed; ViewBag.bilsNo = bilsNo; ViewBag.bilsAmont = bilsAmont; ViewBag.bilsPayed = bilsPayed; ViewBag.billrimainig = billrimainig; return(View(pur_Supliers)); }
public async Task <ActionResult> DeleteConfirmed(int id) { pur_Supliers pur_Supliers = await db.pur_Supliers.FindAsync(id); db.pur_Supliers.Remove(pur_Supliers); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task <ActionResult> Edit([Bind(Include = "SuplierID,SuplierName,SuplierPhone,SuplierAddress,SuplierAddedDate")] pur_Supliers pur_Supliers) { if (ModelState.IsValid) { db.Entry(pur_Supliers).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(pur_Supliers)); }
public async Task <ActionResult> Create([Bind(Include = "SuplierID,SuplierName,SuplierPhone,SuplierAddress,SuplierAddedDate")] pur_Supliers pur_Supliers) { if (ModelState.IsValid) { db.pur_Supliers.Add(pur_Supliers); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(pur_Supliers)); }
// GET: Supliers/Delete/5 public async Task <ActionResult> Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } pur_Supliers pur_Supliers = await db.pur_Supliers.FindAsync(id); if (pur_Supliers == null) { return(HttpNotFound()); } return(View(pur_Supliers)); }
public ActionResult Save(pur_Supliers Suplire) { int status = 0; // Start Validation cheack if (ModelState.IsValid) { //################### Edit Item ###################// if (Suplire.SuplierID > 0) { var v = db.pur_Supliers.Where(I => I.SuplierID == Suplire.SuplierID).FirstOrDefault(); if (v != null) { v.SuplierID = Suplire.SuplierID; v.SuplierName = Suplire.SuplierName; v.SuplierPhone = Suplire.SuplierPhone; v.SuplierBankAcount = Suplire.SuplierBankAcount; v.UpLoaded = false; status = 1; // 1 for update db.SaveChanges(); } } //################### Edit Item //################### // Start Save New Item else { //Suplire.SuplierID = int.Parse(Session["ii"].ToString()); try { Suplire.UpLoaded = false; Suplire.SuplierRegisterationDate = DateTime.Now; db.pur_Supliers.Add(Suplire); db.SaveChanges(); status = 2; // 2 fro } catch { status = 0; // 2 fro } } //End Save New Item 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 }