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 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> findAll()
{
var objs = (from p in ctx.Vacancies
select p);
VacancyDTO acc = null;
List<VacancyDTO> Vacancies = new List<VacancyDTO>();
foreach(Vacancy obj in objs)
{
acc = new VacancyDTO();
acc.vacancyNumber = obj.vacancyNumber;
acc.viewStatus = obj.viewStatus;
acc.title = obj.title;
acc.description = obj.description;
acc.department = obj.department;
acc.site = obj.site;
acc.startDate = obj.startDate;
acc.endDate = obj.endDate;
acc.viewCount = obj.viewCount;
acc.status = obj.status;
acc.manager = obj.manager;
acc.recruiter = obj.recruiter;
Vacancies.Add(acc);
}
return Vacancies;
}
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 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);
}
private static string CreateExternalVacancyLink(VacancyDTO vacancy)
{
var type = "apprenticeship";
if (vacancy.VacancyType == VacancyType.Traineeship)
{
type = "traineeship";
}
return(new Uri(new Uri(VacancyLinkUrlExternal), Path.Combine(type, vacancy.VacancyId.ToString())).ToString());
}
public ActionResult Edit(int id)
{
VacancyDTO vacancy = vacancyService.GetVacancy(id);
var mapper = new MapperConfiguration(cfg => cfg.CreateMap <VacancyDTO, VacancyViewModel>()).CreateMapper();
var vacancyView = mapper.Map <VacancyViewModel>(vacancy);
ViewBag.CategoryId = new SelectList(categoryService.GetCategories(), "CategoryId", "CategoryName", vacancyView.CategoryId);
ViewBag.CustomerId = new SelectList(customService.GetCustomers(), "CustomerId", "CustomerLastName", vacancyView.CustomerId);
return(View(vacancyView));
}
public void CreateVacancy_TryToCreateVacancy_ShouldRepositoryCreateOnce()
{
var Vacancy = new VacancyDTO {
Id = It.IsAny <int>()
};
// act
vacService.CreateVacancy(Vacancy);
//assert
VacancyRepository.Verify(x => x.Create(It.IsAny <Vacancy>()));
}
public async Task <IActionResult> Put(Guid id, [FromBody] VacancyDTO model)
{
if (model == null)
{
throw new ArgumentNullException(nameof(model));
}
model.Id = id;
await _service.Update(model);
return(Ok(_service.GetById(model.Id)));
}
public void Add_TryToCreate_RepositoryShouldCallOnce()
{
//act
var vacancy = new VacancyDTO {
Name = It.IsAny <string>(), EmployerId = It.IsAny <int>()
};
vacancyService.Add(vacancy);
//assert
vacancyRepository.Verify(x => x.Add(It.IsAny <Vacancy>()), Times.Once);
}
public void EditVacancy_NullElement_ShouldThrowException()
{
//arrange
var Vacancy = new VacancyDTO {
Id = It.IsAny <int>(), ContName = It.IsAny <string>(), ContPhone = It.IsAny <string>()
};
VacancyRepository.Setup(x => x.Get(It.IsAny <int>())).Returns <Vacancy>(null);
//act & assert
Assert.Throws <ArgumentOutOfRangeException>(() => vacService.EditVacancy(Vacancy));
}
public async Task <IActionResult> Create(VacancyDTO vacancyDto)
{
var vacancy = _mapper.Map <Vacancy>(vacancyDto);
await _repo.Create(vacancy);
if (await _repo.SaveAll())
{
return(CreatedAtRoute("CreateVacancy", new { id = vacancy.Id }, vacancy));
}
return(BadRequest("creation unsuccessful"));
}
public override void RemoveVacancy(VacancyDTO vacancyDTO)
{
if (vacancyDTO == null)
{
throw new ArgumentNullException(nameof(vacancyDTO));
}
if (Database.Vacancies.Get(vacancyDTO.Id) == null)
{
throw new ArgumentOutOfRangeException("Not found career");
}
Database.Vacancies.Delete(vacancyDTO.Id);
Database.Save();
}
public void RemoveVacancy_RemoveRepository_ShouldCallsOnce()
{
var Vacancy = new VacancyDTO {
Id = It.IsAny <int>(), ContName = It.IsAny <string>(), ContPhone = It.IsAny <string>()
};
VacancyRepository.Setup(x => x.Get(It.IsAny <int>())).Returns(new Vacancy {
Id = It.IsAny <int>(), ContName = It.IsAny <string>(), ContPhone = It.IsAny <string>()
});
//act
vacService.RemoveVacancy(Vacancy);
//assert
VacancyRepository.Verify(x => x.Delete(It.IsAny <int>()));
}
public async Task <IActionResult> Update(VacancyDTO vacancyDto)
{
var vacancy = _mapper.Map <Vacancy>(vacancyDto);
var thisVacancy = await _repo.Get(vacancy.Id);
if (thisVacancy == null)
{
return(BadRequest("Vacancy not found"));
}
if (await _repo.SaveAll())
{
return(NoContent());
}
return(BadRequest("Update unsuccessful"));
}
public void UpdateVacancy(VacancyDTO vacancyDTO)
{
Vacancy vacancy = Database.Vacancies.Get(vacancyDTO.VacancyId);
if (vacancy == null)
{
throw new ValidationException("Вакансия не найдена", "");
}
vacancy.VacancyName = vacancyDTO.VacancyName;
vacancy.VacancyDescript = vacancyDTO.VacancyDescript;
vacancy.CustomerId = vacancyDTO.CustomerId;
vacancy.Date = DateTime.Now;
vacancy.CategoryId = vacancyDTO.CategoryId;
Database.Vacancies.Update(vacancy);
Database.Save();
}
public HttpResponseMessage GetReportVacancy([FromBody] VacancyDTO req)
{
ReportTvModels olap = _mapper.Map <ReportTvModels>(req);
string restring = string.Empty;
int count = 0;
if (string.IsNullOrWhiteSpace(olap.name))
{ //当条件为空 返回-2
restring = Remess.GetResultMessage("[]", olap, "条件Name不能为空！", -2, 0);
result.Content = new StringContent(restring, Encoding.GetEncoding("UTF-8"), "application/json");
return(result);
}
try
{
restring = JsonConvert.SerializeObject(dbGet.GetVacancy(olap, _settings), new DataTableConverter());
//count = Convert.ToInt32(dbGet.GetTptShipmentCount(olap, _settings).Rows[0][0].ToString());
// restring = restring.Replace("\"[{\\", "[{").Replace("\\\"", "\"").Replace("}]\"", "}]").Replace(":\"[[", ":[[").Replace("]]\"}", "]]}");
}
catch (Exception ex)
{
//当查询语句报错 返回-3
restring = Remess.GetResultMessage("[]", olap, "defeated", -3, count);
result.Content = new StringContent(restring, Encoding.GetEncoding("UTF-8"), "application/json");
return(result);
}
//查询语句正确
if (restring.Length > 2)
{
//参数正确有回传结果 1
restring = Remess.GetResultMessage(restring, olap, "success", 1, count);
}
else
{
//参数正确 回传结果为空 -1
restring = Remess.GetResultMessage(restring, olap, "defeated", -1, count);
}
result.Content = new StringContent(restring, Encoding.GetEncoding("UTF-8"), "application/json");
return(result);
}
private static void RefreshExistingVacanciesProgress(Vacancy destination, VacancyDTO source, IVacancyStageInfoRepository vacancyStageInfoRepository)
{
source.CandidatesProgress.Where(x => !x.IsNew()).ToList().ForEach(updatedVacanciesStageInfo =>
{
var domainVacancyStageInfo = destination.CandidatesProgress.FirstOrDefault(x => x.Id == updatedVacanciesStageInfo.Id);
if (domainVacancyStageInfo == null)
{
throw new ArgumentNullException("You trying to update vacanies progress which is actually doesn't exists in database");
}
if (updatedVacanciesStageInfo.ShouldBeRemoved())
{
vacancyStageInfoRepository.Delete(updatedVacanciesStageInfo.Id);
}
else
{
domainVacancyStageInfo.Update(destination, updatedVacanciesStageInfo);
}
});
}
private static void RefreshExistingComments(Vacancy destination, VacancyDTO source, IRepository <Comment> commentRepository)
{
source.Comments.Where(x => !x.IsNew()).ToList().ForEach(updatedComment =>
{
var domainComment = destination.Comments.FirstOrDefault(x => x.Id == updatedComment.Id);
if (domainComment == null)
{
throw new ArgumentNullException("You trying to update comment which is actually doesn't exists in database");
}
if (updatedComment.ShouldBeRemoved())
{
commentRepository.Delete(updatedComment.Id);
}
else
{
domainComment.Update(updatedComment);
}
});
}
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 override void CreateVacancy(VacancyDTO vacancyDTO)
{
if (vacancyDTO == null)
{
throw new ArgumentNullException(nameof(vacancyDTO));
}
if (vacancyDTO.Id != 0 && Database.Vacancies.Get(vacancyDTO.Id) != null)
{
throw new ArgumentOutOfRangeException("Found duplicate id career");
}
if (Database.Headings.Get(vacancyDTO.HeadingId) == null)
{
throw new ArgumentOutOfRangeException("Invalid argument rubricId");
}
Database.Vacancies.Create(Mapper.Map <VacancyDTO, Vacancy>(vacancyDTO));
Database.Save();
}
public void AddVacancy(VacancyDTO vacancyDTO)
{
Customer customer = Database.Customers.Get(vacancyDTO.CustomerId);
if (customer == null)
{
throw new ValidationException("Вакансия не найдена", "");
}
Vacancy vacancy = new Vacancy
{
Date = DateTime.Now,
VacancyName = vacancyDTO.VacancyName,
CustomerId = customer.CustomerId,
VacancyDescript = vacancyDTO.VacancyDescript,
CategoryId = vacancyDTO.CategoryId
};
Database.Vacancies.Create(vacancy);
Database.Save();
}
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 static void Update(this Vacancy destination, VacancyDTO source, IUnitOfWork uow)
{
destination.Id = source.Id;
if (source.Id == 0)
{
PerformVacancyStageFilling(destination, uow);
}
destination.State = source.State;
destination.Title = source.Title;
destination.Description = source.Description;
destination.SalaryMin = source.SalaryMin;
destination.SalaryMax = source.SalaryMax;
destination.TypeOfEmployment = source.TypeOfEmployment;
destination.StartDate = source.StartDate;
destination.EndDate = source.EndDate;
destination.DeadlineDate = source.DeadlineDate;
PerformAddingDeadlineToCalendar(destination, source, uow);
destination.DeadlineToCalendar = source.DeadlineToCalendar;
destination.ParentVacancyId = source.ParentVacancyId;
destination.IndustryId = source.IndustryId;
destination.DepartmentId = source.DepartmentId;
destination.ResponsibleId = source.ResponsibleId;
destination.CurrencyId = source.CurrencyId;
destination.ChildVacanciesNumber = source.ChildVacanciesNumber;
destination.ClosingCandidateId = source.ClosingCandidateId;
PerformLevelsSaving(destination, source, uow.LevelRepo);
PerformLocationsSaving(destination, source, uow.CityRepo);
PerformTagsSaving(destination, source, uow.TagRepo);
PerformSkillsSaving(destination, source, uow.SkillRepo);
PerformLanguageSkillsSaving(destination, source, uow.LanguageSkillRepo);
PerformVacanciesProgressSaving(destination, source, uow.VacancyStageInfoRepo);
PerformFilesSaving(destination, source, uow.FileRepo);
PerformCommentsSaving(destination, source, uow.CommentRepo);
PerformChildVacanciesUpdating(destination, uow);
}
public VacancyDTO find(string vacancyNumber)
{
var obj = (from p in ctx.Vacancies
where p.vacancyNumber == @vacancyNumber
select p).Single();
VacancyDTO acc = new VacancyDTO();
acc.vacancyNumber = obj.vacancyNumber;
acc.viewStatus = obj.viewStatus;
acc.title = obj.title;
acc.description = obj.description;
acc.department = obj.department;
acc.site = obj.site;
acc.startDate = obj.startDate;
acc.endDate = obj.endDate;
acc.viewCount = obj.viewCount;
acc.status = obj.status;
acc.manager = obj.manager;
acc.recruiter = obj.recruiter;
return acc;
}
private static void PerformLanguageSkillsSaving(Vacancy destination, VacancyDTO source, ILanguageSkillRepository languageSkillRepository)
{
var updatedLanguageSkill = source.LanguageSkill;
LanguageSkill domainLanguageSkill = destination.LanguageSkill;
if (destination.LanguageSkill == null)
{
domainLanguageSkill = destination.LanguageSkill = new LanguageSkill();
}
if (updatedLanguageSkill == null)
{
destination.LanguageSkill = null;
return;
}
if (updatedLanguageSkill.ShouldBeRemoved())
{
languageSkillRepository.Delete(updatedLanguageSkill.Id);
}
else
{
domainLanguageSkill.Update(updatedLanguageSkill);
}
}
private static void PerformFilesSaving(Vacancy destination, VacancyDTO source, IFileRepository fileRepository)
{
source.Files.ToList().ForEach(file =>
{
var fileInVacancy = destination.Files.FirstOrDefault(x => x.Id == file.Id);
var dbFile = fileRepository.GetByID(file.Id);
if (dbFile == null)
{
throw new Exception("Unknown file");
}
if (file.ShouldBeRemoved())
{
fileRepository.Delete(file.Id);
}
else
{
dbFile.Update(file);
if (fileInVacancy == null)
{
destination.Files.Add(dbFile);
}
}
});
}
private void CreateChildVacanciesIfNeeded(Vacancy domain, VacancyDTO dto)
{
List <Vacancy> childVacancies = new List <Vacancy>();
if (dto.ChildVacanciesNumber.HasValue)
{
if (!domain.ChildVacancies.Any())
{
if (dto.HasParent())
{
throw new Exception("This vacancy has parent vacancy, so you can't create child of it");
}
dto.ChildVacanciesNumber.Value.Times(() =>
{
Vacancy childVacancy = new Vacancy();
childVacancy.UpdateChildWithParent(domain, uow);
childVacancies.Add(childVacancy);
});
}
else if (dto.ChildVacanciesNumber.Value > domain.ChildVacancies.Count)
{
var additionalVacancyChildsNumber = dto.ChildVacanciesNumber.Value - domain.ChildVacancies.Count;
additionalVacancyChildsNumber.Times(() =>
{
Vacancy childVacancy = new Vacancy();
childVacancy.UpdateChildWithParent(domain, uow);
childVacancies.Add(childVacancy);
});
}
childVacancies.ForEach(x => domain.ChildVacancies.Add(x));
}
if (domain.ChildVacanciesNumber < domain.ChildVacancies.Count)
{
domain.ChildVacanciesNumber = domain.ChildVacancies.Count;
}
}
private static bool NeedAddDeadlineEvent(Vacancy destination, VacancyDTO source)
{
return(!destination.DeadlineToCalendar && source.DeadlineToCalendar);
}
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 remove(VacancyDTO entity)
{
return this.removeByUserId(entity.vacancyNumber);
}
public VacancyDTO getVacancyDto()
{
VacancyDTO vacancyDto = new VacancyDTO();
vacancyDto.vacancyNumber = view.getVacancyNumber();
vacancyDto.viewStatus = view.getViewStatus();
vacancyDto.title = view.getTitle();
vacancyDto.description = view.getDescription();
vacancyDto.department = view.getDepartment();
vacancyDto.site = view.getSite();
vacancyDto.startDate = view.getStartDate();
vacancyDto.endDate = view.getEndDate();
vacancyDto.viewCount = view.getViewCount();
vacancyDto.status = view.getStatus();
vacancyDto.manager = view.getManager();
vacancyDto.recruiter = view.getRecruiter();
view.setRecruiter(vacancyDto.recruiter);
return vacancyDto;
}
public bool merge(VacancyDTO entityDTO)
{
try
{
var objt = (from p in ctx.Vacancies
where p.vacancyNumber == @entityDTO.vacancyNumber
select p).Single();
model.Vacancy obj = (Vacancy)objt;
/*Update*/
obj.vacancyNumber = entityDTO.vacancyNumber;
obj.viewStatus = entityDTO.viewStatus;
obj.title = entityDTO.title;
obj.description = entityDTO.description;
obj.department = entityDTO.department;
obj.site = entityDTO.site;
obj.startDate = entityDTO.startDate;
obj.endDate = entityDTO.endDate;
obj.viewCount = entityDTO.viewCount;
obj.status = entityDTO.status;
obj.manager = entityDTO.manager;
obj.recruiter = entityDTO.recruiter;
ctx.SubmitChanges();
return true;
}
catch (Exception)
{
ctx.Dispose();
ctx = new ModelDataContext();
return false;
}
}
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 setVacancyDto(VacancyDTO vacancyDto)
{
view.setVacancyNumber(vacancyDto.vacancyNumber);
view.setViewStatus(vacancyDto.viewStatus);
view.setTitle(vacancyDto.title);
view.setDescription(vacancyDto.description);
view.setDepartment(vacancyDto.department);
view.setSite(vacancyDto.site);
view.setStartDate(vacancyDto.startDate);
view.setEndDate(vacancyDto.endDate);
view.setViewCount(vacancyDto.viewCount);
view.setStatus(vacancyDto.status);
view.setManager(vacancyDto.manager);
view.setRecruiter(vacancyDto.recruiter);
//view.setCostToCompany(vacancyDto.costToCompany);
}
public VacancyRssDTO GetVacanciesForRss(VacancySearchDetailForRssDTO parameters)
{
var retVacacies = new VacancyRssDTO();
var vacancyList = new List <VacancyDTO>();
var feedTitle = string.Empty;
var feedDescription = string.Empty;
var feedImageUrl = string.Empty;
var feedCopyrightInfo = string.Empty;
var alternateLink = string.Empty;
using (var db = DataContextFactory.CreateDataContext <VacancySearchDataContext>())
{
var result = db.uspGetVacanciesForRSS((int)parameters.FeedType,
parameters.DayRange,
parameters.FrameworkCode,
parameters.OccupationCode,
parameters.CountyCode,
parameters.Town,
parameters.RegionCode,
parameters.VacancyReferenceId,
ref feedTitle,
ref feedDescription,
ref feedImageUrl,
ref feedCopyrightInfo,
ref alternateLink).ToList();
for (int i = 0; i < result.Count(); i++)
{
var vacancy = new VacancyDTO
{
VacancyId = result[i].VacancyId,
VacancyTitle = result[i].VacancyTitle,
EmployerName = result[i].EmployerTradingName,
ShortDescription = result[i].ShortDescription,
VacancyType = FormatIntAsVacancyType(result[i].VacancyType.GetValueOrDefault()),
ApprenticeshipFramework =
new ApprenticeshipFramework {
Description = result[i].JobRole
},
ClosingDate = result[i].ClosingDate.GetValueOrDefault(),
VacancyAddress =
new AddressDetails {
Town = result[i].VacancyLocation
},
PossibleStartDate = result[i].PublishDate,
VacancyLocationType = (VacancyLocationType)result[i].VacancyLocationTypeId,
VacancyReference = Convert.ToInt32(result[i].VacancyReferenceNumber),
WageText = result[i].WageText
};
vacancyList.Add(vacancy);
}
}
retVacacies.FeedTitle = feedTitle;
retVacacies.FeedDescription = feedDescription;
retVacacies.FeedImageUrl = feedImageUrl;
retVacacies.FeedCopyrightInformation = feedCopyrightInfo;
retVacacies.Vacancies = vacancyList;
retVacacies.AlternateLink = alternateLink;
return(retVacacies);
}
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);
}
private static void PerformVacanciesProgressSaving(Vacancy destination, VacancyDTO source, IVacancyStageInfoRepository vacancyStageInfoRepository)
{
//TODO: if vacancy id null - set to THIS
RefreshExistingVacanciesProgress(destination, source, vacancyStageInfoRepository);
CreateNewVacanciesProgress(destination, source);
}
public async Task Update(VacancyDTO VacancyDto)
{
Vacancy Vacancy = _mapper.Map <Vacancy>(VacancyDto);
await _store.Update(Vacancy);
}
public async Task <Guid> Create(VacancyDTO vacancyDto)
{
Vacancy vacancy = _mapper.Map <Vacancy>(vacancyDto);
return(await _store.Create(vacancy));
}
public abstract void CreateVacancy(VacancyDTO vacancyDTO);
public static string CreateVacancyUrlForRssFeed(VacancyDTO vacancy)
{
return(CreateExternalVacancyLink(vacancy));
}
private static void PerformCommentsSaving(Vacancy destination, VacancyDTO source, IRepository <Comment> commentRepository)
{
RefreshExistingComments(destination, source, commentRepository);
CreateNewComments(destination, source);
}
public abstract void EditVacancy(VacancyDTO vacancyDTO);
public abstract void RemoveVacancy(VacancyDTO vacancyDTO);
public bool presist(VacancyDTO entityDTO)
{
try
{
model.Vacancy obj = new Vacancy();
obj.vacancyNumber = entityDTO.vacancyNumber;
obj.viewStatus = entityDTO.viewStatus;
obj.title = entityDTO.title;
obj.description = entityDTO.description;
obj.department = entityDTO.department;
obj.site = entityDTO.site;
obj.startDate = entityDTO.startDate;
obj.endDate = entityDTO.endDate;
obj.viewCount = entityDTO.viewCount;
obj.status = entityDTO.status;
obj.manager = entityDTO.manager;
obj.recruiter = entityDTO.recruiter;
ctx.Vacancies.InsertOnSubmit(obj);
ctx.SubmitChanges();
return true;
}
catch (Exception)
{
ctx.Dispose();
ctx = new ModelDataContext();
return false;
}
}
