protected void GVCourseTerms_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            hidSelPaper.Value = string.Empty;
            DataSet DsPapers = new DataSet();

            if (e.CommandName == "SelectCrPrTerm")
            {
                int         index = Convert.ToInt32(e.CommandArgument);
                GridViewRow row   = GVCourseTerms.Rows[index];
                hidFacID.Value         = GVCourseTerms.DataKeys[index]["pkFacID"].ToString();
                hidCrID.Value          = GVCourseTerms.DataKeys[index]["pkCrID"].ToString();
                hidMoLrnID.Value       = GVCourseTerms.DataKeys[index]["pkMoLrnID"].ToString();
                hidPtrnID.Value        = GVCourseTerms.DataKeys[index]["pkPtrnID"].ToString();
                hidBrnID.Value         = GVCourseTerms.DataKeys[index]["pkBrnID"].ToString();
                hidCrPrDetailsID.Value = GVCourseTerms.DataKeys[index]["pkCrPrDetails"].ToString();
                hidCrPrChID.Value      = GVCourseTerms.DataKeys[index]["pkCrPrChID"].ToString();

                DT = clsCollegeAdmissionReports.FetchPaperTLMAMATForSimpleStudentSearch(hidUniID.Value, hidYearID.Value, hidStudentID.Value, hidFacID.Value, hidCrID.Value, hidMoLrnID.Value, hidPtrnID.Value, hidBrnID.Value,
                                                                                        hidCrPrDetailsID.Value, hidCrPrChID.Value);
                if (DT != null && DT.Rows.Count > 0)
                {
                    GVPapersNew.Visible    = true;
                    GVPapersNew.DataSource = DT;
                    GVPapersNew.DataBind();
                    divPapers.Style.Add("display", "block");
                    btnApprove.Attributes.Add("style", "display:block");
                    btnDeny.Attributes.Add("style", "display:block");
                    btnBack.Attributes.Add("style", "display:block");
                    //fill tlm am ats in bulk select checkbox

                    hidSelPaper.Value = hidSelPaper.Value.TrimEnd(',');
                    DT = clsCollegeAdmissionReports.PaperExemptionFetchdistinctTLMAMAT(hidSelPaper.Value);

                    if (DT.Rows.Count > 0)
                    {
                        chkTLMAMAT.DataSource = DT;
                        chkTLMAMAT.DataBind();
                    }
                }
                else
                {
                    GVPapersNew.Visible = false;
                    divPapers.Style.Add("display", "none");
                }
                divCourses.Style.Add("display", "none");
                divSimpleSearch.Style.Add("display", "none");
                divPapers.Style.Add("display", "block");

                lblAcaYear.Text  = " for " + row.Cells[1].Text + " for " + row.Cells[3].Text;
                hidHeading.Value = row.Cells[1].Text + " for " + row.Cells[3].Text;
            }
        }
Пример #2
0
        // Method to refresh both the GridViews after some papers are claimed for exemption
        protected void RefillGridViews()
        {
            DataSet DsPapers = new DataSet();

            // This returns 2 DataTables
            DsPapers = ElgClasses.clsCollegeAdmissionReports.ListCrPrTermwisePapers_ExemptionClaim(hidUniID.Value, hidYearID.Value, hidStudentID.Value, hidpkFacID.Value, hidpkCrID.Value, hidpkMoLrnID.Value, hidpkPtrnID.Value, hidpkBrnID.Value, hidpkCrPrDetails.Value, hidpkCrPrChID.Value);

            //***********************************************************************************
            //filling old claims GV
            DataTable dt = DsPapers.Tables[0];

            if (dt != null && dt.Rows.Count > 0)
            {
                lblGVPapersOldHeading.Visible = true;
                GVPapersOld.DataSource        = dt;
                GVPapersOld.DataBind();
                divPapersOld.Style.Add("display", "block");
            }
            else
            {
                lblGVPapersOldHeading.Visible = false;
                divPapersOld.Style.Add("display", "none");
            }
            //***********************************************************************************

            //filling fresh claim GV
            dt = DsPapers.Tables[1];
            if (dt != null && dt.Rows.Count > 0)
            {
                lblGVPapersNewHeading.Visible = true;
                btnProceed.Visible            = true;

                GVPapersNew.DataSource = dt;
                GVPapersNew.DataBind();
                GVPapersNew.Visible = true;
                divPapersNew.Style.Add("display", "block");
            }
            else
            {
                GVPapersNew.Visible           = false;
                lblGVPapersNewHeading.Visible = false;
                btnProceed.Visible            = false;
                divPapersNew.Style.Add("display", "none");
            }
            //***********************************************************************************
        }
Пример #3
0
        //listing papers for the selected course part term
        protected void GVCourseTerms_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "SelectCrPrTerm")
            {
                /* Call SP for listing papers of selected CrPrTerm here */
                divCourses.Style.Add("display", "none");
                divSimpleSearch.Style.Add("display", "none");
                btnBack.Style.Add("display", "block");
                int         index = Convert.ToInt32(e.CommandArgument);
                GridViewRow row   = GVCourseTerms.Rows[index];
                lblAcaYear.Text        = "for " + row.Cells[1].Text + " for " + row.Cells[3].Text;
                hidHeading.Value       = row.Cells[1].Text + " for " + row.Cells[3].Text;
                hidpkFacID.Value       = GVCourseTerms.DataKeys[index]["pkFacID"].ToString();
                hidpkCrID.Value        = GVCourseTerms.DataKeys[index]["pkCrID"].ToString();
                hidpkMoLrnID.Value     = GVCourseTerms.DataKeys[index]["pkMoLrnID"].ToString();
                hidpkPtrnID.Value      = GVCourseTerms.DataKeys[index]["pkPtrnID"].ToString();
                hidpkBrnID.Value       = GVCourseTerms.DataKeys[index]["pkBrnID"].ToString();
                hidpkCrPrDetails.Value = GVCourseTerms.DataKeys[index]["pkCrPrDetails"].ToString();
                hidpkCrPrChID.Value    = GVCourseTerms.DataKeys[index]["pkCrPrChID"].ToString();
                hidStudentID.Value     = GVCourseTerms.DataKeys[index]["pkStudentID"].ToString();
                hidInstID.Value        = GVCourseTerms.DataKeys[index]["pkInstID"].ToString();
                hidAcademicYear.Value  = GVCourseTerms.DataKeys[index]["fkAcademicYr"].ToString();
                if (GVCourseTerms.DataKeys[index]["fk_ExEv_ID"].ToString().Equals("0") || GVCourseTerms.DataKeys[index]["fk_ExEv_ID"].ToString().Equals("-"))
                {
                    hidExamFormModifyReq.Value = "No";
                }
                else
                {
                    hidExamFormModifyReq.Value = "Yes";
                }

                dt = ElgClasses.clsCollegeAdmissionReports.ListCrPrTermwisePapers_ChangeExemptionDecision(hidUniID.Value, hidYearID.Value, hidStudentID.Value, hidpkFacID.Value, hidpkCrID.Value, hidpkMoLrnID.Value, hidpkPtrnID.Value, hidpkBrnID.Value, hidpkCrPrDetails.Value, hidpkCrPrChID.Value);

                if (dt != null && dt.Rows.Count > 0)
                {
                    GVPapersNew.DataSource = dt;
                    GVPapersNew.DataBind();
                    divPapers.Style.Add("display", "block");
                }
            }
        }
Пример #4
0
        protected void GVCourseTerms_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            //string UniID, YearID, StudentID,pkFacID, pkCrID, pkMoLrnID, pkPtrnID, pkBrnID, pkCrPrDetails, pkCrPrChID;
            DataSet DsPapers = new DataSet();

            if (e.CommandName == "SelectCrPrTerm")
            {
                int         index = Convert.ToInt32(e.CommandArgument);
                GridViewRow row   = GVCourseTerms.Rows[index];
                hidpkFacID.Value       = GVCourseTerms.DataKeys[index]["pkFacID"].ToString();
                hidpkCrID.Value        = GVCourseTerms.DataKeys[index]["pkCrID"].ToString();
                hidpkMoLrnID.Value     = GVCourseTerms.DataKeys[index]["pkMoLrnID"].ToString();
                hidpkPtrnID.Value      = GVCourseTerms.DataKeys[index]["pkPtrnID"].ToString();
                hidpkBrnID.Value       = GVCourseTerms.DataKeys[index]["pkBrnID"].ToString();
                hidpkCrPrDetails.Value = GVCourseTerms.DataKeys[index]["pkCrPrDetails"].ToString();
                hidpkCrPrChID.Value    = GVCourseTerms.DataKeys[index]["pkCrPrChID"].ToString();

                /* Call SP for listing papers of selected CrPrTerm here */
                // This returns 2 DataTables
                DsPapers = ElgClasses.clsCollegeAdmissionReports.ListCrPrTermwisePapers_ExemptionClaim(hidUniID.Value, hidYearID.Value, hidStudentID.Value, hidpkFacID.Value, hidpkCrID.Value, hidpkMoLrnID.Value, hidpkPtrnID.Value, hidpkBrnID.Value, hidpkCrPrDetails.Value, hidpkCrPrChID.Value);

                //***********************************************************************************
                //filling old claims GV
                DataTable dt = DsPapers.Tables[0];
                if (dt != null && dt.Rows.Count > 0)
                {
                    lblGVPapersOldHeading.Visible = true;
                    GVPapersOld.DataSource        = dt;
                    GVPapersOld.DataBind();
                    divPapersOld.Style.Add("display", "block");
                }
                else
                {
                    lblGVPapersOldHeading.Visible = false;
                    divPapersOld.Style.Add("display", "none");
                }
                //***********************************************************************************

                //filling fresh claim GV
                dt = DsPapers.Tables[1];
                if (dt != null && dt.Rows.Count > 0)
                {
                    lblGVPapersNewHeading.Visible = true;
                    btnProceed.Visible            = true;

                    GVPapersNew.Visible    = true;
                    GVPapersNew.DataSource = dt;
                    GVPapersNew.DataBind();
                    divPapersNew.Style.Add("display", "block");
                }
                else
                {
                    GVPapersNew.Visible           = false;
                    lblGVPapersNewHeading.Visible = false;
                    btnProceed.Visible            = false;
                    divPapersNew.Style.Add("display", "none");
                }
                //***********************************************************************************
                divCourses.Style.Add("display", "none");
                divSimpleSearch.Style.Add("display", "none");
                divPapers.Style.Add("display", "block");
                btnBack.Style.Add("display", "block");

                lblAcaYear.Text  = " for " + row.Cells[1].Text + " for " + row.Cells[3].Text;
                hidHeading.Value = row.Cells[1].Text + " for " + row.Cells[3].Text;


                // Prototype coding
                //=======================================
                ////filling old claims GV
                //DataTable dt = new DataTable();
                //dt.Columns.Add("PpPpCode");
                //dt.Columns.Add("Status");
                //dt.Columns.Add("pk_Pp_PpHead_CrPrCh_ID");

                //DataRow dr = dt.NewRow();
                //dr["PpPpCode"] = "English (Compulsory) (15101)";
                //dr["Status"] = "Granted";
                //dr["pk_Pp_PpHead_CrPrCh_ID"] = "1";
                //dt.Rows.Add(dr);

                //dr = dt.NewRow();
                //dr["PpPpCode"] = "Optional Sociology Paper-III (15146) Lectures-Practical-UA";
                //dr["Status"] = "Granted";
                //dr["pk_Pp_PpHead_CrPrCh_ID"] = "2";
                //dt.Rows.Add(dr);

                //dr = dt.NewRow();
                //dr["PpPpCode"] = "Optional Sociology Paper-III (15146) Lectures-Theory-UA";
                //dr["Status"] = "Denied";
                //dr["pk_Pp_PpHead_CrPrCh_ID"] = "2";
                //dt.Rows.Add(dr);

                //dr = dt.NewRow();
                //dr["PpPpCode"] = "Optional Marathi Paper-III (15128) ";
                //dr["pk_Pp_PpHead_CrPrCh_ID"] = "3";
                //dr["Status"] = "Pending";
                //dt.Rows.Add(dr);

                //GVPapersOld.DataSource = dt;
                //GVPapersOld.DataBind();

                ////filling fresh claim GV
                //dt = new DataTable();
                //dt.Columns.Add("PpPpCode");
                //dt.Columns.Add("pk_Pp_PpHead_CrPrCh_ID");

                //dr = dt.NewRow();
                //dr["PpPpCode"] = "Optional Sociology Paper-II (15145)";
                //dr["pk_Pp_PpHead_CrPrCh_ID"] = "4";
                //dt.Rows.Add(dr);

                //dr = dt.NewRow();
                //dr["PpPpCode"] = "Optional Geography Paper-III (15140)";
                //dr["pk_Pp_PpHead_CrPrCh_ID"] = "5";
                //dt.Rows.Add(dr);

                //dr = dt.NewRow();
                //dr["PpPpCode"] = "Optional Sociology Paper-II (15145)";
                //dr["pk_Pp_PpHead_CrPrCh_ID"] = "6";
                //dt.Rows.Add(dr);

                //GVPapersNew.DataSource = dt;
                //GVPapersNew.DataBind();
                //=======================================
            }
        }
Пример #5
0
        protected void btnProceed_Click(object sender, EventArgs e)
        {
            lblNote.Text = string.Empty;

            /* Call SP for changing decision here*/
            string SPXML = string.Empty;
            List <PaperStudXML> oPaperStudXMLList = new List <PaperStudXML>();
            PaperStudXML        oPaperStudXML;

            for (int j = 0; j < GVPapersNew.Rows.Count; j++)
            {
                if (((((RadioButton)GVPapersNew.Rows[j].Cells[2].FindControl("RDBtn_Approve")).Enabled && ((RadioButton)GVPapersNew.Rows[j].Cells[2].FindControl("RDBtn_Approve")).Checked)) || (((RadioButton)GVPapersNew.Rows[j].Cells[3].FindControl("RDBtn_Deny")).Enabled && ((RadioButton)GVPapersNew.Rows[j].Cells[3].FindControl("RDBtn_Deny")).Checked))
                {
                    oPaperStudXML           = new PaperStudXML();
                    oPaperStudXML.UniID     = int.Parse(GVPapersNew.DataKeys[j].Values["pk_Uni_ID"].ToString());
                    oPaperStudXML.Year      = int.Parse(GVPapersNew.DataKeys[j].Values["pk_Year"].ToString());
                    oPaperStudXML.StudentID = int.Parse(GVPapersNew.DataKeys[j].Values["pk_Student_ID"].ToString());
                    oPaperStudXML.TLM       = int.Parse(GVPapersNew.DataKeys[j].Values["TLM-AM-AT-ID"].ToString().Split('-')[0]);
                    oPaperStudXML.AM        = int.Parse(GVPapersNew.DataKeys[j].Values["TLM-AM-AT-ID"].ToString().Split('-')[1]);
                    oPaperStudXML.AT        = int.Parse(GVPapersNew.DataKeys[j].Values["TLM-AM-AT-ID"].ToString().Split('-')[2]);
                    oPaperStudXML.Pk_Pp_PpHead_CrPrCh_ID = int.Parse(GVPapersNew.DataKeys[j].Values["pk_Pp_PpHead_CrPrCh_ID"].ToString());
                    oPaperStudXML.FacID     = int.Parse(GVPapersNew.DataKeys[j].Values["pk_Fac_ID"].ToString());
                    oPaperStudXML.CRID      = int.Parse(GVPapersNew.DataKeys[j].Values["pk_Cr_ID"].ToString());
                    oPaperStudXML.MOLID     = int.Parse(GVPapersNew.DataKeys[j].Values["pk_MoLrn_ID"].ToString());
                    oPaperStudXML.PtrnID    = int.Parse(GVPapersNew.DataKeys[j].Values["pk_Ptrn_ID"].ToString());
                    oPaperStudXML.BrnID     = int.Parse(GVPapersNew.DataKeys[j].Values["pk_Brn_ID"].ToString());
                    oPaperStudXML.CrPrDetID = int.Parse(GVPapersNew.DataKeys[j].Values["pk_CrPr_Details_ID"].ToString());
                    oPaperStudXML.CrPrChtID = int.Parse(GVPapersNew.DataKeys[j].Values["pk_CrPrCh_ID"].ToString());
                    oPaperStudXMLList.Add(oPaperStudXML);
                }
            }

            //set hidden variables
            hidpkFacID.Value       = GVPapersNew.DataKeys[0]["pk_Fac_ID"].ToString();
            hidpkCrID.Value        = GVPapersNew.DataKeys[0]["pk_Cr_ID"].ToString();
            hidpkMoLrnID.Value     = GVPapersNew.DataKeys[0]["pk_MoLrn_ID"].ToString();
            hidpkPtrnID.Value      = GVPapersNew.DataKeys[0]["pk_Ptrn_ID"].ToString();
            hidpkBrnID.Value       = GVPapersNew.DataKeys[0]["pk_Brn_ID"].ToString();
            hidpkCrPrDetails.Value = GVPapersNew.DataKeys[0]["pk_CrPr_Details_ID"].ToString();
            hidpkCrPrChID.Value    = GVPapersNew.DataKeys[0]["pk_CrPrCh_ID"].ToString();
            hidStudentID.Value     = GVPapersNew.DataKeys[0]["pk_Student_ID"].ToString();
            hidAcademicYear.Value  = GVPapersNew.DataKeys[0]["fk_AcademicYear_ID"].ToString();
            hidInstID.Value        = GVPapersNew.DataKeys[0]["Ref_InstReg_Institute_ID"].ToString();
            hidYearID.Value        = GVPapersNew.DataKeys[0]["pk_Year"].ToString();
            hidUniID.Value         = GVPapersNew.DataKeys[0]["pk_Uni_ID"].ToString();

            int result = 0;

            result = clsCollegeAdmissionReports.ChangeExemptionDecisionForSelectedPapers(user.User_ID, PaperStudXML.SerializeObject(oPaperStudXMLList));

            if (result != 0)
            {
                //divMsg.Style.Add("display", "block");
                lblMsg.Text = "The Exemption Approval Decision has been successfully changed for the Selected " + lblPaper.Text + "(s).";

                //send exam for modify request
                Hashtable HT = new Hashtable();
                HT.Add("UniID", hidUniID.Value);
                HT.Add("StudentID", hidStudentID.Value);
                HT.Add("Year", hidYearID.Value);
                HT.Add("InstID", hidInstID.Value);
                HT.Add("FacID", hidpkFacID.Value);
                HT.Add("CrID", hidpkCrID.Value);
                HT.Add("MoLrnID", hidpkMoLrnID.Value);
                HT.Add("PtrnID", hidpkPtrnID.Value);
                HT.Add("BrnID", hidpkBrnID.Value);
                HT.Add("CrPrDetailsID", hidpkCrPrDetails.Value);
                HT.Add("CrPrChID", hidpkCrPrChID.Value);
                HT.Add("AcYrID", hidAcademicYear.Value);
                HT.Add("CreatedBy", user.User_ID.ToString());
                HT.Add("RequestDetails", createExamFormModifyXML());

                if (clsPaperChange.SendExamFormModifyRequest_PaperExemptionApproval(HT).Equals("S")) //successful
                {
                    if (user.UserTypeCode != "2")
                    {
                        lblMsg.Text += "<br>An Exam Form Modify Request has been sent.";
                    }
                    else if (user.UserTypeCode == "2")
                    {
                        lblMsg.Text += "<br>An Exam Form Modify Request has been sent.";
                    }
                }

                else
                {
                    lblMsg.Text += "<br>An Exam Form Modify Request could not be sent.";
                }

                #region commented old code
                //***********************************************
                //if (hidExamFormModifyReq.Value.Equals("Yes"))
                //{
                //    Hashtable HT = new Hashtable();
                //    HT.Add("UniID", hidUniID.Value);
                //    HT.Add("InstID", hidInstID.Value);
                //    HT.Add("FacID", hidpkFacID.Value);
                //    HT.Add("CrID", hidpkCrID.Value);
                //    HT.Add("MoLrnID", hidpkMoLrnID.Value);
                //    HT.Add("PtrnID", hidpkPtrnID.Value);
                //    HT.Add("BrnID", hidpkBrnID.Value);
                //    HT.Add("CrPrDetailsID", hidpkCrPrDetails.Value);
                //    HT.Add("CrPrChID", hidpkCrPrChID.Value);
                //    HT.Add("AcYrID", hidAcademicYear.Value);
                //    HT.Add("CreatedBy", user.User_ID.ToString());
                //    HT.Add("RequestDetails", "'" + createExamFormModifyXML() + "'");

                //    string status = clsPaperChange.SendExamFormModifyRequest(HT);

                //    if (status.Equals("S")) //successful
                //    {
                //        if (user.UserTypeCode != "2")
                //        {
                //            lblMsg.Text += "<br>An Exam Form Modify Request has been sent.";
                //        }
                //        else if (user.UserTypeCode == "2")
                //        {
                //            lblMsg.Text += "<br>An Exam Form Modify Request has been sent.";
                //        }
                //    }

                //    else
                //    {
                //        lblMsg.Text += "<br>An Exam Form Modify Request could not be sent.";
                //    }

                //}
                //********************************************
                #endregion

                //refill grid view
                dt = ElgClasses.clsCollegeAdmissionReports.ListCrPrTermwisePapers_ChangeExemptionDecision(hidUniID.Value, hidYearID.Value, hidStudentID.Value, hidpkFacID.Value, hidpkCrID.Value, hidpkMoLrnID.Value, hidpkPtrnID.Value, hidpkBrnID.Value, hidpkCrPrDetails.Value, hidpkCrPrChID.Value);

                if (dt.Rows.Count > 0)
                {
                    GVPapersNew.DataSource = dt;
                    GVPapersNew.DataBind();
                }
                else
                {
                    tblExportedDataMsg.Style.Add("display", "block");
                    lblExportedData.Text = "No Record(s) found.";
                }
            }

            else
            {
                //divMsg.Style.Add("display", "block");
                lblMsg.Text = "An error has occurred. Please try again later.";
            }

            if (oPaperStudXMLList != null)
            {
                oPaperStudXMLList = null;
            }
            lblMsg.Style.Add("display", "block");
        }
        protected void btnApproveOrDeny_Click(object sender, EventArgs e)
        {
            string SPXML = string.Empty;
            List <PaperStudXML> oPaperStudXMLList = new List <PaperStudXML>();
            PaperStudXML        oPaperStudXML;

            for (int j = 0; j < GVPapersNew.Rows.Count; j++)
            {
                if (((CheckBox)GVPapersNew.Rows[j].Cells[2].FindControl("chkSelectStudents")).Checked)
                {
                    oPaperStudXML           = new PaperStudXML();
                    oPaperStudXML.StudentID = int.Parse(GVPapersNew.DataKeys[j].Values["pk_Student_ID"].ToString());
                    oPaperStudXML.Year      = int.Parse(GVPapersNew.DataKeys[j].Values["pk_Year"].ToString());
                    oPaperStudXML.TLM       = int.Parse(GVPapersNew.DataKeys[j].Values["TLM-AM-AT-ID"].ToString().Split('-')[0]);
                    oPaperStudXML.AM        = int.Parse(GVPapersNew.DataKeys[j].Values["TLM-AM-AT-ID"].ToString().Split('-')[1]);
                    oPaperStudXML.AT        = int.Parse(GVPapersNew.DataKeys[j].Values["TLM-AM-AT-ID"].ToString().Split('-')[2]);
                    oPaperStudXML.Pk_Pp_PpHead_CrPrCh_ID = int.Parse(GVPapersNew.DataKeys[j].Values["pk_Pp_PpHead_CrPrCh_ID"].ToString());
                    oPaperStudXML.FacID     = int.Parse(GVPapersNew.DataKeys[j].Values["pk_Fac_ID"].ToString());
                    oPaperStudXML.CRID      = int.Parse(GVPapersNew.DataKeys[j].Values["pk_Cr_ID"].ToString());
                    oPaperStudXML.MOLID     = int.Parse(GVPapersNew.DataKeys[j].Values["pk_MoLrn_ID"].ToString());
                    oPaperStudXML.PtrnID    = int.Parse(GVPapersNew.DataKeys[j].Values["pk_Ptrn_ID"].ToString());
                    oPaperStudXML.BrnID     = int.Parse(GVPapersNew.DataKeys[j].Values["pk_Brn_ID"].ToString());
                    oPaperStudXML.CrPrDetID = int.Parse(GVPapersNew.DataKeys[j].Values["pk_CrPr_Details_ID"].ToString());
                    oPaperStudXML.CrPrChtID = int.Parse(GVPapersNew.DataKeys[j].Values["pk_CrPrCh_ID"].ToString());
                    oPaperStudXML.UniID     = int.Parse(GVPapersNew.DataKeys[j].Values["pk_Uni_ID"].ToString());
                    oPaperStudXMLList.Add(oPaperStudXML);
                }
            }

            //set hidden variables
            hidFacID.Value             = GVPapersNew.DataKeys[0]["pk_Fac_ID"].ToString();
            hidCrID.Value              = GVPapersNew.DataKeys[0]["pk_Cr_ID"].ToString();
            hidMoLrnID.Value           = GVPapersNew.DataKeys[0]["pk_MoLrn_ID"].ToString();
            hidPtrnID.Value            = GVPapersNew.DataKeys[0]["pk_Ptrn_ID"].ToString();
            hidBrnID.Value             = GVPapersNew.DataKeys[0]["pk_Brn_ID"].ToString();
            hidCrPrDetailsID.Value     = GVPapersNew.DataKeys[0]["pk_CrPr_Details_ID"].ToString();
            hidCrPrChID.Value          = GVPapersNew.DataKeys[0]["pk_CrPrCh_ID"].ToString();
            hidStudentID.Value         = GVPapersNew.DataKeys[0]["pk_Student_ID"].ToString();
            hid_fk_AcademicYr_ID.Value = GVPapersNew.DataKeys[0]["fk_AcademicYear_ID"].ToString();
            hidInstID.Value            = GVPapersNew.DataKeys[0]["Ref_InstReg_Institute_ID"].ToString();
            hidYearID.Value            = GVPapersNew.DataKeys[0]["pk_Year"].ToString();
            hidUniID.Value             = GVPapersNew.DataKeys[0]["pk_Uni_ID"].ToString();


            //******************************
            //if (GVPapersNew.DataKeys[0]["fk_ExEv_ID"].ToString().Equals("0") || GVPapersNew.DataKeys[0]["fk_ExEv_ID"].ToString().Equals("-"))
            //{
            //    hidExamFormModifyReq.Value = "No";
            //}
            //else
            //{
            //    hidExamFormModifyReq.Value = "Yes";
            //}
            //******************************

            int    result = 0;
            string status = string.Empty;

            if (((Button)sender).ID == "btnApprove")
            {
                result = clsCollegeAdmissionReports.PaperExemptionApproveOrDeny(user.User_ID, 1, PaperStudXML.SerializeObject(oPaperStudXMLList));
                status = "Granted";
            }
            else if (((Button)sender).ID == "btnDeny")
            {
                result = clsCollegeAdmissionReports.PaperExemptionApproveOrDeny(user.User_ID, 2, PaperStudXML.SerializeObject(oPaperStudXMLList));
                status = "Denied";
            }
            if (result != 0)
            {
                divMsg.Style.Add("display", "block");

                lblAppOrDenyMsg.Text = "The Exemption claimed is " + status + " successfully for the selected " + lblPaper.Text + "(s).";

                //send exam for modify request

                //if (hidExamFormModifyReq.Value.Equals("Yes"))
                //{
                Hashtable HT = new Hashtable();
                HT.Add("UniID", hidUniID.Value);
                HT.Add("StudentID", hidStudentID.Value);
                HT.Add("Year", hidYearID.Value);
                HT.Add("InstID", hidInstID.Value);
                HT.Add("FacID", hidFacID.Value);
                HT.Add("CrID", hidCrID.Value);
                HT.Add("MoLrnID", hidMoLrnID.Value);
                HT.Add("PtrnID", hidPtrnID.Value);
                HT.Add("BrnID", hidBrnID.Value);
                HT.Add("CrPrDetailsID", hidCrPrDetailsID.Value);
                HT.Add("CrPrChID", hidCrPrChID.Value);
                HT.Add("AcYrID", hid_fk_AcademicYr_ID.Value);
                HT.Add("CreatedBy", user.User_ID.ToString());
                HT.Add("RequestDetails", createExamFormModifyXML());

                if (clsPaperChange.SendExamFormModifyRequest_PaperExemptionApproval(HT).Equals("S"))     //successful
                {
                    //if (user.UserTypeCode != "2")
                    //{
                    //    lblAppOrDenyMsg.Text += "<br>An Exam Form Modify Request has been sent.";
                    //}
                    //else if (user.UserTypeCode == "2")
                    //{
                    //    lblAppOrDenyMsg.Text += "<br>An Exam Form Modify Request has been sent.";
                    //}

                    lblAppOrDenyMsg.Text += "<br>An Exam Form Modify Request has been sent.";
                }

                else
                {
                    lblAppOrDenyMsg.Text += "<br>An Exam Form Modify Request could not be sent.";
                }
                //}

                //refill grid view
                DT = clsCollegeAdmissionReports.FetchPaperTLMAMATForSimpleStudentSearch(hidUniID.Value, hidYearID.Value, hidStudentID.Value, hidFacID.Value, hidCrID.Value, hidMoLrnID.Value, hidPtrnID.Value, hidBrnID.Value,
                                                                                        hidCrPrDetailsID.Value, hidCrPrChID.Value);
                if (DT.Rows.Count > 0)
                {
                    GVPapersNew.DataSource = DT;
                    GVPapersNew.DataBind();

                    chkTLMAMAT.ClearSelection();
                }
                else
                {
                    btnApprove.Style.Add("display", "none");
                    btnDeny.Style.Add("display", "none");
                    divTLMAMATChoice.Style.Add("display", "none");
                    divPapers.Style.Add("display", "none");
                    //tblExportedDataMsg.Style.Add("display", "block");
                    //lblExportedData.Text = "No Record(s) found.";
                }
            }
            else
            {
                divMsg.Style.Add("display", "block");
                lblAppOrDenyMsg.Text = "An error has occurred. Please try again later.";
            }

            if (oPaperStudXMLList != null)
            {
                oPaperStudXMLList = null;
            }
        }