public void insertEmployee(EmployeeV2 emp)
{
using (SqlConnection con = new SqlConnection(connectStr))
{
con.Open();
string qry = string.Format("INSERT INTO EMPLOYEE VALUES('{0}','{1}')", emp.EmpName, emp.Designation);
SqlCommand cmd = new SqlCommand(qry, con);
cmd.ExecuteNonQuery();
}
}
/// <summary>
/// This method achive Single responsibility principle
/// </summary>
public static void SRPrincipleResolve()
{
EmployeeV2 emp = new EmployeeV2();
emp.deleteAllEmp();
Console.WriteLine("employee records deleted...");
emp.EmpName = "Sandeep Tathe";
emp.Designation = "Specialist";
emp.insertEmployee(emp);
emp.EmpName = "Yogiraj Deshpande";
emp.Designation = "Senior Consultant";
emp.insertEmployee(emp);
Console.WriteLine("employee records inserted...");
Console.WriteLine("report generation started...");
ReportGeneration report = new ReportGeneration();
report.GenerateReport((int)ReportType.CSV);
Console.WriteLine("report generated...");
}
