public static void CartPriceRuleRoleAdd(CartPriceRuleRole cartPriceRuleRole, SqlTransaction tran, AspxCommonInfo aspxCommonObj)
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamPUC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@CartPriceRuleID", cartPriceRuleRole.CartPriceRuleID));
parameter.Add(new KeyValuePair <string, object>("@RoleID", cartPriceRuleRole.RoleID));
parameter.Add(new KeyValuePair <string, object>("@IsActive", true));
SQLHandler sqlH = new SQLHandler();
try
{
sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "[dbo].[usp_Aspx_CartPriceRuleRoleAdd]", parameter);
}
catch (Exception e)
{
throw e;
}
}
public void CartPriceRuleRoleAdd(CartPriceRuleRole cartPriceRuleRole, SqlTransaction tran, Int32 portalID, string userName, string culture)
{
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("@CartPriceRuleID", cartPriceRuleRole.CartPriceRuleID));
parameter.Add(new KeyValuePair <string, object>("@RoleID", cartPriceRuleRole.RoleID));
parameter.Add(new KeyValuePair <string, object>("@IsActive", true));
parameter.Add(new KeyValuePair <string, object>("@PortalID", portalID));
parameter.Add(new KeyValuePair <string, object>("@Username", userName));
parameter.Add(new KeyValuePair <string, object>("@CultureName", culture));
SQLHandler sqlH = new SQLHandler();
try
{
sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "[dbo].[usp_Aspx_CartPriceRuleRoleAdd]", parameter);
}
catch (Exception e)
{
throw e;
}
}
public void CartPriceRuleRoleAdd(CartPriceRuleRole cartPriceRuleRole,SqlTransaction tran, Int32 portalID, string userName, string culture)
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@CartPriceRuleID", cartPriceRuleRole.CartPriceRuleID));
parameter.Add(new KeyValuePair<string, object>("@RoleID", cartPriceRuleRole.RoleID));
parameter.Add(new KeyValuePair<string, object>("@IsActive", true));
parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID));
parameter.Add(new KeyValuePair<string, object>("@Username", userName));
parameter.Add(new KeyValuePair<string, object>("@CultureName", culture));
SQLHandler sqlH =new SQLHandler();
try
{
sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "[dbo].[usp_Aspx_CartPriceRuleRoleAdd]", parameter);
}
catch (Exception e)
{
throw e;
}
}
public static void CartPriceRuleRoleAdd(CartPriceRuleRole cartPriceRuleRole,SqlTransaction tran,AspxCommonInfo aspxCommonObj)
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamPUC(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@CartPriceRuleID", cartPriceRuleRole.CartPriceRuleID));
parameter.Add(new KeyValuePair<string, object>("@RoleID", cartPriceRuleRole.RoleID));
parameter.Add(new KeyValuePair<string, object>("@IsActive", true));
SQLHandler sqlH =new SQLHandler();
try
{
sqlH.ExecuteNonQuery(tran, CommandType.StoredProcedure, "[dbo].[usp_Aspx_CartPriceRuleRoleAdd]", parameter);
}
catch (Exception e)
{
throw e;
}
}