/// <summary> /// Loads Inventory by the id parameter /// </summary> /// <param name="inventoryId">Primary Key of Inventory table</param> /// <returns>Inventory entity</returns> public static Inventory Load(int inventoryId) { SearchInventory search = new SearchInventory { InventoryId = inventoryId }; return Search(search).FirstOrDefault(); }
public static bool IsValidToRemove(int locationId) { SearchInventory search = new SearchInventory { LocationId = locationId, Deleted = false }; return !Search(search).SafeAny(); }
/// <summary> /// Searches for Inventory /// </summary> /// <param name="item" /> /// <returns>An IEnumerable set of Inventory</returns> public static IEnumerable<Inventory> Search(SearchInventory item) { List<SqlParameter> parameters = new List<SqlParameter> { new SqlParameter("@InventoryId", item.InventoryId), new SqlParameter("@ModelId", item.ModelId), new SqlParameter("@Year", item.Year), new SqlParameter("@Quantity", item.Quantity), new SqlParameter("@LocationId", item.LocationId), new SqlParameter("@Color", item.Color), new SqlParameter("@Price", item.Price), new SqlParameter("@Deleted", item.Deleted) }; DataSet set = DataManager.ExecuteProcedure(KarzPlusConnectionString, "PKP_GetInventory", parameters); IEnumerable<DataRow> dataRows = set.GetRowsFromDataSet(); return ConvertToEntityObject(dataRows); }
/// <summary> /// Loads Inventory by the id parameter /// </summary> /// <param name="inventoryId">Primary Key of Inventory table</param> /// <returns>Inventory entity</returns> public static IEnumerable<Inventory> LoadAllOnInventoryId(int inventoryId) { SearchInventory search = new SearchInventory { InventoryId = inventoryId }; return Search(search); }
/// <summary> /// /// </summary> /// <returns></returns> public static IEnumerable<Inventory> LoadAll() { SearchInventory inventory = new SearchInventory(); return Search(inventory); }
/// <summary> /// Searches for Inventory /// </summary> /// <param name="search" /> /// <returns>An IEnumerable set of Inventory</returns> public static IEnumerable<Inventory> Search(SearchInventory search) { return search == null ? new List<Inventory>() : InventoryDao.Search(search); }
public static IEnumerable<Inventory> LoadOnLocationId(int locationId) { SearchInventory search = new SearchInventory { LocationId = locationId, Deleted=false }; return Search(search); }