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(); }