/// <summary>
/// Update Product
/// </summary>
/// <param name="product"></param>
/// <returns></returns>
public bool UpdateProduct(Product product)
{
using (var transaction = _dbContext.Database.BeginTransaction())
{
try
{
Product saveEntity = _dbContext.Product.Where(model => model.ID.Equals(product.ID)).FirstOrDefault();
saveEntity.Name = (!string.IsNullOrEmpty(product.Name)) ? product.Name : saveEntity.Name;
saveEntity.Unit = (!string.IsNullOrEmpty(product.Unit)) ? product.Unit : saveEntity.Unit;
saveEntity.Remark = (!string.IsNullOrEmpty(product.Remark)) ? product.Remark : saveEntity.Remark;
saveEntity.Area = (!string.IsNullOrEmpty(product.Area)) ? product.Area : saveEntity.Area;
saveEntity.IsInStock = (product.IsInStock > -1) ? product.IsInStock : saveEntity.IsInStock;
saveEntity.Type = (product.Type > -1) ? product.Type : saveEntity.Type;
saveEntity.YouTubeUrl = (!string.IsNullOrEmpty(product.YouTubeUrl)) ? product.YouTubeUrl : saveEntity.YouTubeUrl;
if (_dbContext.SaveChanges() <= 0)
{
return(false);
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
return(true);
}
/// <summary>
/// CreateAdvertise
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int CreateAdvertise(Advertise model)
{
using (var transaction = _dbContext.Database.BeginTransaction())
{
try
{
_dbContext.Advertise.Add(model);
if (_dbContext.SaveChanges() <= 0)
{
return(0);
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
return(model.ID);
}
}
