/// <summary>Calls stored procedure 'DeleteSegmentCustomers'.<br/><br/></summary>
/// <param name="channelId">Input parameter of stored procedure. </param>
/// <param name="transactionToUse">the transaction to use, or null if no transaction is available.</param>
/// <returns>Number of rows affected, if the database / routine doesn't surpress rowcounting.</returns>
public static int DeleteSegmentCustomers(System.Int32 channelId, ITransaction transactionToUse)
{
using (StoredProcedureCall call = CreateDeleteSegmentCustomersCall(new DataAccessCoreImpl(new CommonDaoBase(), transactionToUse), channelId))
{
int toReturn = call.Call();
return(toReturn);
}
}
/// <summary>Calls stored procedure 'pr_CustomersAndOrdersOnCountry'.<br/><br/></summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="country">Input parameter. </param>
/// <returns>Number of rows affected, if the database / routine doesn't suppress rowcounting.</returns>
public static int CustomersAndOrdersOnCountry(System.String country, IDataAccessCore dataAccessProvider)
{
using (StoredProcedureCall call = CreateCustomersAndOrdersOnCountryCall(dataAccessProvider, country))
{
int toReturn = call.Call();
return(toReturn);
}
}
/// <summary>Calls stored procedure 'GetSegmentCustomers'.<br/><br/></summary>
/// <param name="channelId">Input parameter of stored procedure. </param>
/// <param name="totalCustomers">InputOutput parameter of stored procedure. </param>
/// <param name="transactionToUse">the transaction to use, or null if no transaction is available.</param>
/// <returns>Number of rows affected, if the database / routine doesn't surpress rowcounting.</returns>
public static int GetSegmentCustomers(System.Int32 channelId, ref System.Int32 totalCustomers, ITransaction transactionToUse)
{
using (StoredProcedureCall call = CreateGetSegmentCustomersCall(new DataAccessCoreImpl(new CommonDaoBase(), transactionToUse), channelId, totalCustomers))
{
int toReturn = call.Call();
totalCustomers = call.GetParameterValue <System.Int32>(1);
return(toReturn);
}
}