/// <summary>
/// Loads Special by the id parameter
/// </summary>
/// <param name="specialId">Primary Key of Special table</param>
/// <returns>Special entity</returns>
public static Special Load(int specialId)
{
SearchSpecial search
= new SearchSpecial
{
SpecialId = specialId
};
return Search(search).FirstOrDefault();
}
/// <summary>
/// Searches for Special
/// </summary>
/// <param name="item" />
/// <returns>An IEnumerable set of Special</returns>
public static IEnumerable<Special> Search(SearchSpecial item)
{
List<SqlParameter> parameters
= new List<SqlParameter>
{
new SqlParameter("@SpecialId", item.SpecialId),
new SqlParameter("@InventoryId", item.InventoryId),
new SqlParameter("@DateStart", item.DateStart),
new SqlParameter("@DateEnd", item.DateEnd),
new SqlParameter("@Price", item.Price)
};
DataSet set = DataManager.ExecuteProcedure(KarzPlusConnectionString, "PKP_GetSpecial", parameters);
IEnumerable<DataRow> dataRows = set.GetRowsFromDataSet();
return ConvertToEntityObject(dataRows);
}
public static IEnumerable<Special> LoadByInventoryId(int inventoryId)
{
SearchSpecial searchSpecial = new SearchSpecial {InventoryId = inventoryId};
return Search(searchSpecial);
}
/// <summary>
/// Loads all specials
/// </summary>
/// <returns></returns>
public static IEnumerable<Special> LoadAll()
{
SearchSpecial searchSpecial = new SearchSpecial();
return Search(searchSpecial);
}
/// <summary>
/// Searches for Special
/// </summary>
/// <param name="search" />
/// <returns>An IEnumerable set of Special</returns>
public static IEnumerable<Special> Search(SearchSpecial search)
{
return search == null ? new List <Special>() : SpecialDao.Search(search);
}