public bool Update(IRoundDTO dto)
{
try
{
using (MySqlConnection conn = new MySqlConnection(_connection))
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand("Update round SET HasEnded = @HasEnded, RoomId=@RoomId WHERE Id = @Id", conn))
{
cmd.Parameters.AddWithValue("@HasEnded", dto.HasEnded);
cmd.Parameters.AddWithValue("@RoomId", dto.RoomId);
cmd.Parameters.AddWithValue("@Id", dto.Id);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
return(false);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public bool Update(IRoundDTO dto)
{
int index = rounds.FindIndex(i => i.Id == dto.Id);
rounds[index] = dto;
return(true);
}
private Round ExtractRound(IRoundDTO dto)
{
return(new Round(dto.Id, _roundDAL, _wheel)
{
RoomId = dto.RoomId,
HasEnded = dto.HasEnded
});
}
public bool Save(IRoundDTO dto)
{
try
{
using (MySqlConnection conn = new MySqlConnection(_connection))
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand("INSERT INTO round (HasEnded, RoomId) VALUES(@HasEnded, @RoomId)", conn))
{
cmd.Parameters.AddWithValue("@HasEnded", dto.HasEnded);
cmd.Parameters.AddWithValue("@RoomId", dto.RoomId);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
return(false);
}
}
}
catch (MySqlException ex)
{
throw new Exception(ex.Message, ex);
}
}
public bool SaveRound(IRoundDTO dto)
{
rounds.Add(dto);
return(true);
}
