public SingleResponse <RoomQueryModel> GetById(int id) { SingleResponse <RoomQueryModel> response = new SingleResponse <RoomQueryModel>(); SqlConnection connection = new SqlConnection(); connection.ConnectionString = ConnectionHelper.GetConnectionString(); SqlCommand command = new SqlCommand(); command.CommandText = "SELECT R.ID, R.NUMEROQUARTO, R.ISOCUPADO, RT.DESCRICAO, RT.VALORDIARIA, " + "RT.QTDHOSPEDES, RT.ISATIVO FROM ROOMS R INNER JOIN ROOMS_TYPE RT ON " + "R.IDROOM_TYPE = RT.ID WHERE R.ID = @ID"; command.Parameters.AddWithValue("@ID", id); command.Connection = connection; try { connection.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { RoomQueryModel room = new RoomQueryModel(); room.RoomID = (int)reader["ID"]; room.RoomNumber = (string)reader["NUMEROQUARTO"]; room.RoomIsOcuppy = (bool)reader["ISOCUPADO"]; room.TypeRoomDescription = (string)reader["DESCRICAO"]; room.TypeRoomDailyValue = (double)reader["VALORDIARIA"]; room.TypeRoomGuestNumber = (int)reader["QTDHOSPEDES"]; room.TypeRoomIsActive = (bool)reader["ISATIVO"]; response.Message = "Dados selecionados com sucesso."; response.Success = true; response.Data = room; return(response); } response.Message = "Quarto não encontrado."; response.Success = false; return(response); } catch (Exception ex) { response.Success = false; response.Message = "Erro no banco de dados, contate o adm."; response.ExceptionError = ex.Message; response.StackTrace = ex.StackTrace; return(response); } finally { connection.Close(); } }
public QueryResponse <RoomQueryModel> GetAllOccuppyRoomsByNumberRoom(SearchObject search) { QueryResponse <RoomQueryModel> response = new QueryResponse <RoomQueryModel>(); SqlConnection connection = new SqlConnection(); connection.ConnectionString = ConnectionHelper.GetConnectionString(); SqlCommand command = new SqlCommand(); command.CommandText = "SELECT R.ID, R.NUMEROQUARTO, R.ISOCUPADO, RT.DESCRICAO, RT.VALORDIARIA, " + "RT.QTDHOSPEDES, RT.ISATIVO FROM ROOMS R INNER JOIN ROOMS_TYPE RT ON " + "R.IDROOM_TYPE = RT.ID WHERE R.NUMEROQUARTO LIKE NUMEROQUARTO = @NUMEROQUARTO AND R.ISOCUPADO = 1"; command.Parameters.AddWithValue("@NUMEROQUARTO", "%" + search.SearchNumberRoom + "%"); command.Connection = connection; try { connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <RoomQueryModel> rooms = new List <RoomQueryModel>(); while (reader.Read()) { RoomQueryModel room = new RoomQueryModel(); room.RoomID = (int)reader["ID"]; room.RoomNumber = (string)reader["NUMEROQUARTO"]; room.RoomIsOcuppy = (bool)reader["ISOCUPADO"]; room.TypeRoomDescription = (string)reader["DESCRICAO"]; room.TypeRoomDailyValue = (double)reader["VALORDIARIA"]; room.TypeRoomGuestNumber = (int)reader["QTDHOSPEDES"]; room.TypeRoomIsActive = (bool)reader["ISATIVO"]; rooms.Add(room); } response.Success = true; response.Message = "Dados selecionados com sucesso"; response.Data = rooms; return(response); } catch (Exception ex) { response.Success = false; response.Message = "Erro no banco de dados, contate o adm."; response.ExceptionError = ex.Message; response.StackTrace = ex.StackTrace; return(response); } finally { connection.Close(); } }