//End constructor

        //Creates a SHOW for the selected movie.
        public void createShow(int movieID, DateTime date, DateTime startTime, DateTime endTime)
        {
            show = new Show(movieID, date, startTime, endTime); //Instantiate show
            //SQL statement for inserting new data in the table show.
            string DDL = "insert into Show(Movie_ID, Show_Date, Show_StartTime, Show_EndTime) values('" + movieID + "','" + date + "','" + startTime + "','" + endTime + "')";
            OleDbCommand command = new OleDbCommand(DDL, database.getSetCon());
            database.runCommand(command); //Executes the SQL statement.
        }
        //End variables

        //Constructor
        public frmSeatController(MetroForm form)
        {
            this.form = form;

            //Start instantiations
            database = new Database(form);
            show = new Show();
            //End instantiations
        }