/// <summary>
/// Run Locations_SelectAll, and return results as a list of LocationsRow.
/// </summary>
/// <returns>A collection of LocationsRow.</returns>
public static List <LocationsContract> SelectAllNow()
{
var driver = new LocationsLogic();
driver.SelectAll();
return(driver.Results);
}
/// <summary>
/// Read all Locations rows from the provided reader into the list structure of LocationsRows
/// </summary>
/// <param name="reader">The result of running a sql command.</param>
/// <returns>A populated LocationsRows or an empty LocationsRows if there are no results.</returns>
public static List <LocationsContract> ReadAllNow(SqlDataReader reader)
{
var driver = new LocationsLogic();
driver.ReadAll(reader);
return(driver.Results);
}
/// <summary>
/// Run Locations_SelectAll, and return results as a list of LocationsRow.
/// </summary>
/// <param name="connection">The SqlConnection to use</param>
/// <param name="transaction">The SqlTransaction to use</param>
/// <returns>A collection of LocationsRow.</returns>
public static List <LocationsContract> SelectAllNow(SqlConnection connection, SqlTransaction transaction)
{
var driver = new LocationsLogic();
driver.SelectAll(connection, transaction);
return(driver.Results);
}
/// <summary>
/// Run Locations_SelectBy_ConfirmedByUserId, and return results as a list of LocationsRow.
/// </summary>
/// <param name="fldConfirmedByUserId">Value for ConfirmedByUserId</param>
/// <returns>A collection of LocationsRow.</returns>
public static List <LocationsContract> SelectBy_ConfirmedByUserIdNow(int fldConfirmedByUserId
)
{
var driver = new LocationsLogic();
driver.SelectBy_ConfirmedByUserId(fldConfirmedByUserId
);
return(driver.Results);
}
/// <summary>
/// Run Locations_SelectBy_ConfirmedByUserId, and return results as a list of LocationsRow.
/// </summary>
/// <param name="fldConfirmedByUserId">Value for ConfirmedByUserId</param>
/// <param name="connection">The SqlConnection to use</param>
/// <param name="transaction">The SqlTransaction to use</param>
/// <returns>A collection of LocationsRow.</returns>
public static List <LocationsContract> SelectBy_ConfirmedByUserIdNow(int fldConfirmedByUserId
, SqlConnection connection, SqlTransaction transaction)
{
var driver = new LocationsLogic();
driver.SelectBy_ConfirmedByUserId(fldConfirmedByUserId
, connection, transaction);
return(driver.Results);
}
/// <summary>
/// Run Locations_Search, and return results as a list of LocationsRow.
/// </summary>
/// <param name="fldLocationName">Value for LocationName</param>
/// <param name="fldSourceUrl">Value for SourceUrl</param>
/// <returns>A collection of LocationsRow.</returns>
public static List <LocationsContract> SearchNow(string fldLocationName
, string fldSourceUrl
)
{
var driver = new LocationsLogic();
driver.Search(fldLocationName
, fldSourceUrl
);
return(driver.Results);
}
/// <summary>
/// Run Locations_Search, and return results as a list of LocationsRow.
/// </summary>
/// <param name="fldLocationName">Value for LocationName</param>
/// <param name="fldSourceUrl">Value for SourceUrl</param>
/// <param name="connection">The SqlConnection to use</param>
/// <param name="transaction">The SqlTransaction to use</param>
/// <returns>A collection of LocationsRow.</returns>
public static List <LocationsContract> SearchNow(string fldLocationName
, string fldSourceUrl
, SqlConnection connection, SqlTransaction transaction)
{
var driver = new LocationsLogic();
driver.Search(fldLocationName
, fldSourceUrl
, connection, transaction);
return(driver.Results);
}
/// <summary>");
/// Advance one, and read values into a Locations
/// </summary>
/// <param name="reader">The result of running a sql command.</param>");
/// <returns>A Locations or null if there are no results.</returns>
public static LocationsContract ReadOneNow(SqlDataReader reader)
{
var driver = new LocationsLogic();
return(driver.ReadOne(reader) ? driver.Results[0] : null);
}
