protected void passAppGVform1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        clearMsgPanel();
        int index = passAppGVform1.EditIndex;
        GridViewRow row = passAppGVform1.Rows[index];

        Label EmpID = (Label)row.FindControl("lblEmpID");
        TextBox txtMarkEdu = (TextBox)row.FindControl("txtMarkEdu");
        TextBox txtGenWorExp = (TextBox)row.FindControl("txtGenWorExp");
        TextBox txtSpecWorExp = (TextBox)row.FindControl("txtSpecWorExp");
        TextBox txtMgrRec = (TextBox)row.FindControl("txtMgrRec");
        TextBox txtInterRes = (TextBox)row.FindControl("txtInterRes");
        DropDownList DropDRemark = (DropDownList)row.FindControl("DropDRemark");
        DropDownList DropDStatus = (DropDownList)row.FindControl("DropDStatus");

        double markEdu = 0;
        double genWorkExp = 0;
        double specWorkExp = 0;
        double mgrRec = 0;
        double? interviewres = null;
        
        try
        {
            markEdu = Convert.ToDouble(txtMarkEdu.Text.Trim());
            genWorkExp = Convert.ToDouble(txtGenWorExp.Text.Trim());
            specWorkExp = Convert.ToDouble(txtSpecWorExp.Text.Trim());
            mgrRec = Convert.ToDouble(txtMgrRec.Text.Trim());

            if (txtInterRes.Text.Trim() != "")
            {
                interviewres = Convert.ToDouble(txtInterRes.Text.Trim());
            }
        }
        catch (FormatException)
        {
            clearMsgPanel();
            msgPanel.Visible = true;
            ErroroDIV.Visible = true;
            lblErrorMsg.Text = "Invalid value inserted.";
            return;
        }
        catch (Exception ex)
        {
            clearMsgPanel();
            msgPanel.Visible = true;
            ErroroDIV.Visible = true;
            lblErrorMsg.Text = ex.StackTrace;
            return;
        }

        VacancyEvaluationForm vacancyEvaluationForm = new VacancyEvaluationForm();

        vacancyEvaluationForm.EmpId = EmpID.Text.Trim();
        vacancyEvaluationForm.EducationLevelMark = markEdu.ToString();
        vacancyEvaluationForm.GeneralWorkExpr = genWorkExp.ToString();
        vacancyEvaluationForm.SpecificWorkRxpr = specWorkExp.ToString();
        vacancyEvaluationForm.RecommendationOfMgrLine = mgrRec.ToString();
        if (txtInterRes.Text.Trim() == "")
        {
            vacancyEvaluationForm.InterviewResult = "";
        }
        else
        {
            vacancyEvaluationForm.InterviewResult = interviewres.ToString();
        }
        vacancyEvaluationForm.Remark = DropDRemark.SelectedValue.Trim();
        vacancyEvaluationForm.ApplicantStatus = DropDStatus.SelectedValue.Trim();

        Vacancy vacancy = getSelectedVacancy(DropDPassVac);

        DateTime datTime = Convert.ToDateTime(vacancy.PostedDate);

        EmployeeManager applicantManager = new EmployeeManager();

        applicantManager.UpdateApplicantResult(vacancyEvaluationForm, vacancy);
        passAppGVform1.EditIndex = -1;

        TransactionResponse response = getAppResult(getSelectedVacancy(DropDPassVac));
        DataTable dataTable = (DataTable)response.Data;
        passAppGVform1.DataSource = dataTable;
        passAppGVform1.DataBind();
    }