public void auctionAdd(auction auction)
{
createConnection();
connection.Open();
SqlCommand command = new SqlCommand("auctionAdd", connection);
command.CommandTimeout = 40;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@serviceCode", SqlDbType.Int, 50);
command.Parameters["@serviceCode"].Value = auction.serviceCode;
command.Parameters.Add("@staff", SqlDbType.Int, 50);
command.Parameters["@staff"].Value = auction.staff;
command.Parameters.Add("@bid", SqlDbType.DateTime, 50);
command.Parameters["@bid"].Value = auction.bid;
command.Parameters.Add("@timee", SqlDbType.NVarChar, 50);
command.Parameters["@timee"].Value = auction.timee;
command.ExecuteNonQuery();
connection.Close();
connection.Dispose();
}
public void auctionAdd(auction auction)
{
createConnection();
connection.Open();
SqlCommand command = new SqlCommand("auctionAdd", connection);
command.CommandTimeout = 40;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@serviceCode", SqlDbType.Int, 50);
command.Parameters["@serviceCode"].Value = auction.serviceCode;
command.Parameters.Add("@staff", SqlDbType.Int, 50);
command.Parameters["@staff"].Value = auction.staff;
command.Parameters.Add("@bid", SqlDbType.DateTime, 50);
command.Parameters["@bid"].Value = auction.bid;
command.Parameters.Add("@timee", SqlDbType.NVarChar, 50);
command.Parameters["@timee"].Value = auction.timee;
command.ExecuteNonQuery();
connection.Close();
connection.Dispose();
}
