/// <summary> /// Loads CarMake by the id parameter /// </summary> /// <param name="makeId">Primary Key of CarMake table</param> /// <returns>CarMake entity</returns> public static CarMake Load(int makeId) { SearchCarMake search = new SearchCarMake { MakeId = makeId }; return Search(search).FirstOrDefault(); }
/// <summary> /// Searches for CarMake /// </summary> /// <param name="item" /> /// <returns>An IEnumerable set of CarMake</returns> public static IEnumerable<CarMake> Search(SearchCarMake item) { List<SqlParameter> parameters = new List<SqlParameter> { new SqlParameter("@MakeId", item.MakeId), new SqlParameter("@Name", item.Name), new SqlParameter("@Manufacturer", item.Manufacturer), new SqlParameter("@Deleted", item.Deleted) }; DataSet set = DataManager.ExecuteProcedure(KarzPlusConnectionString, "PKP_GetCarMake", parameters); IEnumerable<DataRow> dataRows = set.GetRowsFromDataSet(); return ConvertToEntityObject(dataRows); }
/// <summary> /// Loads All CarMake /// </summary> /// <param name="makeId"></param> /// <returns>IEnumerable CarMake entity</returns> public static IEnumerable<CarMake> LoadAll() { SearchCarMake search = new SearchCarMake { Deleted = false }; return Search(search); }
/// <summary> /// Searches for CarMake /// </summary> /// <param name="search" /> /// <returns>An IEnumerable set of CarMake</returns> public static IEnumerable<CarMake> Search(SearchCarMake search) { return search == null ? new List <CarMake>() : CarMakeDao.Search(search); }