static void TestEmployee() { DataAccessLayer.Employee objE = new DataAccessLayer.Employee(); int NewID, RC; RC = objE.InsEmployee("test", out NewID); Console.WriteLine("RC: {0} and NewID: {1}", RC, NewID); foreach (Employee empl in objE.SelEmployee()) { Console.WriteLine("Employee ID: {0}, Employee Name: {1}", empl.EmployeeID, empl.EmployeeName); } RC = objE.UpdEmployee(NewID, "test2"); Console.WriteLine("RC: {0} on update call", RC); foreach (Employee empl in objE.SelEmployee()) { Console.WriteLine("Employee ID: {0}, Employee Name: {1}", empl.EmployeeID, empl.EmployeeName); } RC = objE.DelEmployee(NewID); Console.WriteLine("RC: {0} on delete call", RC); foreach (Employee empl in objE.SelEmployee()) { Console.WriteLine("Employee ID: {0}, Employee Name: {1}", empl.EmployeeID, empl.EmployeeName); } }