public bool Update(User user) { try { var contaxt = new DataLayer.InventoryDBContext(); var _user = contaxt.Users.FirstOrDefault(p => p.UserId == user.UserId); _user = user; contaxt.SaveChanges(); return(true); } catch { return(true); } }
public bool Add(User user) { try { var contaxt = new DataLayer.InventoryDBContext(); user.RegisterDate = DateTime.Now; user.Deleted = false; contaxt.Users.Add(user); contaxt.SaveChanges(); return(true); } catch { return(false); } }
public bool Add(Product product) { try { var contaxt = new DataLayer.InventoryDBContext(); product.CreatedDate = DateTime.Now; product.CreatedByUserId = DatabaseTools.GetUserID; contaxt.Products.Add(product); contaxt.SaveChanges(); return(true); } catch { return(false); } }
public bool Delete(int id) { try { var contaxt = new DataLayer.InventoryDBContext(); var user = contaxt.Users.FirstOrDefault(p => p.UserId == id); user.Deleted = true; user.DeletedByUserId = DatabaseTools.GetUserID; user.DeletedDate = DateTime.Now; contaxt.SaveChanges(); return(true); } catch { return(true); } }
public bool Delete(int id) { try { var contaxt = new DataLayer.InventoryDBContext(); var product = contaxt.Products.Where(p => p.ProductId == id).FirstOrDefault(); product.Deleted = true; product.DeletedDate = DateTime.Now; product.DeletedByUserId = DatabaseTools.GetUserID; contaxt.SaveChanges(); return(true); } catch { return(false); } }
public bool Update(Product product) { try { var contaxt = new DataLayer.InventoryDBContext(); var _product = contaxt.Products.Where(p => p.ProductId == product.ProductId).FirstOrDefault(); _product = product; _product.ChangedDate = DateTime.Now; _product.ChangedByUserId = DatabaseTools.GetUserID; contaxt.SaveChanges(); return(true); } catch { return(false); } }
public bool Update(ProductUnit unit) { try { var contaxt = new DataLayer.InventoryDBContext(); var _unit = contaxt.ProductUnits.FirstOrDefault(p => p.ProductUnitId == unit.ProductUnitId); _unit = unit; _unit.ChangedByUserId = DatabaseTools.GetUserID; _unit.ChangedDate = DateTime.Now; contaxt.SaveChanges(); return(true); } catch { return(true); } }
public bool Update(Inventory inventory) { try { var contaxt = new DataLayer.InventoryDBContext(); var _inventory = contaxt.Inventories.FirstOrDefault(p => p.InventoryId == inventory.InventoryId); _inventory = inventory; _inventory.ChangedDate = DateTime.Now; _inventory.ChangedByUserId = DatabaseTools.GetUserID; contaxt.SaveChanges(); return(true); } catch { return(true); } }
public bool Add(Inventory inventory) { try { var contaxt = new DataLayer.InventoryDBContext(); inventory.Deleted = false; inventory.CreatedByUserId = DatabaseTools.GetUserID; inventory.CreatedDate = DateTime.Now; contaxt.Inventories.Add(inventory); contaxt.SaveChanges(); return(true); } catch { return(false); } }