public int CatalogConditionDetailAdd(CatalogConditionDetail catalogConditionDetail, Int32 storeID, Int32 portalID, string userName, string culture) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Parameters.Add(new SqlParameter("@CatalogPriceRuleConditionID", catalogConditionDetail.CatalogPriceRuleConditionID)); sqlCommand.Parameters.Add(new SqlParameter("@CatalogPriceRuleID", catalogConditionDetail.CatalogPriceRuleID)); sqlCommand.Parameters.Add(new SqlParameter("@AttributeID", catalogConditionDetail.AttributeID)); sqlCommand.Parameters.Add(new SqlParameter("@RuleOperatorID", catalogConditionDetail.RuleOperatorID)); sqlCommand.Parameters.Add(new SqlParameter("@Value", catalogConditionDetail.Value)); sqlCommand.Parameters.Add(new SqlParameter("@Priority", catalogConditionDetail.Priority)); sqlCommand.Parameters.Add(new SqlParameter("@IsActive", true)); sqlCommand.Parameters.Add(new SqlParameter("@StoreID", storeID)); sqlCommand.Parameters.Add(new SqlParameter("@PortalID", portalID)); sqlCommand.Parameters.Add(new SqlParameter("@Username", userName)); sqlCommand.Parameters.Add(new SqlParameter("@CultureName", culture)); sqlCommand.CommandText = "usp_Aspx_CatalogConditionDetailAdd"; sqlCommand.CommandType = CommandType.StoredProcedure; SqlConnection sqlConnection = new SqlConnection(ConnectionString); try { sqlCommand.Connection = sqlConnection; sqlConnection.Open(); object val = sqlCommand.ExecuteScalar(); return(Convert.ToInt16(val)); } catch (Exception e) { throw e; } finally { sqlConnection.Close(); } }
public static int CatalogConditionDetailAdd(CatalogConditionDetail catalogConditionDetail, AspxCommonInfo aspxCommonObj) { OracleCommand sqlCommand = new OracleCommand(); sqlCommand.Parameters.Add(new OracleParameter("CatalogPriceRuleConditionID", catalogConditionDetail.CatalogPriceRuleConditionID)); sqlCommand.Parameters.Add(new OracleParameter("CatalogPriceRuleID", catalogConditionDetail.CatalogPriceRuleID)); sqlCommand.Parameters.Add(new OracleParameter("AttributeID", catalogConditionDetail.AttributeID)); sqlCommand.Parameters.Add(new OracleParameter("RuleOperatorID", catalogConditionDetail.RuleOperatorID)); sqlCommand.Parameters.Add(new OracleParameter("Value", catalogConditionDetail.Value)); sqlCommand.Parameters.Add(new OracleParameter("Priority", catalogConditionDetail.Priority)); sqlCommand.Parameters.Add(new OracleParameter("IsActive", true)); sqlCommand.Parameters.Add(new OracleParameter("StoreID", aspxCommonObj.StoreID)); sqlCommand.Parameters.Add(new OracleParameter("PortalID", aspxCommonObj.PortalID)); sqlCommand.Parameters.Add(new OracleParameter("UserName", aspxCommonObj.UserName)); sqlCommand.Parameters.Add(new OracleParameter("CultureName", aspxCommonObj.CultureName)); sqlCommand.CommandText = "usp_Aspx_CatalogConditionDetailAdd"; sqlCommand.CommandType = CommandType.StoredProcedure; OracleConnection sqlConnection = new OracleConnection(ConnectionString); try { sqlCommand.Connection = sqlConnection; sqlConnection.Open(); object val = sqlCommand.ExecuteScalar(); return(Convert.ToInt16(val)); } catch (Exception e) { throw e; } finally { sqlConnection.Close(); } }
public static int CatalogConditionDetailAdd(CatalogConditionDetail catalogConditionDetail, AspxCommonInfo aspxCommonObj) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Parameters.Add(new SqlParameter("@CatalogPriceRuleConditionID", catalogConditionDetail.CatalogPriceRuleConditionID)); sqlCommand.Parameters.Add(new SqlParameter("@CatalogPriceRuleID", catalogConditionDetail.CatalogPriceRuleID)); sqlCommand.Parameters.Add(new SqlParameter("@AttributeID", catalogConditionDetail.AttributeID)); sqlCommand.Parameters.Add(new SqlParameter("@RuleOperatorID", catalogConditionDetail.RuleOperatorID)); sqlCommand.Parameters.Add(new SqlParameter("@Value", catalogConditionDetail.Value)); sqlCommand.Parameters.Add(new SqlParameter("@Priority", catalogConditionDetail.Priority)); sqlCommand.Parameters.Add(new SqlParameter("@IsActive", true)); sqlCommand.Parameters.Add(new SqlParameter("@StoreID", aspxCommonObj.StoreID)); sqlCommand.Parameters.Add(new SqlParameter("@PortalID", aspxCommonObj.PortalID)); sqlCommand.Parameters.Add(new SqlParameter("@UserName", aspxCommonObj.UserName)); sqlCommand.Parameters.Add(new SqlParameter("@CultureName", aspxCommonObj.CultureName)); sqlCommand.CommandText = "usp_Aspx_CatalogConditionDetailAdd"; sqlCommand.CommandType = CommandType.StoredProcedure; SqlConnection sqlConnection = new SqlConnection(ConnectionString); try { sqlCommand.Connection = sqlConnection; sqlConnection.Open(); object val = sqlCommand.ExecuteScalar(); return Convert.ToInt16(val); } catch (Exception e) { throw e; } finally { sqlConnection.Close(); } }