private void btnExport_Click(object sender, EventArgs e) { var saveDialog = new SaveFileDialog { FileName = "EmployeesExport", Filter = "Comma Delimited File|*.csv" }; var employeesToExport = (from DataGridViewRow dataGridViewRow in dgEmployees.Rows select dataGridViewRow.DataBoundItem as Employee).ToList(); if (saveDialog.ShowDialog() == DialogResult.OK) { File.WriteAllText(saveDialog.FileName, EmployeeExport.ExportEmployeeToCsv(employeesToExport)); } }
public void Should_export_all_the_employees_in_csv() { var employees = new List <Employee> { new Employee { id = 32, name = "Gov. Datta Saini", email = "*****@*****.**", gender = "Male", status = "Inactive", created_at = DateTime.Parse("2021-05-04T00:20:04"), updated_at = DateTime.Parse("2021-05-04T00:20:04") }, new Employee { id = 51, name = "Leela Devar", email = "*****@*****.**", gender = "Female", status = "Active", created_at = DateTime.Parse("2021-05-04T00:20:04"), updated_at = DateTime.Parse("2021-05-04T00:20:04") } }; var export = EmployeeExport.ExportEmployeeToCsv(employees); Assert.AreEqual("id,name,email,gender,status,created_at,updated_at\r\n" + "32,Gov. Datta Saini,[email protected],Male,Inactive,2021-05-04T00:20:04,2021-05-04T00:20:04\r\n" + "51,Leela Devar,[email protected],Female,Active,2021-05-04T00:20:04,2021-05-04T00:20:04\r\n", export); }