private void getListings(string sSort, int iCategory)
{
AuctionItems auctionItems = new AuctionItems();
using (SqlConnection conn = new SqlConnection(Common.ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("spListings", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
if (iCategory.Equals(0))
{
cmd.Parameters.Add(new SqlParameter("@cat_id", DBNull.Value));
}
else
{
cmd.Parameters.Add(new SqlParameter("@cat_id", iCategory));
}
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
AuctionItem item = new AuctionItem();
item.Id = dr["item_id"].ToString();
item.Name = dr["item_name"].ToString();
item.Description = dr["item_description"].ToString();
item.DateOpen = DateTime.Parse(dr["item_date_open"].ToString());
item.DateClose = DateTime.Parse(dr["item_date_close"].ToString());
item.Seller = dr["item_seller"].ToString();
item.Location = dr["item_location"].ToString();
if (dr["item_amount"].ToString().Equals(string.Empty))
{
item.BidAmount = 0;
}
else
{
item.BidAmount = decimal.Parse(dr["item_amount"].ToString());
}
item.Buyer = dr["item_bidder"].ToString();
item.BidNumber = int.Parse(dr["item_bids"].ToString());
//item.Category = dr["cat_name"].ToString();
auctionItems.Add(item);
}
}
}
}
if (auctionItems.Count == 0)
{
AuctionItem item = new AuctionItem();
item.Description = "No items listed.";
auctionItems.Add(item);
//Response.Write("No items listed.");
}
//else
//{
//Sort
if (sSort.Equals("DateClose") ||
sSort.Equals("Name") ||
sSort.Equals("Buyer") ||
sSort.Equals("BidAmount") ||
sSort.Equals("Category"))
{
auctionItems.Sort(sSort, SortOrderEnum.Ascending);
}
else
{
auctionItems.Sort(sSort, SortOrderEnum.Descending);
}
dlListings.DataSource = auctionItems;
dlListings.DataBind();
//}
}
