//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);
}
