public JsonResult Save(CustomersSupplier customersupplier) { SmallMarketDBEntities db = new SmallMarketDBEntities(); if (customersupplier.Id > 0) { var dbcussup = db.CustomersSuppliers.FirstOrDefault(x => x.Id == customersupplier.Id); dbcussup.Name = customersupplier.Name; dbcussup.Phone = customersupplier.Phone; dbcussup.TypeId = customersupplier.TypeId; dbcussup.DiscountPurchasing = customersupplier.DiscountPurchasing; dbcussup.DiscountSelling = customersupplier.DiscountSelling; db.SaveChanges(); return(Json(dbcussup, JsonRequestBehavior.AllowGet)); } else { db.CustomersSuppliers.Add(customersupplier); } db.SaveChanges(); return(Json(customersupplier, JsonRequestBehavior.AllowGet)); { } }
public JsonResult SaveItem(Item item) { SmallMarketDBEntities db = new SmallMarketDBEntities(); if (item.Id > 0) { var dbitem = db.Items.FirstOrDefault(x => x.Id == item.Id); dbitem.Name = item.Name; dbitem.CategoryId = item.CategoryId; dbitem.PurchasePrice = item.PurchasePrice; dbitem.SellPrice = item.SellPrice; dbitem.UnitId = item.UnitId; dbitem.ValidQuantity = item.ValidQuantity; db.SaveChanges(); return(Json(dbitem, JsonRequestBehavior.AllowGet)); } else { db.Items.Add(item); } db.SaveChanges(); return(Json(item, JsonRequestBehavior.AllowGet)); { } }
public JsonResult SaveOrder(PurchaseSellInvoice item) { bool status = false; DateTime dateOrg; var isValidDate = DateTime.TryParseExact(item.DateString, "mm-dd-yyyy", null, System.Globalization.DateTimeStyles.None, out dateOrg); if (isValidDate) { item.Date = dateOrg; } var isValidModel = TryUpdateModel(item); if (isValidModel) { using (SmallMarketDBEntities dc = new SmallMarketDBEntities()) { dc.PurchaseSellInvoices.Add(item); dc.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public void DeleteItem(int Id) { SmallMarketDBEntities db = new SmallMarketDBEntities(); var item = db.Items.FirstOrDefault(x => x.Id == Id); db.Items.Remove(item); db.SaveChanges(); }