protected void btnFinalShowVac_Click(object sender, EventArgs e)
    {
        if (DateTime.Parse(dateStart0.Text) > DateTime.Parse(DateEnd0.Text))
        {
            lblInvalidInput.Visible = true;
            lblInvalidInput.Text = "End date can not be before start date.";

            //Empty DropDown
            DropDownListFinalResult.ClearSelection();
            secondPhasePanel.Visible = false;
        }

        startedDate = dateStart0.Text.Trim();
        endedDate = DateEnd0.Text.Trim();

        VacancyRegistrationAndEvaluationManager manager = new VacancyRegistrationAndEvaluationManager();
        TransactionResponse response = new TransactionResponse();
        response = manager.getVacancyToGenerateReportByDateInterval(startedDate, endedDate, DbAccessConstants.spGetFinalPhaseVacancyByDateInterval);

        DataTable vacancyDetail = (DataTable)response.Data;

        DropDownListFinalResult.Items.Clear();
        DropDownListFinalResult.Items.Add(new ListItem(" -- SELECT VACANCY --", "-1"));

        if (vacancyDetail != null && vacancyDetail.Rows.Count > 0)
        {
            clearmsgPanel();
            secondPhasePanel.Visible = true;

            DropDownListFinalResult.DataSource = vacancyDetail;
            DropDownListFinalResult.DataValueField = "vacancy_detail_value";
            DropDownListFinalResult.DataTextField = "vacancy_detail";
            DropDownListFinalResult.DataBind();
        }
        else
        {
            selectedVacancyPanel.Visible = false;

            msgPanel.Visible = true;
            InfoDIV.Visible = true;
            lblInformationMsg.Text = "There is no final phase result bewteen the selected date interval";
            DropDownListFinalResult.ClearSelection();
        }
    }