/// <summary>
        /// Set Grid Data source
        /// </summary>
        /// <param name="addRow"></param>
        /// <param name="deleteRow"></param>e
        private void BindGrid(bool addRow, bool deleteRow)
        {
            NeverAttendedSchoolBLL ConcernBLLobj = new NeverAttendedSchoolBLL();

            grdNASchool.DataSource = ConcernBLLobj.GetAllNeverAttendedSchool();
            grdNASchool.DataBind();
        }
        /// <summary>
        /// To update details to database
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private string EditNASchoolDetails()
        {
            string message = string.Empty;
            NeverAttendedSchoolBLL NeverAttendedSchoolBLLObj = new NeverAttendedSchoolBLL();

            try
            {
                NeverAttendedSchoolBO NeverAttendedSchoolBOObj = new NeverAttendedSchoolBO();

                if (ViewState["NVR_ATT_SCH_REASONID"] != null)
                {
                    NeverAttendedSchoolBOObj.NVR_ATT_SCH_REASONID = Convert.ToInt32(ViewState["NVR_ATT_SCH_REASONID"].ToString());
                }

                string uID = Session["USER_ID"].ToString();

                NeverAttendedSchoolBOObj.NVR_ATT_SCH_REASON = NeverAttndSchlTextBox.Text.ToString().Trim();
                NeverAttendedSchoolBOObj.DESCRIPTION        = DescriptionTextBox.Text.ToString().Trim();
                NeverAttendedSchoolBOObj.UpdatedBy          = Convert.ToInt32(uID);

                //BLL.NeverAttendedSchoolBLL NeverAttendedSchoolBLLObj = new BLL.NeverAttendedSchoolBLL();
                message = NeverAttendedSchoolBLLObj.EDITNASCHOOL(NeverAttendedSchoolBOObj);
            }
            catch (Exception ex)
            {
                throw ex;
            }

            finally
            {
                NeverAttendedSchoolBLLObj = null;
            }
            return(message);
        }
        /// <summary>
        /// Update Database Make data as Obsoluted
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void IsObsolete_CheckedChanged(Object sender, EventArgs e)
        {
            string message = string.Empty;

            try
            {
                CheckBox    chk = (CheckBox)sender;
                GridViewRow gr  = (GridViewRow)chk.Parent.Parent;

                string NVR_ATT_SCH_REASONID          = ((Literal)gr.FindControl("litNeverattentedSchoolID")).Text;
                NeverAttendedSchoolBLL ConcernBLLobj = new NeverAttendedSchoolBLL();
                message = ConcernBLLobj.ObsoleteNASchool(Convert.ToInt32(NVR_ATT_SCH_REASONID), Convert.ToString(chk.Checked));
                if (string.IsNullOrEmpty(message) || message == "" || message == "null")
                {
                    message = "Data updated successfully";
                }
                BindGrid(false, true);

                if (message != "")
                {
                    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        ///<summary>
        ///To delete details
        ///</summary>

        private void DeleteNASchoolDetails(int NASchoolID)
        {
            string message = string.Empty;
            NeverAttendedSchoolBLL NeverAttendedSchoolBLLobj = new NeverAttendedSchoolBLL();

            message = NeverAttendedSchoolBLLobj.DeleteNASchoolById(NASchoolID);
            if (string.IsNullOrEmpty(message) || message == "" || message == "null")
            {
                message = "Data Deleted successfully";
            }
            if (message != "")
            {
                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
            }
        }
        ///<summary>
        ///To fetch details
        ///</summary>
        private void GetNASchoolDetails()
        {
            NeverAttendedSchoolBLL NeverAttendedSchoolBLLobj = new NeverAttendedSchoolBLL();
            int NVRATTSCHREASONID = 0;

            if (ViewState["NVR_ATT_SCH_REASONID"] != null)
            {
                NVRATTSCHREASONID = Convert.ToInt32(ViewState["NVR_ATT_SCH_REASONID"]);
            }

            NeverAttendedSchoolBO NeverAttendedSchoolBOObj = new NeverAttendedSchoolBO();

            NeverAttendedSchoolBOObj = NeverAttendedSchoolBLLobj.GetNASchoolById(NVRATTSCHREASONID);

            NeverAttndSchlTextBox.Text = NeverAttendedSchoolBOObj.NVR_ATT_SCH_REASON;
            DescriptionTextBox.Text    = NeverAttendedSchoolBOObj.DESCRIPTION;
            //int ConcernID_test = Convert.ToInt32(ConcernObj.ConcernID);
        }
        /// <summary>
        /// To save details to database
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private string SaveNASchoolDetails()
        {
            string message = string.Empty;

            NeverAttendedSchoolBOObj = new NeverAttendedSchoolBO();

            string NeverAttndSchl = string.Empty;
            string Description    = string.Empty;
            string uID            = Session["USER_ID"].ToString();

            NeverAttndSchl = NeverAttndSchlTextBox.Text.ToString().Trim();
            Description    = DescriptionTextBox.Text.ToString().Trim();

            NeverAttendedSchoolBOObj.NVR_ATT_SCH_REASON = NeverAttndSchl;
            NeverAttendedSchoolBOObj.DESCRIPTION        = Description;
            //NeverAttendedSchoolBOObj.IsDeleted = "false";
            NeverAttendedSchoolBOObj.CreatedBy = Convert.ToInt32(uID);

            NeverAttendedSchoolBLLobj = new NeverAttendedSchoolBLL();     // Data sending to Next layer BAL

            try
            {
                message = NeverAttendedSchoolBLLobj.InsertIntoNeverAttendedSchool(NeverAttendedSchoolBOObj); // Value passing to Next layer
            }
            catch (Exception ee)                                                                             // find the Exception
            {
                throw ee;
            }

            finally     // set the finally class nothing but Empty the object emp_mst_Bal
            {
                NeverAttendedSchoolBLLobj = null;
            }

            return(message);
        }