public PubItems GetPubItem(int ItemID) //get pub items - just the item name
{
var results = GetPubItemsResults.FromSqlRaw("EXEC Get_PubItem @ItemID",
new SqlParameter("@ItemID", ItemID)).ToList();
if (results.Count() > 0)
{
return(ConvertItemResultsToPubItems(results.First()));
}
else
{
return(null);
}
}
public PubItems GetRandomPubItem(ItemTypes Type, bool ItemOnSale) //get pub items - just the item name
{
var results = GetPubItemsResults.FromSqlRaw("EXEC Get_RandomPubItem @ItemOnSale,@ItemType",
new SqlParameter("@ItemOnSale", ItemOnSale),
new SqlParameter("@ItemType", Type.ToString())).ToList();
if (results.Count() > 0)
{
return(ConvertItemResultsToPubItems(results.First()));
}
else
{
return(null); //no results returned - user ID dosen't exist in DB so give nothing.
}
}
public PubItemsViewModel GetPubItems(string ItemName, Boolean ItemOnSale, int PageNumber) //get pub items - if on sale and name
{
SqlParameter @outputParam = new SqlParameter {
ParameterName = "@outputParam", SqlDbType = SqlDbType.Int, Direction = ParameterDirection.Output
};
var results = GetPubItemsResults.FromSqlRaw("EXEC @outputParam=Get_PubItems @ItemName, @ItemOnSale, @PageNumber, @ItemsPerPage",
outputParam,
new SqlParameter("@ItemName", (object)ItemName ?? DBNull.Value),
new SqlParameter("@PageNumber", PageNumber),
new SqlParameter("@ItemsPerPage", GlobalConstants.ItemsPerPage),
new SqlParameter("@ItemOnSale", ItemOnSale)).ToList();
return(new PubItemsViewModel {
PubItemsList = ConvertPubItemResultsToPubItems(results), RowCount = (int)@outputParam.Value
});
}
public PubItemsViewModel GetPubItems(string ItemName, bool ItemOnSale, int PageNumber, ItemTypes TypeOfItem) //get pub items - item type, if on sale and name
{
SqlParameter @outputParam = new SqlParameter {
ParameterName = "@outputParam", SqlDbType = SqlDbType.Int, Direction = ParameterDirection.Output
};
var results = GetPubItemsResults.FromSqlRaw("EXEC @outputParam=Get_PubItems @ItemName, @ItemOnSale, @PageNumber, @ItemsPerPage, @ItemType", //fetch pub items, output param returns the total number of results from the query
outputParam,
new SqlParameter("@ItemName", (object)ItemName ?? DBNull.Value),
new SqlParameter("@PageNumber", PageNumber),
new SqlParameter("@ItemsPerPage", GlobalConstants.ItemsPerPage),
new SqlParameter("@ItemOnSale", ItemOnSale),
new SqlParameter("@ItemType", TypeOfItem.ToString())).ToList();
return(new PubItemsViewModel {
PubItemsList = ConvertPubItemResultsToPubItems(results), RowCount = (int)@outputParam.Value
});
}
