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