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 }