public List <ITestAdministrator> getTestAdministrators()
{
List <ITestAdministrator> lstTestAdministrator = new List <ITestAdministrator>();
SqlCommand objMyCommand;
SqlConnection objMyConnection = DBUtility.getConnection();
try
{
using (objMyConnection)
{
objMyCommand = new SqlCommand("sp_DisplayTestAdmin", objMyConnection);
objMyCommand.CommandType = CommandType.StoredProcedure;
objMyConnection.Open();
SqlDataReader objSqlDataReader = objMyCommand.ExecuteReader();
while (objSqlDataReader.Read())
{
ITestAdministrator objTestAdministrator = TestAdministratorFactory.Create_TestAdministrator(0, false);
objTestAdministrator.get_EmployeeID = Convert.ToInt32(objSqlDataReader[0]);
objTestAdministrator.get_EmployeeName = Convert.ToString(objSqlDataReader[1]);
objTestAdministrator.get_IsTestAdmin = Convert.ToBoolean(objSqlDataReader[2]);
objTestAdministrator.get_EmployeeDesignation = Convert.ToString(objSqlDataReader[3]);
objTestAdministrator.get_EmployeeLocation = Convert.ToString(objSqlDataReader[4]);
objTestAdministrator.get_EmployeeExperience = Convert.ToInt32(objSqlDataReader[5]);
lstTestAdministrator.Add(objTestAdministrator);
}
objSqlDataReader.Close();
}
return(lstTestAdministrator);
}
catch (Exception EE)
{
Console.WriteLine(EE);
Console.Read();
return(null);
}
finally
{
objMyConnection.Close();
}
}
// To retrieve all the testadministrators
public List <ITestAdministrator> GetList()
{
List <ITestAdministrator> lstTestAdministrator = new List <ITestAdministrator>();
SqlCommand objMyCommand;
SqlConnection objMyConnection = DBUtility.getConnection();
try
{
using (objMyConnection)
{
objMyCommand = new SqlCommand("sp_DisplayTestAdmin", objMyConnection);
objMyCommand.CommandType = CommandType.StoredProcedure;
objMyConnection.Open();
SqlDataReader objSqlDataReader = objMyCommand.ExecuteReader();
while (objSqlDataReader.Read())
{
int id = Int32.Parse(objSqlDataReader["EmployeeID"].ToString());
bool IsTestAdmin = bool.Parse(objSqlDataReader["IsTestAdmin"].ToString());
ITestAdministrator newtestadministrator = TestAdministratorFactory.Create_TestAdministrator(id, IsTestAdmin);
lstTestAdministrator.Add(newtestadministrator);
}
objSqlDataReader.Close();
}
return(lstTestAdministrator);
}
catch (Exception EE)
{
Console.WriteLine(EE);
Console.Read();
return(null);
}
finally
{
objMyConnection.Close();
}
}
// To add Test Administrator
public int addtestadmin(int EmployeeID)
{
TestAdministratorManager objTestAdminManager = new TestAdministratorManager();
listemployee();
if (EmployeeList.Any(p => p.get_EmployeeID == EmployeeID && p.get_Designation == "unithead"))
{
ITestAdministrator objTestAdministrator = TestAdministratorFactory.Create_TestAdministrator(EmployeeID, true);
ITestAdministratorDB testadministratorDB = TestAdministratorDBFactory.Create_TestAdminDB();
return(testadministratorDB.Save(objTestAdministrator));
}
else if (EmployeeList.Any(p => p.get_EmployeeID == EmployeeID && p.get_Designation == "employee"))
{
ITestAdministrator objTestAdministrator = TestAdministratorFactory.Create_TestAdministrator(EmployeeID, false);
ITestAdministratorDB test_adminDB = TestAdministratorDBFactory.Create_TestAdminDB();
return(test_adminDB.Save(objTestAdministrator));
}
else
{
return(0);
}
}
