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 static int SaveCartPricingRule(CartPricingRuleInfo objCartPriceRule, AspxCommonInfo aspxCommonObj, List <int> parentID)
{
SQLHandler sqlH = new SQLHandler();
SqlTransaction tran;
tran = (SqlTransaction)sqlH.GetTransaction();
try
{
int cartPriceRuleID = -1;
cartPriceRuleID = AspxCartPriceRuleProvider.CartPriceRuleAdd(objCartPriceRule.CartPriceRule, tran, aspxCommonObj);
AspxCartPriceRuleProvider.RuleConditionAdd(objCartPriceRule.LstRuleCondition, cartPriceRuleID, parentID, tran, aspxCommonObj);
foreach (CartPriceRuleRole cartPriceRuleRole in objCartPriceRule.LstCartPriceRuleRoles)
{
cartPriceRuleRole.CartPriceRuleID = cartPriceRuleID;
AspxCartPriceRuleProvider.CartPriceRuleRoleAdd(cartPriceRuleRole, tran, aspxCommonObj);
}
//foreach (CartPriceRuleStore cartPriceRuleStore in objCartPriceRule.LstCartPriceRuleStores)
//{
// cartPriceRuleStore.CartPriceRuleID = cartPriceRuleID;
// AspxCartPriceRuleProvider.CartPriceRuleStoreAdd(cartPriceRuleStore, tran, aspxCommonObj);
//}
tran.Commit();
return(cartPriceRuleID);
}
catch (SqlException sqlEX)
{
tran.Rollback();
throw new ArgumentException(sqlEX.Message);
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
}
public static int SaveCartPricingRule(CartPricingRuleInfo objCartPriceRule, AspxCommonInfo aspxCommonObj, List<int> parentID)
{
SQLHandler sqlH = new SQLHandler();
SqlTransaction tran;
tran = (SqlTransaction)sqlH.GetTransaction();
try
{
int cartPriceRuleID = -1;
cartPriceRuleID = AspxCartPriceRuleProvider.CartPriceRuleAdd(objCartPriceRule.CartPriceRule, tran, aspxCommonObj);
AspxCartPriceRuleProvider.RuleConditionAdd(objCartPriceRule.LstRuleCondition, cartPriceRuleID, parentID, tran, aspxCommonObj);
foreach (CartPriceRuleRole cartPriceRuleRole in objCartPriceRule.LstCartPriceRuleRoles)
{
cartPriceRuleRole.CartPriceRuleID = cartPriceRuleID;
AspxCartPriceRuleProvider.CartPriceRuleRoleAdd(cartPriceRuleRole, tran, aspxCommonObj);
}
//foreach (CartPriceRuleStore cartPriceRuleStore in objCartPriceRule.LstCartPriceRuleStores)
//{
// cartPriceRuleStore.CartPriceRuleID = cartPriceRuleID;
// AspxCartPriceRuleProvider.CartPriceRuleStoreAdd(cartPriceRuleStore, tran, aspxCommonObj);
//}
tran.Commit();
return cartPriceRuleID;
}
catch (SqlException sqlEX)
{
tran.Rollback();
throw new ArgumentException(sqlEX.Message);
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
}
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 static CartPricingRuleInfo GetCartPriceRules(Int32 cartPriceRuleID, AspxCommonInfo aspxCommonObj)
{
CartPricingRuleInfo cartPricingRuleInfo = new CartPricingRuleInfo();
DataSet ds = new DataSet();
ds = AspxCartPriceRuleProvider.GetCartPriceRule(cartPriceRuleID, aspxCommonObj);
DataTable dtCartPricingRule = ds.Tables[0];
DataTable dtRuleConditions = ds.Tables[1];
DataTable dtCartPriceRuleRoles = ds.Tables[2];
DataTable dtCartPriceRuleStores = ds.Tables[3];
List<CartPriceRule> lstCartPriceRule;
lstCartPriceRule = DataSourceHelper.FillCollection<CartPriceRule>(dtCartPricingRule);
List<RuleCondition> lstRuleConditions;
lstRuleConditions = DataSourceHelper.FillCollection<RuleCondition>(dtRuleConditions);
List<CartPriceRuleRole> lstCartPriceRuleRole;
lstCartPriceRuleRole = DataSourceHelper.FillCollection<CartPriceRuleRole>(dtCartPriceRuleRoles);
List<CartPriceRuleStore> lstCartPriceRuleStore;
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 =
AspxCartPriceRuleProvider.GetCartPriceProductAttributeConditions(rc.RuleConditionID, aspxCommonObj.PortalID);
objRC.LstProductAttributeRuleConditions[0].LstCartConditionDetails =
AspxCartPriceRuleProvider.GetCartPriceRuleConditionDetails(rc.CartPriceRuleID, rc.RuleConditionID, aspxCommonObj.PortalID, aspxCommonObj.UserName);
lstRC.Add(objRC);
}
else if (rc.RuleConditionType.ToUpper().Trim() == "PS".ToUpper().Trim())
{
objRC.LstProductSublectionRuleConditions =
AspxCartPriceRuleProvider.GetCartPriceSubSelections(rc.RuleConditionID, aspxCommonObj.PortalID);
objRC.LstProductSublectionRuleConditions[0].LstCartConditionDetails =
AspxCartPriceRuleProvider.GetCartPriceRuleConditionDetails(rc.CartPriceRuleID, rc.RuleConditionID, aspxCommonObj.PortalID, aspxCommonObj.UserName);
lstRC.Add(objRC);
}
else if (rc.RuleConditionType.ToUpper().Trim() == "CC".ToUpper().Trim())
{
objRC.LstCartPriceRuleConditions =
AspxCartPriceRuleProvider.GetCartPriceRuleConditions(rc.RuleConditionID, aspxCommonObj.PortalID);
objRC.LstCartPriceRuleConditions[0].LstCartConditionDetails =
AspxCartPriceRuleProvider.GetCartPriceRuleConditionDetails(rc.CartPriceRuleID, rc.RuleConditionID, aspxCommonObj.PortalID, aspxCommonObj.UserName);
lstRC.Add(objRC);
}
}
cartPricingRuleInfo.LstRuleCondition = lstRC;
cartPricingRuleInfo.LstCartPriceRuleRoles = lstCartPriceRuleRole;
cartPricingRuleInfo.LstCartPriceRuleStores = lstCartPriceRuleStore;
return cartPricingRuleInfo;
}
public CartPricingRuleInfo GetCartPriceRules(Int32 cartPriceRuleID, AspxCommonInfo aspxCommonObj)
{
PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider();
CartPricingRuleInfo cartPricingRuleInfo = new CartPricingRuleInfo();
DataSet ds = new DataSet();
ds = priceRuleSqlProvider.GetCartPriceRule(cartPriceRuleID,aspxCommonObj);
DataTable dtCartPricingRule = ds.Tables[0];
DataTable dtRuleConditions = ds.Tables[1];
DataTable dtCartPriceRuleRoles = ds.Tables[2];
DataTable dtCartPriceRuleStores = ds.Tables[3];
List<CartPriceRule> lstCartPriceRule;
lstCartPriceRule = DataSourceHelper.FillCollection<CartPriceRule>(dtCartPricingRule);
List<RuleCondition> lstRuleConditions;
lstRuleConditions = DataSourceHelper.FillCollection<RuleCondition>(dtRuleConditions);
List<CartPriceRuleRole> lstCartPriceRuleRole;
lstCartPriceRuleRole = DataSourceHelper.FillCollection<CartPriceRuleRole>(dtCartPriceRuleRoles);
List<CartPriceRuleStore> lstCartPriceRuleStore;
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, aspxCommonObj.PortalID);
objRC.LstProductAttributeRuleConditions[0].LstCartConditionDetails =
priceRuleSqlProvider.GetCartPriceRuleConditionDetails(rc.CartPriceRuleID,rc.RuleConditionID, aspxCommonObj.PortalID, aspxCommonObj.UserName);
lstRC.Add(objRC);
}
else if (rc.RuleConditionType.ToUpper().Trim() == "PS".ToUpper().Trim())
{
objRC.LstProductSublectionRuleConditions =
priceRuleSqlProvider.GetCartPriceSubSelections(rc.RuleConditionID, aspxCommonObj.PortalID);
objRC.LstProductSublectionRuleConditions[0].LstCartConditionDetails =
priceRuleSqlProvider.GetCartPriceRuleConditionDetails(rc.CartPriceRuleID, rc.RuleConditionID, aspxCommonObj.PortalID, aspxCommonObj.UserName);
lstRC.Add(objRC);
}
else if (rc.RuleConditionType.ToUpper().Trim() == "CC".ToUpper().Trim())
{
objRC.LstCartPriceRuleConditions =
priceRuleSqlProvider.GetCartPriceRuleConditions(rc.RuleConditionID, aspxCommonObj.PortalID);
objRC.LstCartPriceRuleConditions[0].LstCartConditionDetails =
priceRuleSqlProvider.GetCartPriceRuleConditionDetails(rc.CartPriceRuleID, rc.RuleConditionID, aspxCommonObj.PortalID, aspxCommonObj.UserName);
lstRC.Add(objRC);
}
}
cartPricingRuleInfo.LstRuleCondition = lstRC;
cartPricingRuleInfo.LstCartPriceRuleRoles = lstCartPriceRuleRole;
cartPricingRuleInfo.LstCartPriceRuleStores = lstCartPriceRuleStore;
return cartPricingRuleInfo;
}
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 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, 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!\" })";
}
}
}
