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