/// <summary>
/// Loads Location by the id parameter
/// </summary>
/// <param name="locationId">Primary Key of Location table</param>
/// <returns>Location entity</returns>
public static Location Load(int locationId)
{
SearchLocation search
= new SearchLocation
{
LocationId = locationId
};
return Search(search).FirstOrDefault();
}
/// <summary>
/// Searches for Location
/// </summary>
/// <param name="item" />
/// <returns>An IEnumerable set of Location</returns>
public static IEnumerable<Location> Search(SearchLocation item)
{
List<SqlParameter> parameters
= new List<SqlParameter>
{
new SqlParameter("@LocationId", item.LocationId),
new SqlParameter("@Name", item.Name),
new SqlParameter("@Address", item.Address),
new SqlParameter("@City", item.City),
new SqlParameter("@State", item.State),
new SqlParameter("@Zip", item.Zip),
new SqlParameter("@Phone", item.Phone),
new SqlParameter("@Email", item.Email),
new SqlParameter("@Deleted", item.Deleted)
};
DataSet set = DataManager.ExecuteProcedure(KarzPlusConnectionString, "PKP_GetLocation", parameters);
IEnumerable<DataRow> dataRows = set.GetRowsFromDataSet();
return ConvertToEntityObject(dataRows);
}
/// <summary>
/// Searches for Location
/// </summary>
/// <param name="search" />
/// <returns>An IEnumerable set of Location</returns>
public static IEnumerable<Location> Search(SearchLocation search)
{
return search == null ? new List <Location>() : LocationDao.Search(search);
}
