public static DataSet findAllShowingsOfPlay(int pId)
{
//queryString = "SELECT Date" +
// " From Plays, Showings" +
// " WHERE Plays.Play_Id = Showings.Play_Id" +
// " AND Plays.Play_Id = @pId";
// SQLiteCommand command = new SQLiteCommand(queryString, this.getConnectionString());
// this.getConnectionString().Open();
// command.Parameters.AddWithValue("@pId", pId);
// sqlReader = command.ExecuteReader();
// this.getConnectionString().Close();
// return sqlReader;
DataSet dataSet = new DataSet();
queryString = "SELECT * From Plays, Showings" +
" WHERE Plays.Play_Id = Showings.Play_Id" +
" AND Plays.Play_Id = @pId";
using (SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString()))
{
SQLiteDataAdapter adapter = new SQLiteDataAdapter();
SQLiteCommand command = new SQLiteCommand(queryString, connection);
command.Parameters.AddWithValue("@pId", pId);
adapter.SelectCommand = command;
adapter.Fill(dataSet);
}
return(dataSet);
}
private static DataSet getSeatsLinkedToBooking(int pBookingId)
{
//queryString = "Select Section, Row, Number" +
// " From Bookings, Seats" +
// " Where Bookings.Booking_Id = Seats.Booking_Id" +
// " And Bookings.Booking_Id = @bookingID";
//SQLiteConnection connection = new SQLiteConnection(this.getConnectionString());
//SQLiteCommand command = new SQLiteCommand(queryString, connection);
//connection.Open();
//command.Parameters.AddWithValue("@booking_Id", pBookingId);
//sqlReader = command.ExecuteReader();
//connection.Close();
//return sqlReader;
DataSet dataSet = new DataSet();
queryString = "Select *" +
" From Seats" +
" Where Bookings.Booking_Id = Seats.Booking_Id" +
" And Bookings.Booking_Id = @bookingID";
using (SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString()))
{
SQLiteDataAdapter adapter = new SQLiteDataAdapter();
SQLiteCommand command = new SQLiteCommand(queryString, connection);
command.Parameters.AddWithValue("@booking_Id", pBookingId);
adapter.SelectCommand = command;
adapter.Fill(dataSet);
}
return(dataSet);
}
public static DataSet getPlayDetailsByName(string pPlayName)
{
//queryString = "SELECT * FROM Plays WHERE Name = @playName";
//SQLiteCommand command = new SQLiteCommand(queryString, this.getConnectionString());
//this.getConnectionString().Open();
//command.Parameters.AddWithValue("@playName", pPlayName);
//sqlReader = command.ExecuteReader();
//this.getConnectionString().Close();
//return sqlReader;
DataSet dataSet = new DataSet();
queryString = "SELECT * FROM Plays WHERE Name = @playName";
using (SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString()))
{
SQLiteDataAdapter adapter = new SQLiteDataAdapter();
SQLiteCommand command = new SQLiteCommand(queryString, connection);
command.Parameters.AddWithValue("@playName", pPlayName);
adapter.SelectCommand = command;
adapter.Fill(dataSet);
}
return(dataSet);
}
public static DataSet getShowingByShowingId(int pShowing_Id)
{
//queryString = "Select Name, Length, Date, Price" +
// " FROM Plays, Showings" +
// " WHERE Plays.Play_Id = Showings.Play_Id" +
// " AND Showing_Id = @showingId";
//SQLiteCommand command = new SQLiteCommand(queryString, this.getConnectionString());
//this.getConnectionString().Open();
//command.Parameters.AddWithValue("@showingId", pShowing_Id);
//sqlReader = command.ExecuteReader();
//this.getConnectionString().Close();
//return sqlReader;
DataSet dataSet = new DataSet();
queryString = "Select *" +
" FROM Plays, Showings" +
" WHERE Plays.Play_Id = Showings.Play_Id" +
" AND Showing_Id = @showingId";
using (SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString()))
{
SQLiteDataAdapter adapter = new SQLiteDataAdapter();
SQLiteCommand command = new SQLiteCommand(queryString, connection);
command.Parameters.AddWithValue("@showingId", pShowing_Id);
adapter.SelectCommand = command;
adapter.Fill(dataSet);
}
return(dataSet);
}
public static DataSet getCustomerByLastName(string pLastName)
{
//queryString = "Select * From Customers Where Last_Name = @lastName";
// SQLiteCommand command = new SQLiteCommand(queryString, this.getConnectionString());
// this.getConnectionString().Open();
// command.Parameters.AddWithValue("@lastName", pLastName);
// sqlReader = command.ExecuteReader();
// this.getConnectionString().Close();
// return sqlReader;
DataSet dataSet = new DataSet();
queryString = "Select * From Customers Where Last_Name = @lastName";
using (SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString()))
{
SQLiteDataAdapter adapter = new SQLiteDataAdapter();
SQLiteCommand command = new SQLiteCommand(queryString, connection);
command.Parameters.AddWithValue("@lastName", pLastName);
adapter.SelectCommand = command;
adapter.Fill(dataSet);
}
return(dataSet);
}
public static DataSet getAllSeatsForShowing(int pShowingId)
{
//queryString = "SELECT * FROM Seats" +
// " Where Showing_Id = @showingID";
// SQLiteCommand command = new SQLiteCommand(queryString, this.getConnectionString());
// this.getConnectionString().Open();
// command.Parameters.AddWithValue("@Showing_Id", pShowingId);
// command.ExecuteNonQuery();
// this.getConnectionString().Close();
// return sqlReader;
DataSet dataSet = new DataSet();
queryString = "SELECT * FROM Seats" +
" Where Showing_Id = @showingID";
using (SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString()))
{
SQLiteDataAdapter adapter = new SQLiteDataAdapter();
SQLiteCommand command = new SQLiteCommand(queryString, connection);
command.Parameters.AddWithValue("@Showing_Id", pShowingId);
adapter.SelectCommand = command;
adapter.Fill(dataSet);
}
return(dataSet);
}
public static DataSet seatsSoldUnsold()
{
DataSet dataSet = new DataSet();
queryString = "SELECT * FROM Showings, Plays" +
" Where Plays.Play_Id = Showings.Play_Id";
using (SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString()))
{
SQLiteDataAdapter adapter = new SQLiteDataAdapter();
SQLiteCommand command = new SQLiteCommand(queryString, connection);
adapter.SelectCommand = command;
adapter.Fill(dataSet);
}
dataSet.Tables[0].Columns.Add("SeatsSold", typeof(int));
dataSet.Tables[0].Columns.Add("SeatsUnSold", typeof(int));
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
int showingId = int.Parse(dataSet.Tables[0].Rows[i]["Showing_Id"].ToString());
int numOfSeatsSold = getNumOfSoldSeatsForShowing(showingId);
int numOfUnSeatsSold = getNumOfUnSoldSeatsForShowing(showingId);
dataSet.Tables[0].Rows[i]["SeatsSold"] = numOfSeatsSold;
dataSet.Tables[0].Rows[i]["SeatsUnSold"] = numOfUnSeatsSold;
}
return(dataSet);
}
public static DataSet getAllShowings()
{
//queryString = "SELECT Showing_Id,Name, Length, Date" +
// " FROM Plays, Showings" +
// " WHERE Plays.Play_Id = Showings.Play_Id";
queryString = "SELECT *" +
" FROM Plays, Showings" +
" WHERE Plays.Play_Id = Showings.Play_Id";
//test
return(SqlClassBase.commitSqlQuerryNonParameterized(queryString));
}
public static void deleteSeatsLinkedToShowing(int pShowingId)
{
queryString = "DELETE FROM Seats Where Showing_Id = @showing_Id";
SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString());
SQLiteCommand command = new SQLiteCommand(queryString, connection);
connection.Open();
command.Parameters.AddWithValue("@showing_Id", pShowingId);
command.ExecuteNonQuery();
connection.Close();
}
public static void addPlay(string pName, int pLength)
{
queryString = "INSERT INTO Plays(Name, Length) VALUES(@name, @length)";
SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString());
SQLiteCommand command = new SQLiteCommand(queryString, connection);
connection.Open();
command.Parameters.AddWithValue("@name", pName);
command.Parameters.AddWithValue("@length", pLength);
command.ExecuteNonQuery();
connection.Close();
}
private static void makeDeletePlayRecord()
{
queryString = "INSERT INTO Plays(Name, Length) VALUES(@name, @length)";
SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString());
SQLiteCommand command = new SQLiteCommand(queryString, connection);
connection.Open();
command.Parameters.AddWithValue("@name", "DeletedPlay");
command.Parameters.AddWithValue("@length", 0);
command.ExecuteNonQuery();
connection.Close();
}
public static void deletePlay(int pPlay_Id)
{
changeShowingsOfPlayToDeletedShowing(pPlay_Id);
queryString = "DELETE FROM Plays WHERE Play_Id = @play_Id";
SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString());
SQLiteCommand command = new SQLiteCommand(queryString, connection);
connection.Open();
command.Parameters.AddWithValue("@play_Id", pPlay_Id);
command.ExecuteNonQuery();
connection.Close();
}
private static void setSeatsLinkedToBookingToEmpty(int pBookingId)
{
queryString = "UPDATE Seats SET Booking_Id = 0" +
" Where Booking_Id = @bookingId";
SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString());
SQLiteCommand command = new SQLiteCommand(queryString, connection);
connection.Open();
command.Parameters.AddWithValue("@bookingId", pBookingId);
command.ExecuteNonQuery();
connection.Close();
}
public static void insertTotalPriceForBooking(int pBookingId, float pTotalPrice)
{
queryString = "UPDATE Bookings SET Total_Amount = @totalAmount WHERE Booking_Id = @booking_Id";
SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString());
SQLiteCommand command = new SQLiteCommand(queryString, connection);
connection.Open();
command.Parameters.AddWithValue("@totalAmount", pTotalPrice);
command.Parameters.AddWithValue("@booking_Id", pBookingId);
command.ExecuteNonQuery();
connection.Close();
}
public static void payBooking(int pBookingId)
{
queryString = "UPDATE Bookings SET Paid = @paid WHERE Booking_Id = @booking_Id";
SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString());
SQLiteCommand command = new SQLiteCommand(queryString, connection);
connection.Open();
command.Parameters.AddWithValue("@paid", 1);
command.Parameters.AddWithValue("@booking_Id", pBookingId);
command.ExecuteNonQuery();
connection.Close();
}
private static void generateUpperCircleSeats(int pShowing_Id)
{
SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString());
using (connection)
{
connection.Open();
using (SQLiteTransaction transaction = connection.BeginTransaction())
{
string seatSection = "UpperCircle";
for (int i = 0; i < UpperCircleDictonary.Count(); i++)
{
for (int seatNumber = 1; seatNumber < UpperCircleDictonary.Values.ElementAt(i) + 1; seatNumber++)
{
string seatRow = UpperCircleDictonary.Keys.ElementAt(i);
queryString = "INSERT INTO Seats(Section, Row, Number, Showing_Id, Booking_Id) VALUES(@section, @row, @number, @showing_Id, @booking_Id)";
SQLiteCommand command = new SQLiteCommand(queryString, connection);
command.Parameters.AddWithValue("@section", seatSection);
command.Parameters.AddWithValue("@row", seatRow);
command.Parameters.AddWithValue("@number", seatNumber);
command.Parameters.AddWithValue("@showing_Id", pShowing_Id);
command.Parameters.AddWithValue("@booking_Id", 0);
command.ExecuteNonQuery();
}
}
transaction.Commit();
}
connection.Close();
}
//string seatSection = "UpperCircle";
//for (int i = 0; i < UpperCircleDictonary.Count(); i++)
//{
// for (int seatNumber = 1; seatNumber < UpperCircleDictonary.Values.ElementAt(i) + 1; seatNumber++)
// {
// string seatRow = UpperCircleDictonary.Keys.ElementAt(i);
// queryString = "INSERT INTO Seats(Section, Row, Number, Showing_Id, Booking_Id) VALUES(@section, @row, @number, @showing_Id, @booking_Id)";
// SQLiteConnection connection = new SQLiteConnection(this.getConnectionString());
// SQLiteCommand command = new SQLiteCommand(queryString, connection);
// connection.Open();
// command.Parameters.AddWithValue("@section", seatSection);
// command.Parameters.AddWithValue("@row", seatRow);
// command.Parameters.AddWithValue("@number", seatNumber);
// command.Parameters.AddWithValue("@showing_Id", pShowing_Id);
// command.Parameters.AddWithValue("@booking_Id", null);
// command.ExecuteNonQuery();
// connection.Close();
// }
//}
}
public static float getTotalPriceOfBooking(int pBookingId)
{
DataSet dataSet = new DataSet();
string query = "Select UpperCirclePrice, DressCirclePrice, StallsPrice From Showings, Seats, Bookings" +
" Where Seats.Showing_Id = Showings.Showing_Id" +
" And Seats.Booking_Id = Bookings.Booking_Id" +
" And Bookings.Booking_Id = @bookingId";
using (SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString()))
{
SQLiteDataAdapter adapter = new SQLiteDataAdapter();
SQLiteCommand command = new SQLiteCommand(query, connection);
command.Parameters.AddWithValue("@bookingId", pBookingId);
adapter.SelectCommand = command;
adapter.Fill(dataSet);
}
float UpperCirclePrice = float.Parse(dataSet.Tables[0].Rows[0]["UpperCirclePrice"].ToString());
float DreesCirclePrice = float.Parse(dataSet.Tables[0].Rows[0]["DressCirclePrice"].ToString());
float StallsPrice = float.Parse(dataSet.Tables[0].Rows[0]["StallsPrice"].ToString());
dataSet = new DataSet();
query = "Select * From Seats Where Booking_Id = @bookingId";
using (SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString()))
{
SQLiteDataAdapter adapter = new SQLiteDataAdapter();
SQLiteCommand command = new SQLiteCommand(query, connection);
command.Parameters.AddWithValue("@bookingId", pBookingId);
adapter.SelectCommand = command;
adapter.Fill(dataSet);
}
float totalPrice = 0;
foreach (DataRow row in dataSet.Tables[0].Rows)
{
if (row["Section"].ToString() == "Stall")
{
totalPrice = totalPrice + StallsPrice;
}
else if (row["Section"].ToString() == "DressCircle")
{
totalPrice = totalPrice + DreesCirclePrice;
}
else
{
totalPrice = totalPrice + UpperCirclePrice;
}
}
return(totalPrice);
}
private static int getIdOfDeleteCustomerRecord()
{
// queryString = "Select Customer_Id From Customers Where Last_Name = @deletedPlayName";
// SQLiteConnection connection = new SQLiteConnection(this.getConnectionString());
// SQLiteCommand command = new SQLiteCommand(queryString, connection);
// connection.Open();
// command.Parameters.AddWithValue("@deletedPlayName", "DeletedCustomerLastName");
// sqlReader = command.ExecuteReader();
//int deletedCustomerRecordId = 0;
// try
// {
// while (sqlReader.Read())
// {
// deletedCustomerRecordId = int.Parse(sqlReader["Customer_Id"].ToString());
// connection.Close();
// }
// }
// catch (Exception)
// {
// makeDeletePlayRecord();
// deletedCustomerRecordId = getIdOfDeleteCustomerRecord();
// }
// connection.Close();
// return deletedCustomerRecordId;
DataSet dataSet = new DataSet();
queryString = "Select Customer_Id From Customers Where Last_Name = @deletedPlayName";
using (SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString()))
{
SQLiteDataAdapter adapter = new SQLiteDataAdapter();
SQLiteCommand command = new SQLiteCommand(queryString, connection);
command.Parameters.AddWithValue("@deletedPlayName", "DeletedCustomerLastName");
adapter.SelectCommand = command;
adapter.Fill(dataSet);
}
int deletedCustomerId;
if (dataSet.Tables[0].Rows.Count == 0)
{
makeDeleteCustomerRecord();
deletedCustomerId = getIdOfDeleteCustomerRecord();
}
else
{
deletedCustomerId = int.Parse(dataSet.Tables[0].Rows[0]["Customer_Id"].ToString());
}
return(deletedCustomerId);
}
public static void deleteBooking(int pBookingId)
{
setSeatsLinkedToBookingToEmpty(pBookingId);
queryString = "Delete From Bookings" +
" Where Booking_Id = @bookingId";
SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString());
SQLiteCommand command = new SQLiteCommand(queryString, connection);
connection.Open();
command.Parameters.AddWithValue("@bookingId", pBookingId);
command.ExecuteNonQuery();
connection.Close();
}
public static void editPlay(int pPlay_Id, string pName, int pLength)
{
queryString = "UPDATE Plays SET Name = @name, Length = @length WHERE Play_Id = @play_Id";
SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString());
SQLiteCommand command = new SQLiteCommand(queryString, connection);
connection.Open();
command.Parameters.AddWithValue("@play_Id", pPlay_Id);
command.Parameters.AddWithValue("@name", pName);
command.Parameters.AddWithValue("@length", pLength);
command.ExecuteNonQuery();
connection.Close();
}
private static void makeDeleteCustomerRecord()
{
queryString = "INSERT INTO Customers(First_Name, Last_Name, Email, Membership_Expiry_Date) VALUES(@firstName, @lastName, @email, @membershipExpiryDate)";
SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString());
SQLiteCommand command = new SQLiteCommand(queryString, connection);
connection.Open();
command.Parameters.AddWithValue("@firstName", "DeletedCustomerFirstName");
command.Parameters.AddWithValue("@lastName", "DeletedCustomerLastName");
command.Parameters.AddWithValue("@email", "DeletedCustomerEmail");
command.Parameters.AddWithValue("@membershipExpiryDate", null);
command.ExecuteNonQuery();
connection.Close();
}
public static void upgradeCustomer(int pCustomerId)
{
string memberShipExpiryDate = ShowingsClass.formatDateTimeToSqlLiteDateString(DateTime.Now.AddMonths(12));
queryString = "UPDATE Customers SET Membership_Expiry_Date = @membershipExpiryDate" +
" WHERE Customer_Id = @customerId";
SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString());
SQLiteCommand command = new SQLiteCommand(queryString, connection);
connection.Open();
command.Parameters.AddWithValue("@membershipExpiryDate", memberShipExpiryDate);
command.Parameters.AddWithValue("@customerId", pCustomerId);
command.ExecuteNonQuery();
connection.Close();
}
public static DataSet getCustomerById(int pId)
{
DataSet dataSet = new DataSet();
queryString = "Select * From Customers Where Customer_Id = @customerId";
using (SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString()))
{
SQLiteDataAdapter adapter = new SQLiteDataAdapter();
SQLiteCommand command = new SQLiteCommand(queryString, connection);
command.Parameters.AddWithValue("@customerId", pId);
adapter.SelectCommand = command;
adapter.Fill(dataSet);
}
return(dataSet);
}
private static void setAllBookingsToDeletedCustomer(int pCustomerId)
{
int deletedCustomerId = getIdOfDeleteCustomerRecord();
queryString = "UPDATE Bookings Set Customer_Id = @deletedCustomerRecordId" +
" Where Customer_Id = @customerId";
SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString());
SQLiteCommand command = new SQLiteCommand(queryString, connection);
connection.Open();
command.Parameters.AddWithValue("@customerId", pCustomerId);
command.Parameters.AddWithValue("@deletedCustomerRecordId", deletedCustomerId);
command.ExecuteNonQuery();
connection.Close();
}
public static DataSet getAllShowingOnDate(string pDate)
{
DataSet dataSet = new DataSet();
string queryString = "Select * From Showings Where Date BETWEEN @startDate AND @endDate";
using (SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString()))
{
SQLiteDataAdapter adapter = new SQLiteDataAdapter();
SQLiteCommand command = new SQLiteCommand(queryString, connection);
command.Parameters.AddWithValue("@startDate", pDate + " 00:00");
command.Parameters.AddWithValue("@endDate", pDate + " 24:00");
adapter.SelectCommand = command;
adapter.Fill(dataSet);
}
return(dataSet);
}
public static DataSet getAllSeatsForBooking(int pBookingId)
{
DataSet dataSet = new DataSet();
queryString = "SELECT * FROM Seats" +
" Where Booking_Id = @booking_Id";
using (SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString()))
{
SQLiteDataAdapter adapter = new SQLiteDataAdapter();
SQLiteCommand command = new SQLiteCommand(queryString, connection);
command.Parameters.AddWithValue("@booking_Id", pBookingId);
adapter.SelectCommand = command;
adapter.Fill(dataSet);
}
return(dataSet);
}
public static DataSet getAllBookingsBetweenDates(string pStartDate, string pEndDate)
{
DataSet dataSet = new DataSet();
string query = "Select * From Bookings Where Date_Of_Booking BETWEEN @startDate AND @endDate";
using (SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString()))
{
SQLiteDataAdapter adapter = new SQLiteDataAdapter();
SQLiteCommand command = new SQLiteCommand(query, connection);
command.Parameters.AddWithValue("@startDate", pStartDate + " 00:00");
command.Parameters.AddWithValue("@endDate", pEndDate + "24:00");
adapter.SelectCommand = command;
adapter.Fill(dataSet);
}
return(dataSet);
}
public static void editCustomerDetails(int pCustomerId, string pFirstName, string pLastName, string pEmail, string pMembershipExpiryDate)
{
queryString = "UPDATE Customers SET First_name = @firstName, Last_Name = @lastName, Email = @email, Membership_Expiry_Date = @membershipExpiryDate" +
" WHERE Customer_Id = @customerId";
SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString());
SQLiteCommand command = new SQLiteCommand(queryString, connection);
connection.Open();
command.Parameters.AddWithValue("@firstName", pFirstName);
command.Parameters.AddWithValue("@lastName", pLastName);
command.Parameters.AddWithValue("@email", pEmail);
command.Parameters.AddWithValue("@membershipExpiryDate", pMembershipExpiryDate);
command.Parameters.AddWithValue("@customerId", pCustomerId);
command.ExecuteNonQuery();
connection.Close();
}
public static DataSet getAllBookingsForCustomer(int pCustomerId)
{
DataSet dataSet = new DataSet();
queryString = "SELECT * FROM Bookings, Seats" +
" WHERE Customer_Id = @customer_Id";
using (SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString()))
{
SQLiteDataAdapter adapter = new SQLiteDataAdapter();
SQLiteCommand command = new SQLiteCommand(queryString, connection);
command.Parameters.AddWithValue("@customer_Id", pCustomerId);
adapter.SelectCommand = command;
adapter.Fill(dataSet);
}
return(dataSet);
}
public static void addShowing(int pPlay_Id, string pDate, double pUpperCirclepricePrice, double pDressCirclePrice, double pStallsPrice)
{
queryString = "INSERT INTO Showings(Play_Id, Date, UpperCirclePrice, DressCirclePrice, StallsPrice) VALUES(@play_Id, @date, @upperCirclePrice, @dressCirclePrice, @stallsPrice)";
SQLiteConnection connection = new SQLiteConnection(SqlClassBase.getConnectionString());
SQLiteCommand command = new SQLiteCommand(queryString, connection);
connection.Open();
command.Parameters.AddWithValue("@play_Id", pPlay_Id);
command.Parameters.AddWithValue("@date", pDate);
command.Parameters.AddWithValue("@upperCirclePrice", pUpperCirclepricePrice);
command.Parameters.AddWithValue("@dressCirclePrice", pDressCirclePrice);
command.Parameters.AddWithValue("@stallsPrice", pStallsPrice);
command.ExecuteNonQuery();
connection.Close();
SeatsClass.generateSeats(getLastShowingId());
}