private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
panel1.Invalidate();
MessageBox.Show(comboBox1.Text.Substring(0, 5) + " show selected");
int i = 0;
string a_name = Audi;
String time = comboBox1.SelectedText.Substring(0, 5) + ":00";
seat load = new seat();
load.loadSeats(a_name, time);
int noOfSeat = load.getNoOfSeat();
for (i = 0; i < noOfSeat; i++)
{
char c = seat.seatObject[i].getSeatRow();
int r = ((int)c) - 64;
if (r > 8)
{
r--;
}
int s = seat.seatObject[i].getSeatNumber();
int available = seat.seatObject[i].getAvailable();
seatStatus[s, r] = available;
}
drawPlan();
}
public void loadSeats(String a_name, String time)
{
connect2();
while (i < t - 1)
{
dr = dt.Rows[i];
if (dr["a_name"].ToString() == a_name && dr["time"].ToString() == time)
{
seatObject[noOfSeat] = new seat();
seatObject[noOfSeat].setSeatRow(Convert.ToChar(dr[0]));
seatObject[noOfSeat].setSeatNumber((int)dr[1]);
// seatObject[i].setid((int)dr[3]);
seatObject[noOfSeat].setAvailable((int)dr[2]);
//seatObject[i].setBookingID((int)dr[6]);
noOfSeat++;
}
i++;
}
//AFTER MAKING THE DATABASE
}
