Question

1. Your software development company wants to continue developing and enhancing a software application for internal use.

   For this week's assignment, the application is required to read from a file (data.txt) containing employee data. Your tasks include:

   • Use the data file from Week One (data.txt)
   • Implement LINQ functionalities to search, display, and modify employees' records
   • Meet specifications by displaying on a Windows Form Application

   Program Input File:

   Using Visual Studio and C# programming concepts and using your Week one data.txt file as your source file, write a program to meet the specifications of the company's request. The program should have the following characteristics:

   • Compile and execute without errors
   • Meet specifications by demonstrating LINQ queries, data structure manipulation, and Windows Form output mastery by accomplishing the following:
   • Query employees' data
   • Input the data into a data structure
   • Display the employees' data on the console
   • Logic flow is clear, concise, and effective
   • User inputs and outputs should be clear on screen
   • Validation for input types and data format
   • Appropriate indentation to logically illustrate program structure
   • Identifiers logically describe use
   • Naming conventions are consistent
   • Comments and headers to explain processing that is not obvious
   • Name,            Address,             Age, Gross,    Department, Dev Type, Tax Type
     Bill Gates,      111 Main Street,     29, 22000.00, 11,        Script,   W2
     Steve Jobs,      222 Oak Street,      31, 33000.00, 21,        OOP,      1099
     Elon Musk,       333 South Street,    27, 44000.00, 41,        Script,   W2
     Grace Hopper,    444 Elm Street,      30, 55000.00, 71,        OOP,      W2
     Dennis Ritchie, 555 10th Avenue,     37, 66000.00, 21,        Script,   1099

Answer 1

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.IO;
namespace WindowsFormsApp1
{
public partial class frnChegProj1 : Form
{
public frnChegProj1()
{
InitializeComponent();
}
OpenFileDialog openFileDialog = new OpenFileDialog();
DataTable dt = new DataTable(); //As the datasource for Grid
int DrCurRow = 0;
bool header = true; //first time true

private void btnOpenFile_Click(object sender, EventArgs e)
{
try
{
if (openFileDialog.ShowDialog() == DialogResult.OK)//Do some thing only OK
{
if (openFileDialog.FileName.Contains("Data.txt"))//Do only file name is the defined datafile
{
AssignDatatoGrid(openFileDialog.FileName);

}

}

}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void AssignDatatoGrid(string fileName)
{
using (TextReader txtreader = File.OpenText(fileName))
{
try
{
string linetxt;
while ((linetxt = txtreader.ReadLine()) != null)
{
string[] dataitems = linetxt.Trim().Split(',');
if (dataitems.Length > 6)
{
AddtoDtatatable(dataitems);
header = false;
}

}
}
catch(Exception ex)
{
throw ex;
}
}
  
dgvTxtSrc.DataSource = dt;

}

private void AddtoDtatatable(string[] CurRow)
{
try
{

if (header)
{
//add datatable header since predefined header creating inadvance
dt.Columns.Add(new DataColumn("Name", typeof(string)));
dt.Columns.Add(new DataColumn("Address", typeof(string)));
dt.Columns.Add(new DataColumn("Age", typeof(Int16)));
dt.Columns.Add(new DataColumn("Gross", typeof(double)));
dt.Columns.Add(new DataColumn("Department", typeof(Int16)));
dt.Columns.Add(new DataColumn("DevType", typeof(string)));
dt.Columns.Add(new DataColumn("TaxType", typeof(string)));

//add datatable rows
}
else
{
//add datatable rows
dt.Rows.Add();
for (int i = 0; i < CurRow.Length; i++)
{
dt.Rows[DrCurRow][i] = CurRow[i];

}
DrCurRow = DrCurRow + 1; //assgining /increasing row
}
}
catch(Exception ex)
{
throw ex;
}
}
}

}