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