/// <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); }