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