public bidWCF GetTopBid(int item_id)
{
using (SqlConnection connection = new SqlConnection(Constants.SQLConnectionString))
{
using (SqlCommand cmd = new SqlCommand("SELECT TOP 1 * from dbo.bids WHERE item_id = @item_id ORDER BY amount DESC", connection))
{
cmd.Parameters.AddWithValue("@item_id", item_id);
connection.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
// Check is the reader has any rows at all before starting to read.
if (reader.HasRows)
{
// Read advances to the next row.
//TODO: chekc fvalues for null
while (reader.Read())
{
bidWCF b = new bidWCF(
reader.GetInt32(reader.GetOrdinal("id")),
reader.GetInt32(reader.GetOrdinal("item_id")),
reader.GetString(reader.GetOrdinal("bidder_id")),
reader.GetFloat(reader.GetOrdinal("amount"))
);
return(b);
}
}
}
}
}
return(null);
}
public bool AddBid(bidWCF bid)
{
bidWCF b = bid;
int affected = 0;
using (SqlConnection connection = new SqlConnection(Constants.SQLConnectionString))
using (SqlCommand cmd = new SqlCommand("INSERT INTO dbo.bids(item_id,bidder_id,amount,date_added) VALUES(@item_id,@bidder_id,@amount,SYSDATETIME())", connection))
{
cmd.Parameters.AddWithValue("@item_id", b.item_id);
cmd.Parameters.AddWithValue("@bidder_id", b.bidder_id);
cmd.Parameters.AddWithValue("@amount", b.amount);
connection.Open();
affected = cmd.ExecuteNonQuery();
}
return(affected > 0 ? true : false);
}
public bool AddBid(bidWCF bid)
{
return(DBACC.AddBid(bid));
}