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