public async Task <bool> AddAsync(BO.ActiveAuctions obj)
{
try
{
await using (SqlConnection connection = await _context.GetConnection())
{
await using (SqlCommand command = new SqlCommand("ActiveAuctionsAdd", connection)
{
CommandType = CommandType.StoredProcedure
})
{
command.Parameters.AddWithValue("@AuctionId", obj.AuctionId);
command.Parameters.AddWithValue("@Open", obj.Open);
command.Parameters.AddWithValue("@OpenedBy", obj.OpenedBy);
command.Parameters.AddWithValue("@ClosedBy", obj.ClosedBy);
return(await command.ExecuteNonQueryAsync() != -1);
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}
public async Task <List <BO.ActiveAuctions> > ConvertToObj(SqlDataReader reader)
{
List <BO.ActiveAuctions> objects = new List <BO.ActiveAuctions>();
while (await reader.ReadAsync())
{
BO.ActiveAuctions obj = new BO.ActiveAuctions
{
AuctionId = int.Parse(reader["AuctionId"].ToString()),
Open = bool.Parse(reader["Open"].ToString()),
OpenedBy = int.Parse(reader["OpenedBy"].ToString()),
ClosedBy = int.Parse(reader["ClosedBy"].ToString())
};
objects.Add(obj);
}
return(objects);
}
public async Task <bool> UpdateAsync(BO.ActiveAuctions obj)
{
return(await _dalActiveAuctions.UpdateAsync(obj));
}
public async Task <bool> AddAsync(BO.ActiveAuctions obj)
{
return(await _dalActiveAuctions.AddAsync(obj));
}
