public static bool ChangeUserPassword(User user) { using (StoreManagementEntities store = new StoreManagementEntities()) { store.Entry(user).State = EntityState.Modified; if (store.SaveChanges() > 0) { return(true); } return(false); } }
public static bool DecreaseFromStock(int productID, int numberOfProducts) { using (StoreManagementEntities store = new StoreManagementEntities()) { var product = store.Product.Where(s => s.ID == productID).First(); product.Stock -= numberOfProducts; if (store.SaveChanges() > 0) { return(true); } return(false); } }
public static bool CRUDProduct(Product product, EntityState state) { using (StoreManagementEntities store = new StoreManagementEntities()) { if (state == EntityState.Deleted) { product.RegistrationStatus = (byte)RegistrationStatus.Passive; } else { store.Entry(product).State = state; product.RegistrationStatus = (byte)RegistrationStatus.Active; } if (store.SaveChanges() > 0) { return(true); } return(false); } }
public static bool CRUDCustomer(Customer customer, EntityState state) { using (StoreManagementEntities store = new StoreManagementEntities()) { if (state == EntityState.Deleted) { customer.RegistrationStatus = (byte)RegistrationStatus.Passive; store.Entry(customer).State = EntityState.Modified; } else { store.Entry(customer).State = state; customer.RegistrationStatus = (byte)RegistrationStatus.Active; } if (store.SaveChanges() > 0) { return(true); } return(false); } }
public void Save() { DbContext.SaveChanges(); }
public JsonResult AddProduct(Product product) { StoreManagementEntitiesdb.Entry(product).State = EntityState.Added; return(Json(StoreManagementEntitiesdb.SaveChanges())); }
public int Save() { return(DbContext.SaveChanges()); }
public JsonResult AddStore(Store store) { StoreManagementEntitiesdb.Entry(store).State = EntityState.Added; return(Json(StoreManagementEntitiesdb.SaveChanges())); }
public JsonResult AddCustomer(Customer customer) { //StoreManagementEntitiesdb.Customers.Add(customer); StoreManagementEntitiesdb.Entry(customer).State = EntityState.Added; return(Json(StoreManagementEntitiesdb.SaveChanges())); }
public JsonResult AddSale(ProductSold ps) { StoreManagementEntitiesdb.ProductSolds.Add(ps); return(Json(StoreManagementEntitiesdb.SaveChanges())); }