public int CatalogPriceRuleConditionAdd(CatalogPriceRuleCondition catalogPriceRuleCondition, Int32 storeID, Int32 portalID, string userName, string culture)
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Parameters.Add(new SqlParameter("@CatalogPriceRuleID", catalogPriceRuleCondition.CatalogPriceRuleID));
sqlCommand.Parameters.Add(new SqlParameter("@IsAll", catalogPriceRuleCondition.IsAll));
sqlCommand.Parameters.Add(new SqlParameter("@IsTrue", catalogPriceRuleCondition.IsTrue));
sqlCommand.Parameters.Add(new SqlParameter("@ParentID", catalogPriceRuleCondition.ParentID));
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_CatalogPriceRuleConditionAdd";
sqlCommand.CommandType = CommandType.StoredProcedure;
SqlConnection sqlConnection = new SqlConnection(ConnectionString);
try
{
sqlCommand.Connection = sqlConnection;
sqlConnection.Open();
object val = sqlCommand.ExecuteScalar();
if (Convert.ToInt16(val) > 0)
{
int catalogConditionDetailID = -1;
PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider();
foreach (CatalogConditionDetail catalogConditionDetail in catalogPriceRuleCondition.CatalogConditionDetail)
{
if (catalogConditionDetail != null)
{
catalogConditionDetail.CatalogPriceRuleConditionID = Convert.ToInt16(val);
catalogConditionDetail.CatalogPriceRuleID = catalogPriceRuleCondition.CatalogPriceRuleID;
catalogConditionDetailID =
priceRuleSqlProvider.CatalogConditionDetailAdd(catalogConditionDetail, storeID, portalID,
userName, culture);
if (!(catalogConditionDetailID > 0))
{
}
}
}
}
return(Convert.ToInt16(val));
}
catch (Exception e)
{
throw e;
}
finally
{
sqlConnection.Close();
}
}
public static int CatalogPriceRuleConditionAdd(CatalogPriceRuleCondition catalogPriceRuleCondition, AspxCommonInfo aspxCommonObj)
{
OracleCommand sqlCommand = new OracleCommand();
sqlCommand.Parameters.Add(new OracleParameter("CatalogPriceRuleID", catalogPriceRuleCondition.CatalogPriceRuleID));
sqlCommand.Parameters.Add(new OracleParameter("IsAll", catalogPriceRuleCondition.IsAll));
sqlCommand.Parameters.Add(new OracleParameter("IsTrue", catalogPriceRuleCondition.IsTrue));
sqlCommand.Parameters.Add(new OracleParameter("ParentID", catalogPriceRuleCondition.ParentID));
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_CatalogPriceRuleConditionAdd";
sqlCommand.CommandType = CommandType.StoredProcedure;
OracleConnection sqlConnection = new OracleConnection(ConnectionString);
try
{
sqlCommand.Connection = sqlConnection;
sqlConnection.Open();
object val = sqlCommand.ExecuteScalar();
if (Convert.ToInt16(val) > 0)
{
int catalogConditionDetailID = -1;
foreach (CatalogConditionDetail catalogConditionDetail in catalogPriceRuleCondition.CatalogConditionDetail)
{
if (catalogConditionDetail != null)
{
catalogConditionDetail.CatalogPriceRuleConditionID = Convert.ToInt16(val);
catalogConditionDetail.CatalogPriceRuleID = catalogPriceRuleCondition.CatalogPriceRuleID;
catalogConditionDetailID =
AspxCatalogPriceRuleProvider.CatalogConditionDetailAdd(catalogConditionDetail, aspxCommonObj);
if (!(catalogConditionDetailID > 0))
{
}
}
}
}
return(Convert.ToInt16(val));
}
catch (Exception e)
{
throw e;
}
finally
{
sqlConnection.Close();
}
}
public static int CatalogPriceRuleConditionAdd(CatalogPriceRuleCondition catalogPriceRuleCondition, AspxCommonInfo aspxCommonObj)
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Parameters.Add(new SqlParameter("@CatalogPriceRuleID", catalogPriceRuleCondition.CatalogPriceRuleID));
sqlCommand.Parameters.Add(new SqlParameter("@IsAll", catalogPriceRuleCondition.IsAll));
sqlCommand.Parameters.Add(new SqlParameter("@IsTrue", catalogPriceRuleCondition.IsTrue));
sqlCommand.Parameters.Add(new SqlParameter("@ParentID", catalogPriceRuleCondition.ParentID));
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_CatalogPriceRuleConditionAdd";
sqlCommand.CommandType = CommandType.StoredProcedure;
SqlConnection sqlConnection = new SqlConnection(ConnectionString);
try
{
sqlCommand.Connection = sqlConnection;
sqlConnection.Open();
object val = sqlCommand.ExecuteScalar();
if (Convert.ToInt16(val) > 0)
{
int catalogConditionDetailID = -1;
foreach (CatalogConditionDetail catalogConditionDetail in catalogPriceRuleCondition.CatalogConditionDetail)
{
if (catalogConditionDetail != null)
{
catalogConditionDetail.CatalogPriceRuleConditionID = Convert.ToInt16(val);
catalogConditionDetail.CatalogPriceRuleID = catalogPriceRuleCondition.CatalogPriceRuleID;
catalogConditionDetailID =
AspxCatalogPriceRuleProvider.CatalogConditionDetailAdd(catalogConditionDetail, aspxCommonObj);
if (!(catalogConditionDetailID > 0))
{
}
}
}
}
return Convert.ToInt16(val);
}
catch (Exception e)
{
throw e;
}
finally
{
sqlConnection.Close();
}
}