private void LoadMissionandAboutus()
 {
     try
     {
         _obj_SMHR_MISSION_ABOUTUS = new SMHR_MISSION_ABOUTUS();
         _obj_SMHR_MISSION_ABOUTUS.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
         _obj_SMHR_MISSION_ABOUTUS.OPERATION       = operation.Select;
         DataTable dt = BLL.get_MISSION_ABOUTUS(_obj_SMHR_MISSION_ABOUTUS);
         if (dt.Rows.Count > 0)
         {
             foreach (DataRow dr in dt.Rows)
             {
                 if (Convert.ToBoolean(dr["MISSION_ABOUTUS_ISASSEMBLY"]))
                 {
                     lblAssemblyMission.Text = dr["MISSION_ABOUTUS_MISSIONDESC"].ToString();
                     lblAssemblyAboutUs.Text = dr["MISSION_ABOUTUS_ABOUTUSDESC"].ToString();
                 }
                 else
                 {
                     lblSenateMission.Text = dr["MISSION_ABOUTUS_MISSIONDESC"].ToString();
                     lblSenateAboutUs.Text = dr["MISSION_ABOUTUS_ABOUTUSDESC"].ToString();
                 }
             }
         }
     }
     catch (Exception ex)
     {
         SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Mission_AboutUs", ex.StackTrace, DateTime.Now);
         Response.Redirect("~/Frm_ErrorPage.aspx");
     }
 }
    public void btnSenate_Save_Click(object sender, EventArgs e)
    {
        try
        {
            _obj_SMHR_MISSION_ABOUTUS = new SMHR_MISSION_ABOUTUS();
            _obj_SMHR_MISSION_ABOUTUS.MISSION_ABOUTUS_ISASSEMBLY      = false;
            _obj_SMHR_MISSION_ABOUTUS.MISSION_ABOUTUS_ABOUTUSDESC     = BLL.ReplaceQuote(rtxtSenateAboutUs.Text);
            _obj_SMHR_MISSION_ABOUTUS.MISSION_ABOUTUS_MISSIONDESC     = BLL.ReplaceQuote(rtxtSenateMission.Text);
            _obj_SMHR_MISSION_ABOUTUS.MISSION_ABOUTUS_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);

            _obj_SMHR_MISSION_ABOUTUS.CREATEDBY   = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
            _obj_SMHR_MISSION_ABOUTUS.CREATEDDATE = DateTime.Now;

            _obj_SMHR_MISSION_ABOUTUS.LASTMDFBY   = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
            _obj_SMHR_MISSION_ABOUTUS.LASTMDFDATE = DateTime.Now;

            switch (((Button)sender).ID.ToUpper())
            {
            case "BTNSENATE_UPDATE":
                _obj_SMHR_MISSION_ABOUTUS.MISSION_ABOUTUS_ID = Convert.ToInt32(hdnSenateMissionID.Value);
                _obj_SMHR_MISSION_ABOUTUS.OPERATION          = operation.Update;
                if (BLL.set_MISSION_ABOUTUS(_obj_SMHR_MISSION_ABOUTUS))
                {
                    BLL.ShowMessage(this, "Information Updated Successfully");
                }
                else
                {
                    BLL.ShowMessage(this, "Information Not Updated");
                }

                break;

            case "BTNSENATE_SAVE":
                _obj_SMHR_MISSION_ABOUTUS.OPERATION = operation.Insert;
                if (BLL.set_MISSION_ABOUTUS(_obj_SMHR_MISSION_ABOUTUS))
                {
                    BLL.ShowMessage(this, "Information Saved Successfully");
                    LoadMissionandAboutus();
                }
                else
                {
                    BLL.ShowMessage(this, "Information Not Saved");
                }
                break;

            default:
                break;
            }
        }
        catch (Exception ex)
        {
            SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_MissionAboutUs", ex.StackTrace, DateTime.Now);
            Response.Redirect("~/Frm_ErrorPage.aspx");
        }
    }