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);
}
}
