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);
}
}
