CSIS 208 Programming Assignment 6

Description

Go and Tell Missions
You have been asked to provide a program to the Go and Tell Missions Company, which will store a list of their current missionaries. The information they have is stored in a text file. Each record of the file contains the last name, first name, state the missionary resides, the age of the missionary, the years of service, and the preference for the mission field. When the application opens, the program should display all of this data in a datagridview control. The user should have the option of sorting the data in ascending order or descending order by the last name. The menu item File contains the second-level menu item Exit, which exits the application. The menu item Sort contains the two second-level menu items Ascending and Descending. The menu item Filter contains the four second-level menu items All, Europe, Middle East, South America, and North America. The menu item Search provides the user the ability to input a last name to retrieve the full record of the user selected.
[Note: You should make the first column containing the book title large enough to display the entire title of each book. To do this, set the AutoSizeColumnsMode property to “All Cells”.]
Requirements:
The text file, easterndiv_missions.txt is included in your Instructions folder and should be stored in your project’s bindebug folder.
****This step must be included for your assignment to be accepted. You must include three other rows in the file that include your name, your instructor’s name, and another name with the appropriate data
Read the values of the text file into an array called missionsarray.
Use LINQ queries to separate the lines of the text file into their own fields called Last, First, State, Age, Years of Service, Location and display these values in a datagridview control. You will find it useful to set the datasource property of the datagridview control to the results of your LINQ query.
When the user clicks on the Sort menu, use LINQ queries to sort the array in ascending or descending order by Title and re-display your results in the same datagridview control. Make sure that only one option under the Sort menu appears checked at any given time.
When the user clicks on the Filter menu, use LINQ queries to filter the array by Europe, Middle East, South America, North America, or All. Make sure that only one option under the Filter menu appears checked at any given time.
When the user clicks on the Search menu, the user is prompted with an input box. The program will prompt the user for a last name. The program will utilize a try catch statement to check if the user entered a value in the input.
Preserve the selections from the Sort and Filter menus in your results. That is, if the user has selected to Filter the list to Middle East and then clicks Sort | Descending, the datagridview control should display the list of missionaries where the preference is the Middle East, sorted in descending order.
The form should open with the Sort | Ascending and Filter | All options set. The datagridview control should display these results as well.
Ensure that the full title can be seen for every row.
Include shortcuts and access keys for each menu item (such as Ctrl-X for Exit, Ctrl-A for Ascending, etc.)
As in all of your assignments, make sure that you have used appropriate programming techniques (i.e. naming of controls and variables, form has a title, internal documentation/comments are clear, formatting of any currency fields, etc.)
SCREENSHOTS
SOLUTION
PAYMENT
The solution includes a Visual Studio (VB) project
Attachments [Move over files to preview content of those files]
CSIS_208_Programming_Assignment_6.zip (334.00 KB)
CSIS208-Programming-Assignment-6-Filter-Screenshot.png
CSIS208-Programming-Assignment-6-Search-Screenshot.png
CSIS208-Programming-Assignment-6-Sort-Screenshot.png
Visual Studio project
Go And Tell Missions
Go And Tell Missions
App.config
bin
Debug
easterndiv_missions.txt
Go And Tell Missions.vshost.exe
Go And Tell Missions.vshost.exe.config
Go And Tell Missions.vshost.exe.manifest
Release
Form1.vb
FormMissionaries.Designer.vb
FormMissionaries.vb
Go And Tell Missions.vbproj
My Project
Application.Designer.vb
Application.myapp
AssemblyInfo.vb
Resources.Designer.vb
Settings.Designer.vb
Settings.settings
obj
Debug
DesignTimeResolveAssemblyReferences.cache
DesignTimeResolveAssemblyReferencesInput.cache
Go And Tell Missions.vbproj.FileListAbsolute.txt
TempPE
My Project.Resources.Designer.vb.dll
Go And Tell Missions.sln
Go And Tell Missions.v11.suo
Go And Tell Missions.v12.suo
Preview Form1.vb
xxxxxxxxxxxxxx.xxxxxxx.xxx(“xxx”, xxxx.xxxxxxx(“xxxxxx.xxx32”))
xxxxxxxxxxxxxx.xxxxxxx.xxx(“xxxxxxxxxxxxx”, xxxx.xxxxxxx(“xxxxxx.xxx32”))
xxxxxxxxxxxxxx.xxxxxxx.xxx(“xxxxxxxx”, xxxx.xxxxxxx(“xxxxxx.xxxxxx”))
‘ xxxxx xxxx xxxx xxxxx
Dim missionsarray() As String = File.ReadAllLines(“easterndiv_missions.txt”)
‘ Using Linq populate the datatable with the data in text file missionsarray.ToList().ForEach(Sub(x) dtMissionaries.Rows.Add(x.Split(New Char() {“,”c}).ToArray))
‘ Sort in Ascending by Default dtMissionaries = dtMissionaries.AsEnumerable().OrderBy(Function(row) row.Field(Of String)(“Last”)).CopyToDataTable()
‘ Binds DataGridView with DataTable
dgMissionaries.DataSource = dtMissionaries
xxx xxx
xxxxxxx xxx xxxxxxxxxxxxxxxxxxxxxxxxxx_xxxxx(xxxxxx xx xxxxxx, x xx xxxxxxxxx) xxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxxx.xxxxx
‘ xxxxx xx xxxxxxxxx
xxxxxxxxxxxxxx = xxxxxxxxxxxxxx.xxxxxxxxxxxx().xxxxxxx(xxxxxxxx(xxx) xxx.xxxxx(xx xxxxxx)(“xxxx”)).xxxxxxxxxxxxxxx()
Preview FormMissionaries.vb
xxxxxxxxxxxxxx.xxxxxxx.xxx(“xxx”, xxxx.xxxxxxx(“xxxxxx.xxx32”))
xxxxxxxxxxxxxx.xxxxxxx.xxx(“xxxxxxxxxxxxx”, xxxx.xxxxxxx(“xxxxxx.xxx32”))
xxxxxxxxxxxxxx.xxxxxxx.xxx(“xxxxxxxx”, xxxx.xxxxxxx(“xxxxxx.xxxxxx”)) ‘ xxxxx xxxx xxxx xxxxx
xxxxxxxxxxxxxxxxx.xxxxxxx.xxx(“xxxx”, xxxx.xxxxxxx(“xxxxxx.xxxxxx”))
xxxxxxxxxxxxxxxxx.xxxxxxx.xxx(“xxxxx”, xxxx.xxxxxxx(“xxxxxx.xxxxxx”))
emptyMissionaries.Columns.Add(“State”, Type.GetType(“System.String”)) emptyMissionaries.Columns.Add(“Age”, Type.GetType(“System.Int32”)) emptyMissionaries.Columns.Add(“YearOfService”, Type.GetType(“System.Int32”)) emptyMissionaries.Columns.Add(“Location”, Type.GetType(“System.String”)) ‘ Reads File into Array
Dim missionsarray() As String = File.ReadAllLines(“easterndiv_missions.txt”) ‘ Using Linq populate the datatable with the data in text file missionsarray.ToList().ForEach(Sub(x) dtMissionaries.Rows.Add(x.Split(New Char() {“,”c}).ToArray)) ‘ Sort in Ascending by Default dtMissionaries = dtMissionaries.AsEnumerable().OrderBy(Function(row) row.Field(Of String)(“Last”)).CopyToDataTable() ‘ Binds DataGridView with DataTable dgMissionaries.DataSource = dtMissionaries End Sub Private Sub AllToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles AllToolStripMenuItem.Click ‘ Binds DataGridView with Datatable dgMissionaries.DataSource = dtMissionaries
xxxxxxxxxxxxxxxxxxxx.xxxxxxx = xxxx
xxx xxx
xxxxxxx xxx xxxxxxxxxxxxxxxxxxxxxxx_xxxxx(xxxxxx xx xxxxxx, x xx xxxxxxxxx) xxxxxxx xxxxxxxxxxxxxxxxxxxxxxx.xxxxx
xxx xxxxxxxxxxxxx xx xxxxxxxxx = (xxxx x xx xxxxxxxxxxxxxx.xxxxxxxxxxxx()
xxxxx x.xxxxx(xx xxxxxx)(“xxxxxxxx”) = “xxxxxx”
xxxxxx x).xxxxxxxxxxxxxxx() ‘ xxxxx xxxxxxxxxxxx xxxx xxxxxxxx xxxxxxxxx
Price: $19
Buy Now
Checkout
Added to cart
Buy More Save More
Buy at least TWO items & save up to 30% OFF your ENTIRE order!
Rack up instant rebates in your shopping cart. Simply add items to your cart, and see the savings add up.
Discounts will automatically be applied on eligible orders.
CSIS 208 Programming Assignment 6 – $19.00
CSIS 208 Programming Assignment 7 – $19.00
CSIS 208 Programming Assignment 8 – $19.00
CSIS 208 Course Project – $29.00
Add to Cart
Checkout
Added to cart
You May Also Like:
CSIS 208 Final Exam
CSIS 208 Programming Assignment 1
CSIS 208 Programming Assignment 2
CSIS 208 Programming Assignment 3
CSIS 208 Programming Assignment 4
CSIS 208 Programming Assignment 5
CSIS 208 Programming Assignment 7
CSIS 208 Programming Assignment 8
CSIS 208 Course Project