public ActionResult DeleteConfirmed(int id) { Sal_tbl sal_tbl = db.Sal_Tbls.Find(id); db.Sal_Tbls.Remove(sal_tbl); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,Cust_Id,Cust_Name,OrderDate")] Sal_tbl sal_tbl) { if (ModelState.IsValid) { db.Entry(sal_tbl).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(sal_tbl)); }
public ActionResult Create([Bind(Include = "Id,Cust_Id,Cust_Name,OrderDate")] Sal_tbl sal_tbl) { if (ModelState.IsValid) { db.Sal_Tbls.Add(sal_tbl); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(sal_tbl)); }
// GET: Sal_tbl/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Sal_tbl sal_tbl = db.Sal_Tbls.Find(id); if (sal_tbl == null) { return(HttpNotFound()); } return(View(sal_tbl)); }
public JsonResult AddOrderAndOrderDetials(OrderViewModel orderViewModel) { bool status = true; var isValidModel = TryUpdateModel(orderViewModel); if (isValidModel) { using (ApplicationDbContext db = new ApplicationDbContext()) { var cusname = db.CUST_TBLs.Find(orderViewModel.Cust_TBLId); Sal_tbl order = new Sal_tbl() { OrderDate = System.DateTime.Now, Cust_Id = orderViewModel.Cust_TBLId, Cust_Name = cusname.CUST_NAME }; db.Sal_Tbls.Add(order); if (db.SaveChanges() > 0) { int orderID = db.Sal_Tbls.Max(o => o.Id); foreach (var item in orderViewModel.Items) { SaleDetails orderDetails = new SaleDetails() { Sal_TblId = orderID, Product_TbleId = item.ProductID, Price = item.Price, QtyOut = item.Quantity, QtyIn = 0, Amount = item.TotalPrice }; Stock stock = new Stock() { Prod_Id = item.ProductID, StQty = -item.Quantity, Case = "مبيعات", Date = System.DateTime.Now, MndId = cusname.MND_TBLId, Cust_Id = orderViewModel.Cust_TBLId }; Cust_Acount cust = new Cust_Acount() { CUST_TBLId = orderViewModel.Cust_TBLId, SalNo = orderID, RslNo = 0, EslNo = 0, Amount = item.TotalPrice, Date = System.DateTime.Now }; db.SaleDetails.Add(orderDetails); db.stocks.Add(stock); db.cust_Acounts.Add(cust); } if (db.SaveChanges() > 0) { return(new JsonResult { Data = new { status = status, message = "Order Added Successfully" } }); } } } } status = false; return(new JsonResult { Data = new { status = status, message = "Error !" } }); }