public List<VacancyDTO> getVacanciesByManager(string manager) { VacancyDAO vac_context = new VacancyDAO(); List<VacancyDTO> mList = vac_context.findAll(); List<VacancyDTO> v = new List<VacancyDTO>(); VacancyDTO vacancy; var obj = mList; foreach (VacancyDTO objs in obj) { vacancy = new VacancyDTO(); string objDept = objs.manager.ToString(); int i = objDept.CompareTo(manager); if (i == 0) { vacancy.vacancyNumber = objs.vacancyNumber; vacancy.department = objs.department; vacancy.manager = objs.manager; v.Add(vacancy); } } return v; }
public List<VacancyDTO> getAllLiveVancancies() { VacancyDAO vac_context = new VacancyDAO(); List<VacancyDTO> vlive = vac_context.findAll(); List<VacancyDTO> v = new List<VacancyDTO>(); VacancyDTO vacancy; var obj = vlive; foreach (VacancyDTO objs in obj) { vacancy = new VacancyDTO(); string endString = objs.endDate.ToShortDateString(); string testString = DateTime.Now.ToShortDateString(); int i = endString.CompareTo(testString); if (i > 0 ) { vacancy.vacancyNumber = objs.vacancyNumber; vacancy.endDate = objs.endDate; vacancy.viewStatus = objs.viewStatus; v.Add(vacancy); } } return v; }
public List<VacancyDTO> getVacanciesByStatus(string status) { VacancyDAO vac_context = new VacancyDAO(); List<VacancyDTO> vStatus = vac_context.findAll(); List<VacancyDTO> v = new List<VacancyDTO>(); VacancyDTO vacancy; var obj = vStatus; foreach (VacancyDTO objs in obj) { vacancy = new VacancyDTO(); string objDept = objs.status.ToString(); int i = objDept.CompareTo(status); if (i == 0) { vacancy.vacancyNumber = objs.vacancyNumber; vacancy.department = objs.status; vacancy.manager = objs.manager; v.Add(vacancy); } } return v; }
public void VacancyDAO_Test() { /*Context*/ VacancyDAO vac_context = new VacancyDAO(); /*Insert*/ VacancyDTO vac = new VacancyDTO(); vac.department = "IS"; vac.description = "Web services"; vac.manager = "Tom"; vac.recruiter = "Thumi"; vac.site = "www.petrosa.co.za"; vac.startDate = new DateTime(2012, 10, 10); vac.endDate = new DateTime(2012, 12, 1); vac.description = "desktop support"; vac.title = "support technician"; vac.vacancyNumber = "1"; vac.viewCount = 10; vac.viewStatus = "published"; vac.status = "active"; vac_context.presist(vac); /*Update*/ vac.status = "draft"; vac_context.merge(vac); Assert.AreEqual(vac.status, "draft"); /*Delete*/ Assert.AreEqual(vac_context.removeByUserId("1"), true); vac_context.removeByUserId("1"); }
public void ApplicationDAO_Test() { AccountDAO account_context = new AccountDAO(); ApplicationDAO app_context = new ApplicationDAO(); VacancyDAO vac_context = new VacancyDAO(); /*Insert*/ AccountDTO account = new AccountDTO(); account.userName = "******"; account.status = "active"; account.password = "******"; account.accountType = "admin"; account_context.presist(account); VacancyDTO vac = new VacancyDTO(); vac.department = "IS"; vac.description = "Web services"; vac.manager = "Tom"; vac.recruiter = "Thumi"; vac.site = "www.petrosa.co.za"; vac.startDate = new DateTime(2012, 10, 10); vac.endDate = new DateTime(2012, 12, 1); vac.description = "desktop support"; vac.title = "support technician"; vac.vacancyNumber = "1"; vac.viewCount = 10; vac.viewStatus = "published"; vac.status = "active"; vac_context.presist(vac); bool expectedVac = true; bool actualVac; actualVac = vac_context.isFound("1"); Assert.AreEqual(expectedVac, actualVac); ApplicationDTO application = new ApplicationDTO(); application.userName = "******"; application.vacancyNumber = "1"; application.status = "open"; app_context.presist(application); bool expected = true; bool actual; actual = app_context.isFound("griddy", "1"); Assert.AreEqual(expected, actual); /*Update*/ application.status = "closed"; expected = true; actual = app_context.merge(application); Assert.AreEqual(expected, actual); /*Delete*/ Assert.AreEqual(app_context.removeByUserId("griddy", "1"), true); Assert.AreEqual(vac_context.removeByUserId("1"), true); Assert.AreEqual(account_context.removeByUserId("griddy"), true); }
public void KeyWordDAO_Test() { /*Context*/ KeyWordDAO key_context = new KeyWordDAO(); VacancyDAO vac_context = new VacancyDAO(); /*Insert*/ VacancyDTO vac = new VacancyDTO(); vac.department = "IS"; vac.description = "Web services"; vac.manager = "Tom"; vac.recruiter = "Thumi"; vac.site = "www.petrosa.co.za"; vac.startDate = new DateTime(2012, 10, 10); vac.endDate = new DateTime(2012, 12, 1); vac.description = "desktop support"; vac.title = "support technician"; vac.vacancyNumber = "1"; vac.viewCount = 10; vac.viewStatus = "published"; vac.status = "active"; vac_context.presist(vac); KeyWordDTO key = new KeyWordDTO(); key.vacancyNumber = "1"; key.word = "Fish"; key_context.presist(key); bool expectedVac = true; bool actualVac; actualVac = key_context.isFound("Fish", "1"); Assert.AreEqual(expectedVac, actualVac); /*Update*/ //Not Applicable - Composite primary key can not be changed,except by removing the entity. /*Delete*/ Assert.AreEqual(key_context.isFound("Fish", "1"), true); key_context.removeByUserId("Fish", "1"); Assert.AreEqual(key_context.isFound("Fish", "1"), false); vac_context.removeByUserId("1"); }
public void VacancyKillerQuestionDAOConstructorTest() { /*Context*/ VacancyKillerQuestionDAO vacKill_context = new VacancyKillerQuestionDAO(); VacancyDAO vac_context = new VacancyDAO(); /*Insert*/ VacancyDTO vac = new VacancyDTO(); vac.department = "IS"; vac.description = "Web services"; vac.manager = "Tom"; vac.recruiter = "Thumi"; vac.site = "www.petrosa.co.za"; vac.startDate = new DateTime(2012, 10, 10); vac.endDate = new DateTime(2012, 12, 1); vac.description = "desktop support"; vac.title = "support technician"; vac.vacancyNumber = "1"; vac.viewCount = 10; vac.viewStatus = "published"; vac.status = "active"; vac_context.presist(vac); VacancyKillerQuestionDTO vacKill = new VacancyKillerQuestionDTO(); vacKill.vacancyNumber = "1"; vacKill.question = "Do you have a BTech"; vacKill.answer = "Yes"; Assert.AreEqual(vacKill_context.presist(vacKill), true); /*Update*/ vacKill.answer = "No"; vacKill_context.merge(vacKill); Assert.AreEqual(vacKill.answer, "No"); /*Delete*/ Assert.AreEqual(vacKill_context.removeByUserId("1", "Do you have a BTech"), true); vac_context.removeByUserId("1"); }
public void getVacanciesByStatusTest() { VacancyStatus target = new VacancyStatus(); VacancyDAO vac_context = new VacancyDAO(); VacancyDTO vac = new VacancyDTO(); vac.department = "IS"; vac.description = "Web services"; vac.manager = "Tom"; vac.recruiter = "Thumi"; vac.site = "www.petrosa.co.za"; vac.startDate = new DateTime(2012, 10, 10); vac.endDate = new DateTime(2012, 12, 15); vac.description = "desktop support"; vac.title = "support technician"; vac.vacancyNumber = "1"; vac.viewCount = 10; vac.viewStatus = "published"; vac.status = "active"; vac_context.presist(vac); bool expected = true; bool actual; actual = vac_context.isFound("1"); Assert.AreEqual(expected, actual); VacancyDTO vacTwo = new VacancyDTO(); vacTwo.department = "Business"; vacTwo.description = "Money"; vacTwo.manager = "Marc"; vacTwo.recruiter = "Mandy"; vacTwo.site = "Durban"; vacTwo.startDate = new DateTime(2012, 1, 10); vacTwo.endDate = new DateTime(2012, 3, 15); vacTwo.description = "desktop support"; vacTwo.title = "support technician"; vacTwo.vacancyNumber = "2"; vacTwo.viewCount = 10; vacTwo.viewStatus = "published"; vacTwo.status = "active"; vac_context.presist(vacTwo); bool expected2 = true; bool actual2; actual2 = vac_context.isFound("2"); Assert.AreEqual(expected2, actual2); VacancyDTO vacThree = new VacancyDTO(); vacThree.department = "IS"; vacThree.description = "Money"; vacThree.manager = "Tom"; vacThree.recruiter = "Fuji"; vacThree.site = "Durban"; vacThree.startDate = new DateTime(2012, 11, 10); vacThree.endDate = new DateTime(2012, 12, 20); vacThree.description = "App Specialist"; vacThree.title = "Developer"; vacThree.vacancyNumber = "3"; vacThree.viewCount = 10; vacThree.viewStatus = "published"; vacThree.status = "inactive"; vac_context.presist(vacThree); bool expected3 = true; bool actual3; actual3 = vac_context.isFound("3"); Assert.AreEqual(expected3, actual3); VacancyStatus status = new VacancyStatus(); List<VacancyDTO> listVacs = status.getVacanciesByStatus("active"); foreach (VacancyDTO v in listVacs) { string vacNo = v.vacancyNumber.ToString(); Assert.IsNotNull(vacNo); } vac_context.removeByUserId("1"); vac_context.removeByUserId("2"); vac_context.removeByUserId("3"); }
public void userServiceTest() { UserService target = CreateUserService(); // TODO: Initialize to an appropriate value AccountDAO account_context = new AccountDAO(); ApplicationDAO app_context = new ApplicationDAO(); VacancyDAO vac_context = new VacancyDAO(); /*Insert*/ AccountDTO account = new AccountDTO(); account.userName = "******"; account.status = "active"; account.password = "******"; account.accountType = "admin"; account_context.presist(account); VacancyDTO vac = new VacancyDTO(); vac.department = "IS"; vac.description = "Web services"; vac.manager = "Tom"; vac.recruiter = "Thumi"; vac.site = "www.petrosa.co.za"; vac.startDate = new DateTime(2012, 10, 10); vac.endDate = new DateTime(2012, 12, 1); vac.description = "desktop support"; vac.title = "support technician"; vac.vacancyNumber = "1"; vac.viewCount = 10; vac.viewStatus = "published"; vac.status = "active"; vac_context.presist(vac); bool expectedVac = true; bool actualVac; actualVac = vac_context.isFound("1"); Assert.AreEqual(expectedVac, actualVac); ApplicationDTO applicationDto = new ApplicationDTO(); applicationDto.userName = "******"; applicationDto.vacancyNumber = "1"; applicationDto.status = ApplicationStatus.APPLIED.ToString(); app_context.presist(applicationDto); bool expected = true; bool actual; actual = app_context.isFound("griddy", "1"); Assert.AreEqual(expected, actual); //Test changeUserApplicationStatus method target.changeUserApplicationStatus("griddy", "1", ApplicationStatus.SHORTLISTED); ApplicationDTO applicationDto2 = app_context.find("griddy", "1"); Assert.AreEqual(ApplicationStatus.SHORTLISTED.ToString(), applicationDto2.status); //Test getShortListedCandidates method List<ApplicationDTO> candidates = target.getShortListedCandidates("1"); Assert.AreEqual("griddy", candidates[0].userName); /*Delete*/ Assert.AreEqual(app_context.removeByUserId("griddy", "1"), true); Assert.AreEqual(vac_context.removeByUserId("1"), true); Assert.AreEqual(account_context.removeByUserId("griddy"), true); }
public void loadPage(String state) { //view.setVacancyNumber(view.getVacancyNumber()); //view.setRecruiter(recruter); if (state.Equals("new")) { view.setNewView(); } else { AccountService accountService = new AccountServiceImpl(); VacancyDAO vacancyDao = new VacancyDAO(); VacancyDTO vacancyDto = vacancyDao.find(view.getVacancyNumber()); setVacancyDto(vacancyDto); List<VacancyKillerQuestionDTO> vacancyList = accountService.getUserQuestions(view.getVacancyNumber()); List<KeyWordDTO> keyWordList = accountService.getUserKeyWords(view.getVacancyNumber()); view.setQuestionRepeater(vacancyList); view.setKeyWordRepeater(keyWordList); view.setUpdateView(); } }
public void doUpdate() { if (isValid()) { VacancyDAO vacancyInfoDao = new VacancyDAO(); vacancyInfoDao.merge(getVacancyDto()); view.showFeedback("Successfully updated"); } else { view.showFeedback("Error Field vlaues are not valid"); } }
public void doSave() { AccountService accountService = new AccountServiceImpl(); if (isValid()) { if (accountService.isUniqueVacancy(view.getVacancyNumber())) { VacancyDAO vacancyDao = new VacancyDAO(); VacancyDTO vacancy = getVacancyDto(); vacancyDao.presist(vacancy); //view.pageReload(); } else { view.setVacancyNumber("Error, this Date type is already used. Enter another value"); } } else { view.showFeedback("Error Field vlaues are not valid"); } }
public void doReset() { if (isMinimumValid()) { VacancyDAO vacancyDao = new VacancyDAO(); VacancyDTO vacancyInfoDto = vacancyDao.find(view.getVacancyNumber()); setVacancyDto(vacancyInfoDto); view.showFeedback("Fields are reset."); } else { view.showFeedback("Error Field vlaues are not valid"); } }
public void doDelete() { if (isMinimumValid()) { VacancyDAO vacancyDao = new VacancyDAO(); vacancyDao.removeByUserId(view.getVacancyNumber()); view.pageReload(); } else { view.showFeedback("Error Field vlaues are not valid"); } }
protected void Page_Load(object sender, EventArgs e) { newVacancyNumber = new GenerateVacancyNumber(); presenter = new VacancyPresenter(this); String recruter = (String)Session["username"]; String vacancyNumber = (String)Session["vacancyNumber"]; if (!IsPostBack) { VacancyDAO dao = new VacancyDAO(); List<VacancyDTO> vacancyList = dao.findAll(); List<String> vacancyStringList = new List<string>(); foreach (VacancyDTO vacancy in vacancyList) { vacancyStringList.Add(vacancy.vacancyNumber); } ddlVacancies.DataSource = vacancyStringList; ddlVacancies.DataBind(); } }
public void applicationSearchServiceTest() { ApplicationSearchService target = new ApplicationSearchServiceImpl(); // TODO: Initialize to an appropriate value AccountDAO account_context = new AccountDAO(); ApplicationDAO app_context = new ApplicationDAO(); VacancyDAO vac_context = new VacancyDAO(); /*Insert*/ AccountDTO account = new AccountDTO(); account.userName = "******"; account.status = "active"; account.password = "******"; account.accountType = "admin"; account_context.presist(account); VacancyDTO vac = new VacancyDTO(); vac.department = "IS"; vac.description = "Web services"; vac.manager = "Tom"; vac.recruiter = "Thumi"; vac.site = "www.petrosa.co.za"; vac.startDate = new DateTime(2012, 10, 10); vac.endDate = new DateTime(2012, 12, 1); vac.description = "desktop support"; vac.title = "support technician"; vac.vacancyNumber = "1"; vac.viewCount = 10; vac.viewStatus = "published"; vac.status = "active"; vac_context.presist(vac); bool expectedVac = true; bool actualVac; actualVac = vac_context.isFound("1"); Assert.AreEqual(expectedVac, actualVac); ApplicationDTO application = new ApplicationDTO(); application.userName = "******"; application.vacancyNumber = "1"; application.status = "open"; app_context.presist(application); //Test getApplicationByUsername method List<ApplicationDTO> applicationTestListObj = target.getApplicationByUsername("graddy"); Assert.AreEqual(application.status, applicationTestListObj[0].status); //Test getApplicationByStatus method List<ApplicationDTO> applicationTestListObj2 = target.getApplicationByStatus("open"); Assert.AreEqual(application.status, applicationTestListObj2[0].status); //Test getApplicationByVacancyNumber method List<ApplicationDTO> applicationTestListObj3 = target.getApplicationByVacancyNumber("1"); Assert.AreEqual(application.status, applicationTestListObj3[0].status); /*Delete*/ /* account_context.removeByUserId("graddy"); bool expectedDelete = false; bool actualDelete = account_context.isFound("graddy"); Assert.AreEqual(expectedDelete, actualDelete); */ }
public bool isUniqueVacancy(string vacancyNumber) { bool isUnique = false; VacancyDAO dao = new VacancyDAO(); try { return (!dao.isFound(vacancyNumber)); } catch (InvalidOperationException ioe) { isUnique = true; } return isUnique; }