private void btnReserve_Click(object sender, EventArgs e)
{
var client = new ClientDTO
{
FirstName = tbxFirstName.Text,
LastName = tbxLastName.Text,
Email = tbxEmail.Text,
Phone = tbxPhone.Text
};
_service.InsertClient(client);
int clientId = _service.GetClientId(client.Email);
int hotelId = _service.GetHotelId(cbxHotel.SelectedValue.ToString());
MessageBox.Show(hotelId.ToString());
string roomName = cbxRoom.SelectedValue.ToString();
bool approved = cbxStatus.Checked;
var room = new RoomDTO
{
ClientId = clientId,
HotelId = hotelId,
Name = roomName,
Approved = approved
};
_service.InsertRoom(room);
lbxClients.DataSource = _service.GetClients();
ResetInfo();
}
public RoomDTO GetRowById(int id)
{
string connectionString = ConfigurationManager.ConnectionStrings["ConnectToSQL"].ConnectionString;
IRoomRepository repository = new RoomRepository(connectionString);
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand(queryGetAllId, connection))
{
command.Parameters.AddWithValue("id", id);
using (SqlDataReader reader = command.ExecuteReader())
{
RoomDTO room = new RoomDTO();
if (reader.Read())
{
room = (new RoomDTO()
{
Id = (int)reader["id"],
Name = (string)reader["Name"],
Price = (int)reader["Price"]
});
return room;
}
else
{
return null;
}
}
}
}
}
public void InsertRoom(RoomDTO roomDTO)
{
var room = new Room
{
ClientId = roomDTO.ClientId,
HotelId = roomDTO.HotelId,
Name = roomDTO.Name,
Approved = roomDTO.Approved
};
string connectionString = ConfigurationManager.ConnectionStrings["HotelServiceDB"].ConnectionString;
IRoomRepository repository = new RoomRepository(connectionString);
repository.Insert(room);
}