public virtual QuantityDiscount UpdateQuantityDiscount(QuantityDiscount entity) { if (entity.IsTransient()) { return(entity); } QuantityDiscount other = GetQuantityDiscount(entity.QuantityDiscountId); if (entity.Equals(other)) { return(entity); } string sql = @"Update QuantityDiscount set [QuantityDiscountGUID]=@QuantityDiscountGUID , [Name]=@Name , [DisplayOrder]=@DisplayOrder , [ExtensionData]=@ExtensionData , [DiscountType]=@DiscountType , [CreatedOn]=@CreatedOn where QuantityDiscountID=@QuantityDiscountID" ; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@QuantityDiscountID", entity.QuantityDiscountId) , new SqlParameter("@QuantityDiscountGUID", entity.QuantityDiscountGuid) , new SqlParameter("@Name", entity.Name) , new SqlParameter("@DisplayOrder", entity.DisplayOrder) , new SqlParameter("@ExtensionData", entity.ExtensionData ?? (object)DBNull.Value) , new SqlParameter("@DiscountType", entity.DiscountType) , new SqlParameter("@CreatedOn", entity.CreatedOn) }; SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray); return(GetQuantityDiscount(entity.QuantityDiscountId)); }
public virtual QuantityDiscount InsertQuantityDiscount(QuantityDiscount entity) { QuantityDiscount other = new QuantityDiscount(); other = entity; if (entity.IsTransient()) { string sql = @"Insert into QuantityDiscount ( [QuantityDiscountGUID] ,[Name] ,[DisplayOrder] ,[ExtensionData] ,[DiscountType] ,[CreatedOn] ) Values ( @QuantityDiscountGUID , @Name , @DisplayOrder , @ExtensionData , @DiscountType , @CreatedOn ); Select scope_identity()" ; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@QuantityDiscountID", entity.QuantityDiscountId) , new SqlParameter("@QuantityDiscountGUID", entity.QuantityDiscountGuid) , new SqlParameter("@Name", entity.Name) , new SqlParameter("@DisplayOrder", entity.DisplayOrder) , new SqlParameter("@ExtensionData", entity.ExtensionData ?? (object)DBNull.Value) , new SqlParameter("@DiscountType", entity.DiscountType) , new SqlParameter("@CreatedOn", entity.CreatedOn) }; var identity = SqlHelper.ExecuteScalar(this.ConnectionString, CommandType.Text, sql, parameterArray); if (identity == DBNull.Value) { throw new DataException("Identity column was null as a result of the insert operation."); } return(GetQuantityDiscount(Convert.ToInt32(identity))); } return(entity); }