//Dalia's stuff //this method refreshes seats data and makes all seats available public void refreshSeating(int id, BookingData bd) { String connection = @"Provider=Microsoft.JET.OLEDB.4.0; Data Source =" + Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"DB\SystemsDevProjectDB.mdb"); OleDbConnection myConnection = new OleDbConnection(connection); //quert to insert booking data string query = "Insert into Booking Values(" + id + "," + "'" + bd.getcategory() + "'," + bd.getseatnumber() + ",'" + "available" + "')"; OleDbCommand Command = new OleDbCommand(query, myConnection); try { Command.CommandType = CommandType.Text; myConnection.Open(); //adding parameters to query Command.Parameters.AddWithValue("@SeatType", bd.getcategory()); Command.Parameters.AddWithValue("@Number", bd.getseatnumber()); Command.Parameters.AddWithValue("@Availability", "available"); Command.ExecuteNonQuery(); } catch (Exception ex) { //MessageBox.Show(ex.ToString()); System.Diagnostics.Debug.WriteLine("Exception: " + ex); } finally { myConnection.Close(); } }
public List <BookingData> getBookingData() { //create a list of booking data List <BookingData> bookinglist = new List <BookingData>(); OleDbConnection connection = GetOleDbConnection(); //write query to retreive all data string query = "SELECT * from Booking "; OleDbCommand Command = new OleDbCommand(query, connection); try { connection.Open(); OleDbDataReader Reader = Command.ExecuteReader(); //reading each row after query execution while (Reader.Read()) { int id = (int)Reader["ID"]; string SeatType = (string)Reader["SeatType"]; int Number = (int)Reader["Number"]; string Availability = (string)Reader["Availability"]; //creating object from each row and adding into booking list BookingData BD = new BookingData(Number, SeatType, Availability); bookinglist.Add(BD); } } catch (Exception ex) { // MessageBox.Show(ex.ToString()); System.Diagnostics.Debug.WriteLine("Exception: " + ex); } finally { connection.Close(); } return(bookinglist); }