programming in .net

SESSION 1 Write a Windows Form App (.NET Framework) that: Uses Windows Forms to make a graphical interface Uses the Graphics object to graphically display a liquid filling a bucket Uses a Timer control to display the bucket contents as it fills Uses a TrackBar control to adjust the flow-rate of the liquid by setting the Interval of the Timer control Uses the ColorDialog control to be able to select which colour the liquid is You may download this sample program ([login to view URL])for a demonstration of program behaviour Here is an example of sample code ([login to view URL]) that shows how to create and use a Graphics object SESSION 2 Doctor Who is a long-running BBC television show that is unique in that the main character of The Doctor is periodically replaced by a different actor. In the show's 50+ years of history, there have been thirteen actors who have played the title role. Over the years, The Doctor has taken on many companions who accompany him on his journeys through time and space. You will need to prepare for this part of the lab, by creating a Doctor Who Database using SQL Express (as per your COMP-CO859 - Database Theory course). Don't worry, you don't need to create the database from scratch. You must create it using this script ([login to view URL]). Just make sure that you have the SQL Server (SQLEXPRESS) service running first. Then open Microsoft SQL Server Management Studio, drag the script file onto it, and click the Execute button. Take some time to examine the database schema. It is composed of three tables: A DOCTOR table that contains records about all of the Doctors (including a picture!) A COMPANION table that refers to records about all of the Companions An EPISODE table that refers to records about all of the Episodes Write a Windows Form App (.NET Framework) that: Makes use of a GUI interface that has an Exit menu option Connects to the database using the standard connection string. Uses three generic List<T> collections to store each of the three record types, using the Doctor, Companion, or Episode classes The left GroupBox contains a ComboBox that is populated when the program loads The left GroupBox contains information pertaining to whichever Doctor has been selected in the ComboBox The right GroupBox contains a ListBox with each of the companions that has traveled with the selected Doctor The Doctor, Companion and Episode classes only need to have properties and a constructor, but you will need to analyze the database to determine which fields each of these classes requires Notice that the Doctor and Companion records only have a StoryID, so you will need to use the appropriate LINQ and SQL statements to be able to match up the appropriate story Title You may NOT alter the provided script in any way You may download this sample program([login to view URL]) for a demonstration of program behaviour SUBMIT 2 different zip files for two sessions