public CartPricingRuleInfo GetCartPricingRule(Int32 cartPriceRuleID, Int32 storeID, Int32 portalID, string userName, string culture)
{
CartPricingRuleInfo cartPricingRuleInfo = new CartPricingRuleInfo();
PriceRuleController priceRuleController = new PriceRuleController();
cartPricingRuleInfo = priceRuleController.GetCartPriceRules(cartPriceRuleID, storeID, portalID, userName, culture);
return cartPricingRuleInfo;
}
public string SaveCartPricingRule(CartPricingRuleInfo objCartPriceRule, Int32 storeID, Int32 portalID, string userName, string culture, object parentID)
{
try
{
List<KeyValuePair<string, object>> P1 = new List<KeyValuePair<string, object>>();
//P1.Add(new KeyValuePair<string,object>("@StoreID", storeID));
P1.Add(new KeyValuePair<string, object>("PortalID", portalID));
SQLHandler sql = new SQLHandler();
int count = sql.ExecuteAsScalar<int>("usp_ASPX_CartPrincingRuleCount", P1);
int maxAllowed = 3;
int cartPriceRuleId = objCartPriceRule.CartPriceRule.CartPriceRuleID;
if (cartPriceRuleId > 0)
{
maxAllowed++;
}
if (count < maxAllowed)
{
PriceRuleController priceRuleController = new PriceRuleController();
priceRuleController.SaveCartPricingRule(objCartPriceRule, storeID, portalID, userName, culture, parentID);
//return "({ \"returnStatus\" : 1 , \"Message\" : \"Saving cart pricing rule successfully.\" })";
return "success";
}
else
{
//return "({ \"returnStatus\" : -1 , \"Message\" : \"No more than 3 rules are allowed in Free version of AspxCommerce!\" })";
return "notify";
}
}
catch (Exception ex)
{
ErrorHandler errHandler = new ErrorHandler();
if (errHandler.LogWCFException(ex))
{
return "({ \"returnStatus\" : -1 , \"errorMessage\" : \"" + ex.Message + "\" })";
}
else
{
return "({ \"returnStatus\" : -1, \"errorMessage\" : \"Error while saving cart pricing rule!\" })";
}
}
}
public int SaveCartPricingRule(CartPricingRuleInfo objCartPriceRule, Int32 storeID, Int32 portalID, string userName, string culture, object parentID)
{
SQLHandler sqlH = new SQLHandler();
SqlTransaction tran;
tran = (SqlTransaction) sqlH.GetTransaction();
PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider();
try
{
int cartPriceRuleID = -1;
cartPriceRuleID = priceRuleSqlProvider.CartPriceRuleAdd(objCartPriceRule.CartPriceRule, tran, portalID,userName, culture);
priceRuleSqlProvider.RuleConditionAdd(objCartPriceRule.lstRuleCondition,cartPriceRuleID,parentID, tran, portalID, userName,culture);
foreach (CartPriceRuleRole cartPriceRuleRole in objCartPriceRule.lstCartPriceRuleRoles)
{
cartPriceRuleRole.CartPriceRuleID = cartPriceRuleID;
priceRuleSqlProvider.CartPriceRuleRoleAdd(cartPriceRuleRole, tran, portalID, userName,culture);
}
foreach (CartPriceRuleStore cartPriceRuleStore in objCartPriceRule.lstCartPriceRuleStores)
{
cartPriceRuleStore.CartPriceRuleID = cartPriceRuleID;
priceRuleSqlProvider.CartPriceRuleStoreAdd(cartPriceRuleStore, tran, portalID, userName,culture);
}
tran.Commit();
return cartPriceRuleID;
}
catch (SqlException sqlEX)
{
tran.Rollback();
throw new ArgumentException(sqlEX.Message);
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
}
public CartPricingRuleInfo GetCartPriceRules(Int32 cartPriceRuleID, Int32 storeID, Int32 portalID, string userName, string culture)
{
PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider();
CartPricingRuleInfo cartPricingRuleInfo = new CartPricingRuleInfo();
DataSet ds = new DataSet();
ds = priceRuleSqlProvider.GetCartPriceRule(cartPriceRuleID, portalID, userName, culture);
DataTable dtCartPricingRule = ds.Tables[0];
DataTable dtRuleConditions = ds.Tables[1];
DataTable dtCartPriceRuleRoles = ds.Tables[2];
DataTable dtCartPriceRuleStores = ds.Tables[3];
List<CartPriceRule> lstCartPriceRule = new List<CartPriceRule>();
lstCartPriceRule = DataSourceHelper.FillCollection<CartPriceRule>(dtCartPricingRule);
List<RuleCondition> lstRuleConditions = new List<RuleCondition>();
lstRuleConditions = DataSourceHelper.FillCollection<RuleCondition>(dtRuleConditions);
List<CartPriceRuleRole> lstCartPriceRuleRole = new List<CartPriceRuleRole>();
lstCartPriceRuleRole = DataSourceHelper.FillCollection<CartPriceRuleRole>(dtCartPriceRuleRoles);
List<CartPriceRuleStore> lstCartPriceRuleStore = new List<CartPriceRuleStore>();
lstCartPriceRuleStore = DataSourceHelper.FillCollection<CartPriceRuleStore>(dtCartPriceRuleStores);
cartPricingRuleInfo.CartPriceRule = lstCartPriceRule[0];
List<RuleCondition> lstRC = new List<RuleCondition>();
foreach (RuleCondition rc in lstRuleConditions)
{
RuleCondition objRC = new RuleCondition();
objRC.ParentID = rc.ParentID;
objRC.RuleConditionID = rc.RuleConditionID;
objRC.RuleConditionType = rc.RuleConditionType;
objRC.CartPriceRuleID = rc.CartPriceRuleID;
if (rc.RuleConditionType.ToUpper().Trim() == "PAC".ToUpper().Trim())
{
objRC.lstProductAttributeRuleConditions =
priceRuleSqlProvider.GetCartPriceProductAttributeConditions(rc.RuleConditionID, portalID);
objRC.lstProductAttributeRuleConditions[0].lstCartConditionDetails =
priceRuleSqlProvider.GetCartPriceRuleConditionDetails(rc.CartPriceRuleID,rc.RuleConditionID, portalID, userName);
lstRC.Add(objRC);
}
else if (rc.RuleConditionType.ToUpper().Trim() == "PS".ToUpper().Trim())
{
objRC.lstProductSublectionRuleConditions =
priceRuleSqlProvider.GetCartPriceSubSelections(rc.RuleConditionID, portalID);
objRC.lstProductSublectionRuleConditions[0].lstCartConditionDetails =
priceRuleSqlProvider.GetCartPriceRuleConditionDetails(rc.CartPriceRuleID, rc.RuleConditionID, portalID, userName);
lstRC.Add(objRC);
}
else if (rc.RuleConditionType.ToUpper().Trim() == "CC".ToUpper().Trim())
{
objRC.lstCartPriceRuleConditions =
priceRuleSqlProvider.GetCartPriceRuleConditions(rc.RuleConditionID, portalID);
objRC.lstCartPriceRuleConditions[0].lstCartConditionDetails =
priceRuleSqlProvider.GetCartPriceRuleConditionDetails(rc.CartPriceRuleID, rc.RuleConditionID, portalID, userName);
lstRC.Add(objRC);
}
}
cartPricingRuleInfo.lstRuleCondition = lstRC;
cartPricingRuleInfo.lstCartPriceRuleRoles = lstCartPriceRuleRole;
cartPricingRuleInfo.lstCartPriceRuleStores = lstCartPriceRuleStore;
return cartPricingRuleInfo;
}
public string SaveCartPricingRule(CartPricingRuleInfo objCartPriceRule, Int32 storeID, Int32 portalID, string userName, string culture, Array parentID)
{
try
{
PriceRuleController priceRuleController = new PriceRuleController();
priceRuleController.SaveCartPricingRule(objCartPriceRule, storeID, portalID, userName, culture, parentID);
return "({ \"returnStatus\" : 1 , \"Message\" : \"Saving cart pricing rule successfully.\" })";
}
catch (Exception ex)
{
ErrorHandler errHandler = new ErrorHandler();
if (errHandler.LogWCFException(ex))
{
return "({ \"returnStatus\" : -1 , \"errorMessage\" : \"" + ex.Message + "\" })";
}
else
{
return "({ \"returnStatus\" : -1, \"errorMessage\" : \"Error while saving cart pricing rule!\" })";
}
}
}