public static int CartPriceRuleAdd(CartPriceRule cartPriceRule, SqlTransaction tran, AspxCommonInfo aspxCommonObj) { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamPUC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@CartPriceRuleName", cartPriceRule.CartPriceRuleName)); parameter.Add(new KeyValuePair <string, object>("@CartPriceRuleDescription", cartPriceRule.CartPriceRuleDescription)); parameter.Add(new KeyValuePair <string, object>("@Apply", cartPriceRule.Apply)); parameter.Add(new KeyValuePair <string, object>("@Value", cartPriceRule.Value)); parameter.Add(new KeyValuePair <string, object>("@ApplytoShippingAmount", cartPriceRule.ApplytoShippingAmount)); parameter.Add(new KeyValuePair <string, object>("@DiscountQuantity", cartPriceRule.DiscountQuantity)); parameter.Add(new KeyValuePair <string, object>("@DiscountStep", cartPriceRule.DiscountStep)); parameter.Add(new KeyValuePair <string, object>("@FreeShipping", cartPriceRule.FreeShipping)); parameter.Add(new KeyValuePair <string, object>("@IsFurtherProcessing", cartPriceRule.IsFurtherProcessing)); parameter.Add(new KeyValuePair <string, object>("@FromDate", cartPriceRule.FromDate)); parameter.Add(new KeyValuePair <string, object>("@ToDate", cartPriceRule.ToDate)); parameter.Add(new KeyValuePair <string, object>("@Priority", cartPriceRule.Priority)); parameter.Add(new KeyValuePair <string, object>("@IsActive", cartPriceRule.IsActive)); try { SQLHandler sqlH = new SQLHandler(); if (cartPriceRule.CartPriceRuleID > 0) { DeleteCartPricingRuleForEdit(tran, cartPriceRule.CartPriceRuleID, aspxCommonObj.PortalID); } int cartPRID = sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "usp_Aspx_CartPriceRuleAdd", parameter, "@CartPriceRuleID"); return(cartPRID); } catch (Exception e) { throw e; } }
public static void CartConditionDetailAdd(List <CartConditionDetail> lstCartConditionDetail, int?ruleConditionID, int cartPriceRuleID, SqlTransaction tran, AspxCommonInfo aspxCommonObj) { try { foreach (CartConditionDetail objCartConditionDetail in lstCartConditionDetail) { if (objCartConditionDetail != null) { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamPUC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@RuleConditionID", ruleConditionID)); parameter.Add(new KeyValuePair <string, object>("@CartPriceRuleID", cartPriceRuleID)); parameter.Add(new KeyValuePair <string, object>("@AttributeID", objCartConditionDetail.AttributeID)); parameter.Add(new KeyValuePair <string, object>("@RuleOperatorID", objCartConditionDetail.RuleOperatorID)); parameter.Add(new KeyValuePair <string, object>("@Value", objCartConditionDetail.Value)); parameter.Add(new KeyValuePair <string, object>("@Priority", objCartConditionDetail.Priority)); parameter.Add(new KeyValuePair <string, object>("@IsActive", true)); SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "[dbo].[usp_Aspx_CartConditionDetailAdd]", parameter); } } } catch (Exception e) { throw e; } }
public static DataSet GetCartPriceRule(Int32 cartPriceRuleID, AspxCommonInfo aspxCommonObj) { SQLHandler sqlHandler = new SQLHandler(); List <KeyValuePair <string, object> > paramList = CommonParmBuilder.GetParamPUC(aspxCommonObj); paramList.Add(new KeyValuePair <string, object>("@CartPriceRuleID", cartPriceRuleID)); DataSet ds = sqlHandler.ExecuteAsDataSet("[dbo].[usp_Aspx_GetCartPricingRule]", paramList); return(ds); }
public static void CartPriceRuleStoreAdd(CartPriceRuleStore cartPriceRuleStore, SqlTransaction tran, AspxCommonInfo aspxCommonObj) { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamPUC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@CartPriceRuleID", cartPriceRuleStore.CartPriceRuleID)); parameter.Add(new KeyValuePair <string, object>("@StoreID", cartPriceRuleStore.StoreID)); parameter.Add(new KeyValuePair <string, object>("@IsActive", true)); try { SQLHandler sqlH = new SQLHandler(); sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "usp_Aspx_CartPriceRuleStoreAdd", parameter); } catch (Exception e) { throw e; } }