private static void UpdateDb(Seat seat, string id)
{
using (var connection = new SqlConnection(connectionString))
{
var query = (seat.BookingState == BookingState.Reserved || seat.BookingState == BookingState.Cancelled)
? $"INSERT INTO Ticket ([UniqueNumber], [Row], [Number], [BookingState]) VALUES (\'{id}\', {seat.Row}, {seat.Number}, {(int) seat.BookingState})"
: $"DELETE FROM Ticket WHERE [Row] = {seat.Row} AND [Number] = {seat.Number}";
var command = new SqlCommand(query, connection);
connection.Open();
command.ExecuteScalar();
connection.Close();
}
}
private void btSubmit_Click(object sender, RoutedEventArgs e)
{
var queue = new MessageQueue(_queueName);
var customer = new Customer
{
Name = tbName.Text,
Surname = tbSurname.Text
};
if (!_selectedSeats.Any())
{
MessageBox.Show("reserve the seat");
return;
}
foreach (var selectedSeat in _selectedSeats)
{
var seat = new Seat
{
BookingState = selectedSeat.BookingState,
Data = customer,
Number = selectedSeat.Number,
Row = selectedSeat.Row
};
queue.Send(seat);
}
MessageBox.Show("Wait for approval");
_selectedSeats.Clear();
}
private void UI_InitSeats()
{
for (var i = 0; i < 30; i++)
{
for (var j = 0; j < 40; j++)
{
var uiSeat = DrawSeat(BookingState.Free);
canvas.Children.Add(uiSeat);
Canvas.SetTop(uiSeat, i * 10);
Canvas.SetLeft(uiSeat, j * 10);
_room[i, j] = new Seat
{
ViewModel = uiSeat
};
}
}
}