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;
}
}
