private async void btnSave_Click(object sender, EventArgs e)
{
var id = txtIdNo.Text;
var name = txtFullName.Text;
var address = txtAddress.Text;
var contactNo = txtContact.Text;
var email = txtEmail.Text;
var dateOfJoin = dateTimePicker.Text;
var gpa = txtGPA.Text;
using (var context = new StudentManagementContext())
{
var emp = new Student(id, name, address, contactNo, email, dateOfJoin, gpa);
context.Employees.Add(emp);
await context.SaveChangesAsync();
}
//instance event args and value has been passed
var args = new IdentityEventArgs(id, name, address, contactNo, email, dateOfJoin, gpa);
//Event has be raised with update arguments of delegate
IdentityUpdated?.Invoke(this, args);
this.Hide();
}
public async void ImportEmployeeFromCsv()
{
using (var openFileDialog1 = new OpenFileDialog()
{
Filter = "CSV|*.csv", ValidateNames = true, Multiselect = false
})
{
if (openFileDialog1.ShowDialog() != DialogResult.OK)
{
return;
}
const char sepChar = ',';
const char quoteChar = '"';
var employeeList = new List <string[]>();
try
{
using (Stream stream = null)
{
var rows = File.ReadAllLines(openFileDialog1.FileName);
foreach (var csvRow in rows)
{
var inQuotes = false;
var fields = new List <string>();
var field = "";
for (var i = 0; i < csvRow.Length; i++)
{
if (inQuotes)
{
if (i < csvRow.Length - 1 && csvRow[i] == quoteChar && csvRow[i + 1] == quoteChar)
{
i = i++;
field += quoteChar;
}
else if (csvRow[i] == quoteChar)
{
inQuotes = false;
}
else
{
if (csvRow[i - 1] == quoteChar)
{
field = "";
field += csvRow[i];
}
else
{
field += csvRow[i];
}
}
}
else
{
if (csvRow[i] == quoteChar)
{
inQuotes = true;
}
if (csvRow[i] == sepChar)
{
fields.Add(field);
field = "";
}
else
{
field += csvRow[i];
}
}
}
if (!string.IsNullOrEmpty(field))
{
fields.Add(field);
field = "";
}
employeeList.Add(fields.ToArray());
}
}
}
catch (Exception er)
{
MessageBox.Show(er.Message, "Error !", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
foreach (var value in employeeList)
{
using (var context = new StudentManagementContext())
{
dataGridView.Rows.Add(value[0], value[1], value[2], value[3], value[4], value[5], value[6], value[7], value[8], value[9]);
var emp = new Student(value[0], value[1], value[2], value[3], value[4], value[5], value[6], value[7], value[8], value[9]);
context.Employees.Add(emp);
try
{
await context.SaveChangesAsync();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error !", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
}
