public void UpdateVacancy(Vacancy vac)
        {
            int empid = query.getCompanyId(vac.Company);

            query.UpdateVacancyQuery(vac.JobTitle, empid, vac.Recruiter.UserId, vac.Location, vac.PostedTime, vac.DeadLine, vac.MinimumSalary, vac.MaximumSalary, vac.JobType, vac.JobSummary, vac.getJobId());

            //Delete previous skills
            query.deleteSkillForJob(vac.JobId);
            //Add New skills
            foreach (string s in vac.skillList)
            {
                query.addSkillListForJob(vac.JobId, searchQuery.getSkillIdByName(s));
            }
        }