public static int SaveCatalogPricingRule(CatalogPricingRuleInfo objCatalogPricingRuleInfo, AspxCommonInfo aspxCommonObj, List <int> parentID)
{
int catalogPriceRuleID = -1;
catalogPriceRuleID = AspxCatalogPriceRuleProvider.CatalogPriceRuleAdd(objCatalogPricingRuleInfo.CatalogPriceRule, aspxCommonObj);
if (catalogPriceRuleID > 0)
{
int count = 0;
int cpID = 0;
int catalogConditionID = 0;
List <int> lstParent = parentID;//new JavaScriptSerializer().ConvertToType<List<object>>(parentID);
foreach (CatalogPriceRuleCondition catalogPriceRuleCondition in objCatalogPricingRuleInfo.CatalogPriceRuleConditions)
{
if (count == 1 && catalogConditionID > 1)
{
cpID = catalogConditionID - 1;
}
catalogPriceRuleCondition.ParentID = cpID + int.Parse(lstParent[count].ToString());
catalogPriceRuleCondition.CatalogPriceRuleID = catalogPriceRuleID;
catalogConditionID = AspxCatalogPriceRuleProvider.CatalogPriceRuleConditionAdd(catalogPriceRuleCondition, aspxCommonObj);
count++;
}
int catalogPriceRuleRoleID = -1;
foreach (CatalogPriceRuleRole catalogPriceRuleRole in objCatalogPricingRuleInfo.CatalogPriceRuleRoles)
{
catalogPriceRuleRole.CatalogPriceRuleID = catalogPriceRuleID;
catalogPriceRuleRoleID = AspxCatalogPriceRuleProvider.CatalogPriceRuleRoleAdd(catalogPriceRuleRole, aspxCommonObj);
}
}
return(1);
}
public static CatalogPricingRuleInfo GetCatalogPricingRule(Int32 catalogPriceRuleID, AspxCommonInfo aspxCommonObj)
{
DataSet ds = new DataSet();
ds = AspxCatalogPriceRuleProvider.GetCatalogPricingRule(catalogPriceRuleID, aspxCommonObj);
DataTable dtCatalogPricingRule = ds.Tables[0];
DataTable dtCatalogPriceRuleCondition = ds.Tables[1];
DataTable dtCatalogConditionDetails = ds.Tables[2];
DataTable dtCatalogPriceRuleRoles = ds.Tables[3];
List <CatalogPriceRule> lstCatalogPriceRule;
lstCatalogPriceRule = DataSourceHelper.FillCollection <CatalogPriceRule>(dtCatalogPricingRule);
List <CatalogPriceRuleCondition> lstCatalogPriceRuleCondition;
lstCatalogPriceRuleCondition = DataSourceHelper.FillCollection <CatalogPriceRuleCondition>(dtCatalogPriceRuleCondition);
List <CatalogPriceRuleRole> lstCatalogPriceRuleRole;
lstCatalogPriceRuleRole = DataSourceHelper.FillCollection <CatalogPriceRuleRole>(dtCatalogPriceRuleRoles);
List <CatalogConditionDetail> lstCatalogConditionDetail;
lstCatalogConditionDetail = DataSourceHelper.FillCollection <CatalogConditionDetail>(dtCatalogConditionDetails);
CatalogPricingRuleInfo catalogPricingRuleInfo = new CatalogPricingRuleInfo();
CatalogPriceRule catalogPriceRule = lstCatalogPriceRule[0];
catalogPricingRuleInfo.CatalogPriceRule = catalogPriceRule;
List <CatalogPriceRuleCondition> lstCPRC = new List <CatalogPriceRuleCondition>();
foreach (CatalogPriceRuleCondition catalogPriceRuleCondition in lstCatalogPriceRuleCondition)
{
List <CatalogConditionDetail> lstCCD = new List <CatalogConditionDetail>();
foreach (CatalogConditionDetail catalogConditionDetail in lstCatalogConditionDetail)
{
if (catalogPriceRuleCondition.CatalogPriceRuleConditionID == catalogConditionDetail.CatalogPriceRuleConditionID)
{
lstCCD.Add(catalogConditionDetail);
}
}
catalogPriceRuleCondition.CatalogConditionDetail = lstCCD;
lstCPRC.Add(catalogPriceRuleCondition);
}
catalogPricingRuleInfo.CatalogPriceRuleConditions = lstCPRC;
List <CatalogPriceRuleRole> lstCPRR = new List <CatalogPriceRuleRole>();
foreach (CatalogPriceRuleRole catalogPriceRuleRole in lstCatalogPriceRuleRole)
{
if (catalogPriceRuleRole.CatalogPriceRuleID == catalogPriceRule.CatalogPriceRuleID)
{
lstCPRR.Add(catalogPriceRuleRole);
}
}
catalogPricingRuleInfo.CatalogPriceRuleRoles = lstCPRR;
return(catalogPricingRuleInfo);
}
public static bool CheckCatalogPriorityUniqueness(int catalogPriceRuleID, int priority, AspxCommonInfo aspxCommonObj)
{
try
{
bool isUnique = AspxCatalogPriceRuleProvider.CheckCatalogPriorityUniqueness(catalogPriceRuleID, priority, aspxCommonObj);
return(isUnique);
}
catch (Exception e)
{
throw e;
}
}
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 List <CatalogPriceRulePaging> GetCatalogPricingRules(string ruleName, System.Nullable <DateTime> startDate, System.Nullable <DateTime> endDate, System.Nullable <bool> isActive, AspxCommonInfo aspxCommonObj, int offset, int limit)
{
List <CatalogPriceRulePaging> lstCatalogPriceRule = AspxCatalogPriceRuleProvider.GetCatalogPricingRules(ruleName, startDate, endDate, isActive, aspxCommonObj, offset, limit);
return(lstCatalogPriceRule);
}
public static List <PricingRuleAttributeInfo> GetPricingRuleAttributes(AspxCommonInfo aspxCommonObj)
{
List <PricingRuleAttributeInfo> lstPriceRuleAttr = AspxCatalogPriceRuleProvider.GetPricingRuleAttributes(aspxCommonObj);
return(lstPriceRuleAttr);
}
public static int CatalogPriceMultipleRulesDelete(string catRulesIds, AspxCommonInfo aspxCommonObj)
{
int retValue = AspxCatalogPriceRuleProvider.CatalogPriceRulesMultipleDelete(catRulesIds, aspxCommonObj);
return(retValue);
}
public static int CatalogPriceRuleDelete(int catalogPriceRuleID, AspxCommonInfo aspxCommonObj)
{
int retValue = AspxCatalogPriceRuleProvider.CatalogPriceRuleDelete(catalogPriceRuleID, aspxCommonObj);
return(retValue);
}
public bool CheckCatalogRuleExist(AspxCommonInfo aspxCommonObj)
{
AspxCatalogPriceRuleProvider objCatalog = new AspxCatalogPriceRuleProvider();
return(objCatalog.CheckCatalogRuleExist(aspxCommonObj));
}
public void ApplyCatalogPricingRule(AspxCommonInfo aspxCommonObj)
{
AspxCatalogPriceRuleProvider objCatalog = new AspxCatalogPriceRuleProvider();
objCatalog.ApplyCatalogPricingRule(aspxCommonObj);
}
public bool CheckCatalogRuleExist(AspxCommonInfo aspxCommonObj)
{
AspxCatalogPriceRuleProvider objCatalog = new AspxCatalogPriceRuleProvider();
return objCatalog.CheckCatalogRuleExist(aspxCommonObj);
}
public void ApplyCatalogPricingRule(AspxCommonInfo aspxCommonObj)
{
AspxCatalogPriceRuleProvider objCatalog = new AspxCatalogPriceRuleProvider();
objCatalog.ApplyCatalogPricingRule(aspxCommonObj);
}
