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);
}
}
static void TestEmployeeProjectHour()
{
DataAccessLayer.EmployeeProjectHour objEph = new DataAccessLayer.EmployeeProjectHour();
int RC;
DateTime dt = DateTime.Now;
int newEmployeeID;
int newProjectID;
foreach (EmployeeProjectHour prjt in objEph.SelEmployeeProjectHours())
{
Console.WriteLine("Employee ID: {0}, Employee Name {1}, Project ID: {2}, Project Name: {3}, Date: {4}, Hours: {5}", prjt.EmployeeID, prjt.EmployeeName, prjt.ProjectID, prjt.ProjectName, prjt.Date, prjt.Hours);
}
//create an employee and a project to insert
Employee objEmpl = new Employee();
objEmpl.InsEmployee("bob dobalina",out newEmployeeID);
Project objProj = new Project();
objProj.InsProject("recording","", out newProjectID);
RC = objEph.InsEmployeeProjectHours(newEmployeeID, newProjectID, dt, 42);
Console.WriteLine();
Console.WriteLine("RC: {0}", RC);
foreach (EmployeeProjectHour prjt in objEph.SelEmployeeProjectHours())
{
Console.WriteLine("Employee ID: {0}, Employee Name {1}, Project ID: {2}, Project Name: {3}, Date: {4}, Hours: {5}", prjt.EmployeeID, prjt.EmployeeName, prjt.ProjectID, prjt.ProjectName, prjt.Date, prjt.Hours);
}
RC = objEph.UpdEmployeeProjectHours(newEmployeeID, newProjectID, dt, 104);
Console.WriteLine();
Console.WriteLine("RC: {0}", RC);
foreach (EmployeeProjectHour prjt in objEph.SelEmployeeProjectHours())
{
Console.WriteLine("Employee ID: {0}, Employee Name {1}, Project ID: {2}, Project Name: {3}, Date: {4}, Hours: {5}", prjt.EmployeeID, prjt.EmployeeName, prjt.ProjectID, prjt.ProjectName, prjt.Date, prjt.Hours);
}
RC = objEph.DelEmployeeProjectHours(newEmployeeID, newProjectID, dt);
Console.WriteLine();
Console.WriteLine("RC: {0}", RC);
foreach (EmployeeProjectHour prjt in objEph.SelEmployeeProjectHours())
{
Console.WriteLine("Employee ID: {0}, Employee Name {1}, Project ID: {2}, Project Name: {3}, Date: {4}, Hours: {5}", prjt.EmployeeID, prjt.EmployeeName, prjt.ProjectID, prjt.ProjectName, prjt.Date, prjt.Hours);
}
objEmpl.DelEmployee(newEmployeeID);
objProj.DelProject(newProjectID);
}
