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