internal static void Update(IEntity entity)
{
CombinationProduct combinationProductEntity = (CombinationProduct)(entity);
using (SqlConnection sqlConnection = new SqlConnection(CMSCoreBase.CMSCoreConnectionString))
{
SqlCommand sqlCommand = new SqlCommand(SN_COMBINATION_PRODUCT_UPDATE, sqlConnection);
sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter sqlParameter = null;
sqlParameter = new SqlParameter(PN_COMBINATION_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = combinationProductEntity.ID;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_COMBINATION_PRODUCT_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = combinationProductEntity.ProductID;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_COMBINATION_PRODUCT_REFERENCE_NAME, System.Data.SqlDbType.NVarChar);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = combinationProductEntity.ProductReference;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_COMBINATION_PRODUCT_EAN13_NAME, System.Data.SqlDbType.NVarChar);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = combinationProductEntity.ProductEAN13;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_COMBINATION_PRODUCT_UPC_NAME, System.Data.SqlDbType.NVarChar);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = combinationProductEntity.ProductUPC;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_COMBINATION_PRODUCT_SUPPLIER_REFERENCE, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = combinationProductEntity.SupplierRefernce;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_COMBINATION_PRODUCT_WHOLESALE_PRICE, System.Data.SqlDbType.Decimal);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = combinationProductEntity.WholesalePrice;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_COMBINATION_PRODUCT_IMPACT_ON_PRICE, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = combinationProductEntity.ImpactOnPrice;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_COMBINATION_PRODUCT_IMPACT_ON_WEIGHT, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = combinationProductEntity.ImpactOnWeight;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_COMBINATION_PRODUCT_INITIAL_STOCK, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = combinationProductEntity.InitialStock;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_COMBINATION_PRODUCT_MINIMUM_QUANTITY, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = combinationProductEntity.MinimumQuantity;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_COMBINATION_PRODUCT_IS_DEFAULT, System.Data.SqlDbType.Bit);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = combinationProductEntity.IsDefault;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_COMBINATION_PRODUCT_COLOR, System.Data.SqlDbType.NVarChar);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = combinationProductEntity.Color;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_COMBINATION_PRODUCT_LOCATION, System.Data.SqlDbType.NVarChar);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = combinationProductEntity.Location;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(ECommerceDataMapperBase.PN_MODULE_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = CMSEnums.ECommerceModule.CombinationProduct;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(ECommerceDataMapperBase.PN_ECO_LAN_LAN_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = combinationProductEntity.LanguageID;
sqlCommand.Parameters.Add(sqlParameter);
try
{
sqlCommand.Connection.Open();
sqlCommand.ExecuteNonQuery();
sqlCommand.Connection.Close();
}
catch (Exception ex)
{
throw ex;
}
}
}