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 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 int CartPriceRuleAdd(CartPriceRule cartPriceRule, SqlTransaction tran, Int32 portalID, string userName, string culture)
{
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
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));
parameter.Add(new KeyValuePair <string, object>("@PortalID", portalID));
parameter.Add(new KeyValuePair <string, object>("@Username", userName));
parameter.Add(new KeyValuePair <string, object>("@CultureName", culture));
try
{
SQLHandler sqlH = new SQLHandler();
if (cartPriceRule.CartPriceRuleID > 0)
{
DeleteCartPricingRuleForEdit(tran, cartPriceRule.CartPriceRuleID, portalID);
}
return(sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "usp_Aspx_CartPriceRuleAdd", parameter, "@CartPriceRuleID"));
}
catch (Exception e)
{
throw e;
}
}
public int CartPriceRuleAdd(CartPriceRule cartPriceRule,SqlTransaction tran, Int32 portalID, string userName, string culture)
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
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));
parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID));
parameter.Add(new KeyValuePair<string, object>("@Username", userName));
parameter.Add(new KeyValuePair<string, object>("@CultureName", culture));
try
{
SQLHandler sqlH = new SQLHandler();
if (cartPriceRule.CartPriceRuleID > 0)
DeleteCartPricingRuleForEdit(tran, cartPriceRule.CartPriceRuleID, portalID);
return sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "usp_Aspx_CartPriceRuleAdd", parameter, "@CartPriceRuleID");
}
catch (Exception e)
{
throw e;
}
}
