public XMLRepository(
IEntityQuery entityQuery,
IVETSEntityManagerView entityManagerView,
IEntityCreate entityCreate,
ITestExecution testExecution,
ITestStatus testStatus,
ITestEvents testEvents,
ISystemLogManager logger,
IReportService resportService,
IApplication application,
IVETSEntityManagerViewModelView entityManagerViewModelView,
VTS vts
)
{
_entityQuery = entityQuery;
_entityManagerView = entityManagerView;
_entityCreate = entityCreate;
_testExecution = testExecution;
_testStatus = testStatus;
_testEvents = testEvents;
_logger = logger;
_resportService = resportService;
_vts = vts;
_application = application;
_entityManagerViewModelView = entityManagerViewModelView;
}
// To retrieve Test Status using Vacancy ID
public List <ITestStatus> GetTestStatusbyVID(int vid)
{
List <ITestStatus> lstTestStatus = new List <ITestStatus>();
SqlCommand objMyCommand;
SqlConnection objMyConnection = DBUtility.getConnection();
try
{
using (objMyConnection)
{
objMyCommand = new SqlCommand("spgetTestStatus", objMyConnection);
objMyCommand.CommandType = CommandType.StoredProcedure;
objMyCommand.Parameters.AddWithValue("@VID", vid);
objMyConnection.Open();
SqlDataReader objSqlDataReader = objMyCommand.ExecuteReader();
while (objSqlDataReader.Read())
{
int CandidateID = Int32.Parse(objSqlDataReader["CandidateProfileID"].ToString());
DateTime WrittenTestDate = Convert.ToDateTime(objSqlDataReader["WrittenTestDate"]);
string WrittenTestStatus = Convert.ToString(objSqlDataReader["WrittenTestStatus"]);
DateTime TechnicalInterviewDate = Convert.ToDateTime(objSqlDataReader["TechnicalInterviewDate"]);
string TechnicalInterviewStatus = Convert.ToString(objSqlDataReader["TechnicalInterviewStatus"]);
DateTime HRInterviewDate = Convert.ToDateTime(objSqlDataReader["HRInterviewDate"]);
string HRInterviewStatus = Convert.ToString(objSqlDataReader["HRInterviewStatus"]);
int TestID = Convert.ToInt32(objSqlDataReader["TestID"]);
ITestStatus objTestStatus = TestStatusFactory.Create_TestStatus(CandidateID, WrittenTestDate, WrittenTestStatus, TechnicalInterviewDate, TechnicalInterviewStatus, HRInterviewDate, HRInterviewStatus, TestID);
lstTestStatus.Add(objTestStatus);
}
objSqlDataReader.Close();
}
return(lstTestStatus);
}
catch (Exception EE)
{
Console.WriteLine(EE);
Console.Read();
return(null);
}
finally
{
objMyConnection.Close();
}
}
public UpdateSystemStateTestStart
(
IStarsApplication starsApplication,
ILocalResourceSupport localResourceSupport,
ITestStatus testStatus,
IEntityQuery entityQuery,
IVETSEntityManagerView entityManagerView,
IDialogService dialogService,
ISystemLogManager systemLogManager
)
{
_starsApplication = starsApplication;
_localResourceSupport = localResourceSupport;
_testStatus = testStatus;
_entityQuery = entityQuery;
_entityManagerView = entityManagerView;
_dialogService = dialogService;
_systemLogManager = systemLogManager;
}
public static ITestStatus Create_TestStatus(int CID, DateTime WTD, string WTS, DateTime TID, string TIS, DateTime HRID, string HRIS, int TestID)
{
objTestStatus = new TestStatus(CID, WTD, WTS, TID, TIS, HRID, HRIS, TestID);
return(objTestStatus);
}
