/// <summary>
/// Calls stored procedure 'usp_AFGenerateAffiliateCommission'.<br/><br/>
///
/// </summary>
/// <param name="eventCustomerId">Input parameter of stored procedure</param>
/// <param name="returnValue">Return value of the stored procedure</param>
/// <param name="adapter">The DataAccessAdapter object to use for the call</param>
/// <returns>Amount of rows affected, if the database / routine doesn't surpress rowcounting.</returns>
public static int GenerateAffiliateCommission(System.Int64 eventCustomerId, ref System.Int32 returnValue, DataAccessAdapter adapter)
{
// create parameters. Add 1 to make room for the return value parameter.
SqlParameter[] parameters = new SqlParameter[1 + 1];
parameters[0] = new SqlParameter("@EventCustomerID", SqlDbType.BigInt, 0, ParameterDirection.Input, true, 19, 0, "", DataRowVersion.Current, eventCustomerId);
parameters[1] = new SqlParameter("RETURNVALUE", SqlDbType.Int, 0, ParameterDirection.ReturnValue, true, 10, 0, "", DataRowVersion.Current, returnValue);
int toReturn = adapter.CallActionStoredProcedure("[Falcon].[dbo].[usp_AFGenerateAffiliateCommission]", parameters);
returnValue = (int)parameters[1].Value;
return(toReturn);
}
/// <summary>
/// Calls stored procedure 'usp_getShippingDetailInfo'.<br/><br/>
///
/// </summary>
/// <param name="rowIndex">Input parameter of stored procedure</param>
/// <param name="pageSize">Input parameter of stored procedure</param>
/// <param name="status">Input parameter of stored procedure</param>
/// <param name="shippingOptionId">Input parameter of stored procedure</param>
/// <param name="eventId">Input parameter of stored procedure</param>
/// <param name="podId">Input parameter of stored procedure</param>
/// <param name="startDate">Input parameter of stored procedure</param>
/// <param name="endDate">Input parameter of stored procedure</param>
/// <param name="isResultReady">Input parameter of stored procedure</param>
/// <param name="adapter">The DataAccessAdapter object to use for the call</param>
/// <returns>Filled DataSet with resultset(s) of stored procedure</returns>
public static DataSet GetShippingDetailInfo(System.Int32 rowIndex, System.Int32 pageSize, System.Int32 status, System.Int32 shippingOptionId, System.Int64 eventId, System.Int32 podId, System.String startDate, System.String endDate, System.Boolean isResultReady, DataAccessAdapter adapter)
{
SqlParameter[] parameters = new SqlParameter[9];
parameters[0] = new SqlParameter("@RowIndex", SqlDbType.Int, 0, ParameterDirection.Input, true, 10, 0, "", DataRowVersion.Current, rowIndex);
parameters[1] = new SqlParameter("@PageSize", SqlDbType.Int, 0, ParameterDirection.Input, true, 10, 0, "", DataRowVersion.Current, pageSize);
parameters[2] = new SqlParameter("@Status", SqlDbType.Int, 0, ParameterDirection.Input, true, 10, 0, "", DataRowVersion.Current, status);
parameters[3] = new SqlParameter("@ShippingOptionID", SqlDbType.Int, 0, ParameterDirection.Input, true, 10, 0, "", DataRowVersion.Current, shippingOptionId);
parameters[4] = new SqlParameter("@EventID", SqlDbType.BigInt, 0, ParameterDirection.Input, true, 19, 0, "", DataRowVersion.Current, eventId);
parameters[5] = new SqlParameter("@PodID", SqlDbType.Int, 0, ParameterDirection.Input, true, 10, 0, "", DataRowVersion.Current, podId);
parameters[6] = new SqlParameter("@StartDate", SqlDbType.VarChar, 30, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, startDate);
parameters[7] = new SqlParameter("@EndDate", SqlDbType.VarChar, 30, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, endDate);
parameters[8] = new SqlParameter("@IsResultReady", SqlDbType.Bit, 0, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, isResultReady);
DataSet toReturn = new DataSet("GetShippingDetailInfo");
bool hasSucceeded = adapter.CallRetrievalStoredProcedure("[Falcon].[dbo].[usp_getShippingDetailInfo]", parameters, toReturn);
return(toReturn);
}
/// <summary>
/// Calls stored procedure 'usp_AFSaveEventAffiliate'.<br/><br/>
///
/// </summary>
/// <param name="eventcustomerid">Input parameter of stored procedure</param>
/// <param name="callid">Input parameter of stored procedure</param>
/// <param name="returnvalue">InputOutput parameter of stored procedure</param>
/// <param name="returnValue">Return value of the stored procedure</param>
/// <param name="adapter">The DataAccessAdapter object to use for the call</param>
/// <returns>Amount of rows affected, if the database / routine doesn't surpress rowcounting.</returns>
public static int SaveEventAffiliate(System.Int64 eventcustomerid, System.Int64 callid, ref System.Int64 returnvalue, ref System.Int32 returnValue, DataAccessAdapter adapter)
{
// create parameters. Add 1 to make room for the return value parameter.
SqlParameter[] parameters = new SqlParameter[3 + 1];
parameters[0] = new SqlParameter("@eventcustomerid", SqlDbType.BigInt, 0, ParameterDirection.Input, true, 19, 0, "", DataRowVersion.Current, eventcustomerid);
parameters[1] = new SqlParameter("@callid", SqlDbType.BigInt, 0, ParameterDirection.Input, true, 19, 0, "", DataRowVersion.Current, callid);
parameters[2] = new SqlParameter("@returnvalue", SqlDbType.BigInt, 0, ParameterDirection.InputOutput, true, 19, 0, "", DataRowVersion.Current, returnvalue);
parameters[3] = new SqlParameter("RETURNVALUE", SqlDbType.Int, 0, ParameterDirection.ReturnValue, true, 10, 0, "", DataRowVersion.Current, returnValue);
int toReturn = adapter.CallActionStoredProcedure("[Falcon].[dbo].[usp_AFSaveEventAffiliate]", parameters);
if (parameters[2].Value != System.DBNull.Value)
{
returnvalue = (System.Int64)parameters[2].Value;
}
returnValue = (int)parameters[3].Value;
return(toReturn);
}
