public bool SavePocket(IPocketDTO dto)
{
try
{
using (MySqlConnection conn = new MySqlConnection(_connection))
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand("INSERT INTO result (Id, RoundId, Number, Color) VALUES(@Id, @RoundId, @Number, @Color)", conn))
{
cmd.Parameters.AddWithValue("@Id", dto.Id);
cmd.Parameters.AddWithValue("@RoomId", dto.RoundId);
cmd.Parameters.AddWithValue("@Number", dto.ToNumber);
cmd.Parameters.AddWithValue("@Color", dto.ToColorNumber);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
return(false);
}
}
}
catch (MySqlException ex)
{
throw new Exception(ex.Message, ex);
}
}
private IPocket ExtractPocket(IPocketDTO dto)
{
if (dto != null)
{
return(new Pocket((IPocketNumber)dto.ToNumber));
}
return(null);
}
public bool SavePocket(IPocketDTO dto)
{
pockets.Add(dto);
return(true);
}
public bool SavePocket(IPocketDTO dto)
{
throw new NotImplementedException();
}
