Answer Happy

This is a programming project in C#. I have already created the add, delete, update, main and about forms...just need help with writing the code. The last 2 photos below are the start of my code. Thanks for the help!
Assignment Introduction There are multiple project documents for this assignment. This particular document provides you with an overview of the application and where your thinking needs to be aligned for successful completion of this project. The main page of your finished application will appear as follows: Fie Maintenance Abd Movies Master List Putin Geve Tom THO Scom 1941 Orson Wel Dana $1.5041700 000 On Wel 100 Next
Assignment The objectives of this assignment are as follows: Create a fully functioning Windows Forms desktop application. The application's forms will allow a user to interact with the Movies table from a SQL Server database. This application retrieves data from the database while also demonstrating the ability to handle the typical CRUD operations (Create, Read, Update, and Delete). Skills Required To properly complete this assignment, you will need to apply the following skills: Construct Windows desktop GUI application using Windows Forms. This application will use all the following controls: will DataGridView to display all the movies available in the database. In your code-behind, you populate the data grid control with a list of movies using a class object for each movie retrieved from the database. ComboBox to display nine different genre selections to associate with a given movie. RichTextBox to display information on the About form. MenuStrip to provide a menu for the Main form. Work with ADO.NET to access SQL Server database housed in AWS. . Retrieve data from a table. . . Add, Update, and Delete data in the table. . Implement Try/Catch block logic. • Display multiple forms. ● Construct dialogue windows. Created Soft Cha
Construct dialogue windows. Supplementary Information Everything you need to understand accessing a database using ADO.NET can be found in chapter 2 of the book entitled, SQL Server for C# Developers: Succinctly, found in Blackboard. Note: There are no shortcuts; you must read chapter 2 from this book to begin to gain an understanding of what ADO.NET is and how to use it. Other materials specific to the controls that you will be using and how to code these will be provided to you in Blackboard. Assignment User Story As a user, I want a new Windows application written using Windows Forms that is capable of obtaining basic information from a SQL Server database related to movies that are entered into a database by programming students. Further, I want the ability to add, update, and delete existing movies in the database. Previous Next
Assignment Requirements The work you will be doing is all part of a larger project. The application that results from this project, when completed, will be capable of finding a movie by its title and displaying some related information about the movie including the director, the year the movie was released, its genre category, the Rotten Tomatoes score, and the total box office earnings. ADO.NET The technology that we will be using to access our database is called ADO.NET. This is a data access technology that provides communication to and from data systems through a common set of software components. ADO.NET provides a bridge between your application and a back-end database; it is an interface to data. For a fairly complete walk-through of ADO.NET you must read the second chapter in the book SQL Server for C# Developers: Succinctly provided as a PDF in this class. The process of working with ADO.NET involves the following steps: Create a connection string that contains the information needed to successfully connect to the server and specific database. Establish a connection to the database. Form the SQL query string that will be sent to the database. Establish a command that will execute the query. Open the connection. . Execute a SqlDataReader against the open connection that will send the command to the database and return any results to the reader instance. Process the results from the reader. . . Close the connection. The above steps are completely covered by the book as well as with the sample console-based application Created with Soft Chalk
< 3 of 5 > The above steps are completely covered by the book as well as with the sample console-based application provided in Blackboard. The Database and Connection String Our database is hosted in AWS. Of course, where the database is hosted is not consequential; we simply need a connection string to the instance of our database. The following connection string is properly formatted for this assignment: Data Source=coursemaster1.csbchotp6tva.us-east-2.rds.amazonaws.com,1433;Initial Catalog CSC11630;User ID=rw1630; Password=Project!; Ideally, the connection string should be placed in and accessed from the application's App.config file. However, it can just as easily be constructed through string interpolation. Examples of how to construct the connection string will be provided. What is of importance here is knowing that the above string represents exactly what the connection must contain. Important! You must not copy the string from above to your code. You will get additional spaces in the pasted version that will cause your connection to the database to fail. The Movies Table and Class Movies (Read-only) Column Name Allow Nulls ld Within the CSC/1630 database we have a table called Movies. We will access this table to retrieve information about a given movie based on the Title the user provides to the application's interface. The schema of our table is shown to the left. Title Year Director Data Type int varchar(50) int varchar(50) OOOO Created Sot Cha
< 3 of 5 > The Movies Table and Class Movies (Read-only) Column Name ld int Within the CSC/1630 database we have a table called Movies. We will access this table to retrieve information about a given movie based on the Title the user provides to the application's interface. The schema of our table is shown to the left. Title varchar(50) int Year Director varchar(50) Genre int Rotten TomatoesScore int You will need to construct a class in your application called Moviecontaining properties that match each of the columns in the table. TotalEarned decimal(14, 2) Warning: for your application to work properly, the names and data-types of your class's properties must match the names and data-types of the columns shown in our table. The varchar(number) data-type in SQL Server simply maps to a string data-type in C#. The number in the parenthesis, example varchar(50) is the maximum length of the string in the table. This factors into our code in three meaningful ways: first, we can use our knowledge of the length of a given column to properly provide enough length for the fields on the form; second, we need the length of each column when we add parameters to the SQL command passed to the database. For a full discussion of parameters, you must read chapter 2 from the book SQL Server for C# Developers: Succinctly; And, finally, knowing the maximum length of a column should factor into our error handling for the application. For example, we want to prevent the user from entering either a title or director where the length of the string is greater than 50 characters. SQL Commands COL C Data Type Allow Nulls OOOO0CE
< 3 of 5 > length for the fields on the form; second, we need the length of each column when we add parameters to the SQL command passed to the database. For a full discussion of parameters, you must read chapter 2 from the book SQL Server for C# Developers: Succinctly; And, finally, knowing the maximum length of a column should facto into our error handling for the application. For example, we want to prevent the user from entering either a title or director where the length of the string is greater than 50 characters. SQL Commands The SQL commands that you will use throughout the application will be provided to you. Null Values Two of the columns in our table: Rotten TomatoesScore and TotalEarned are marked as allowing null values. This means that any individual row in the table might have no values for these two columns. Your program must protec against this. If you don't specifically code to check for nulls then when the user tries to find a movie where one or both of these values are null your program will end in an execution error. This is shown in the section Querying your database on pages 22 through 24 of the SQL Server for C# Developers: Succinctly book. Previous Next
Technical/Grading Requirements You must ensure that the application you submit meets all technical/grading requirements. Your grade will be based on how well your application follows the application requirements plus the following: A Windows Forms (desktop) application will be developed. Correct data will be read from the database. The application will protect against any potential application execution errors that would end the program. You will have an About form that uses a RichTextBox control. You will have separate Add, Update, and Delete forms that will allow you to perform maintenance work on the titles stored in the Movies Table. As a final note to the above requirements, because this is a Windows desktop application you must submit a zip of the entire project folder for grading purposes. A desktop application contains multiple files beyond just the code file that must be kept together. How the application looks and how it presents its information to the user is up to you. But it must meet the minimum requirements noted above. Final Thoughts This entire exercise is intended to be your first look at interfacing between your application and a database. It also allows us to use the Try/Catch block to ensure we don't allow any database errors to cause the application to end its execution abnormally.
Example Output You do not need to format your output to look like these examples. You simply need to ensure that you have met the technical requirements for this application. Following is example of the main page for this application: Movie Manager Appleton Movies Master List Move The Geve Puten Tonans Sove TO 1541 Dana 100 $1.504.107.00 On Welles Orson Welle 1940 25 The following example shows the Maintenance menu expanded with its three options: Movie Manager Application Maintenance About Create Sot
The following example shows the Maintenance menu expanded with its three options: Movie Manager Application DX File Maintenance About Add Movie Mo Update Movie Delete Movie Rotten Move The Year Drecor Gerve Total Box Office Tomatoes Score Dana 100 $1,554 107.00 1541 1948 Orson Welles Orson Welles Mache Dana 05 10.00 The following example shows the Add Movie Screen: File Maintenance About Movies Master List Paten Year Geve Tonaties Add Movie Chen Kar Add Movie Screen Move Te Total Box Office D
The following example shows the Add Movie Screen: File Maintenance About Movies Master List Roten Movie T Tomatoes Che Karw Total Box Office X Roten Tanatoms Soome Box Office Earrings Add The following example shows the Update Movie Screen with data loaded: Fie Maintenance About Movies Master List Puten Move Te Year Geve Tonatore Total Box Office Update Movie Chen Kare Macbeth Update Movie Screen Movie Te Rhom Kaw Find Year 1541 Orson Wes Add Movie Add Movie Screen Movie The Orecter Gerve OX
< 5 of 5 The following example shows the Update Movie Screen with data loaded: Movie Manager Applicat File Maintenance About Movies Master List Roten Move Tie Year Drectar Gerve Tonaties Total Box Office D Update Movie Screen Fed Tear 1541 Orson Wells Gerve Drama Paten Tomatoes Score 100 Box Office ang 11.504.107.00 The following example shows the Delete Movie Screen with the delete prompt: Fie Maintenance About Movies Delete Movie Screen Total Box Office Chan Kane Find $1.554 107.00 10:00 1541 Orson Welles Dana Gerve X
5 of 5 The following example shows the Delete Movie Screen with the delete prompt: Fie Maintenance About Movies Delete Movie Screen Move Te Chen Kane Find Total Box Office $1,554,107 00 10.00 1541 Drecter Orson Weles Oana Rotten Tomatoes Soome 100 Are you sure you want to Delete move? Delete OK Cancel In this final example, the About form is shown: Mive Manager Application File Maintenance About Movies Master List Poten Move The Gerve Tomates Sope Kar About Movie Manager Application This application reads data from a Microsoft SQL Server database. Further, i provides the typical CRUD operations: Create, Read, Update, and Delete against the Movies table in our database. Delete Confirmation Total Box Office x 1554 107.00 10.00
Any CPU (Design) Project 1 Busing System; 2 using 3 using using System.Data; 09012 4 5 using 6 using System.Linq; 7 using System.Text; 8 99 13 14 15 16 17 18 Start Form3.cs (Design) System.Collections.Generic; System.ComponentModel; System.Drawing; using System.Threading.Tasks; using System.Windows.Forms; Enamespace Final Project a references B public partial class Form1 : Form I { 1 reference B public Form1() ( InitializeComponent(); 1 reference private void mnuExit_Click(object sender, EventArgs e) ( this.Close(); 1 reference private void anuAbout_Click(object sender, EventArgs e) Form2 form = new Form2(); form. ShowDialog(); 1 reference private void mnuAddMovie_Click(object sender, EventArgs e) ( Form3 form = new Form3(); form. ShowDialog(); No issues found 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 List Output B 4 B Form5.cs (Design) ag FinalProject.Form1 Form4.cs (Design) Form1.csx Form2.cs Form10 In: 9 SPC CRLI ↑ Add to Source Ch: 28
P ne 30 31 B 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 E B 1 reference private void mnuAddMovie_Click(object sender, EventArgs e) ( Form3 form = new Form3(); form. ShowDialog(); 1 reference private void anuUpdateMovie_Click(object sender, EventArgs e) Form form = new Form4(); form. ShowDialog(); } 1 reference private void mnuDeleteMovie_Click(object sender, EventArgs e) { Form5 form new Form5(); form. ShowDialog();