protected void btnSaveExperienceInfo_Click(object sender, EventArgs e)
        {
            try
            {
                HRM_Experiences experiences = new HRM_Experiences();

                experiences.EID = Convert.ToString(Session["EID"]);
                experiences.Experience_Company           = txtCompanyName.Text;
                experiences.Experience_CompanyLocation   = txtCompanyLocation.Text;
                experiences.Experience_CompanyBussiness  = txtCompanyBussiness.Text;
                experiences.Experience_CompanyDepartment = txtWorkingDepartment.Text;
                experiences.Experience_Duration          = txtDuration.Text.Trim();
                experiences.Experience_PositionHeld      = txtPositionHeld.Text.Trim();
                experiences.Experience_AreaOfExperience  = txtAreaOfExperience.Text.Trim();
                experiences.EExperience_Responsibilites  = txtResponsibilities.Text.Trim();
                experiences.EDIT_DATE = DateTime.Now;
                experiences.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
                experiences.OCODE     = ((SessionUser)Session["SessionUser"]).OCode;
                int result = employeeSetupDal.InsertEmpExperiences(experiences);
                if (result == 1)
                {
                    //lblMessage.Text = "Data Save Successfully";
                    ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Save successfully!')", true);
                    getExperienceInfo();
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }

            ClearExperienceInformationField();
        }
 internal HRM_Experiences GetAExprenceByExpericenceId(string exId, string OCODE)
 {
     try
     {
         int             exid  = Convert.ToInt32(exId);
         HRM_Experiences objex = _context.HRM_Experiences.First(x => x.ExperienceId == exid);
         return(objex);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 internal int DeleteexprienceIdandOcode(string exId, string OCODE)
 {
     try
     {
         int             eId   = Convert.ToInt32(exId);
         HRM_Experiences objex = _context.HRM_Experiences.First(x => x.ExperienceId == eId);
         _context.HRM_Experiences.DeleteObject(objex);
         _context.SaveChanges();
         return(1);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
        protected void btnAdd_click(object sender, EventArgs e)
        {
            HRM_Experiences objexpericence = new HRM_Experiences();
            string          employeid      = objexpericence.EID = Convert.ToString(Session["EID"]);

            objexpericence.Experience_Company           = txtbxCompanyName.Text;
            objexpericence.Experience_CompanyBussiness  = txtbxBusiness.Text;
            objexpericence.Experience_CompanyLocation   = txtbxCompanyLocation.Text;
            objexpericence.Experience_CompanyDepartment = txtbxWorkingLoction.Text;
            objexpericence.Experience_PositionHeld      = txtbxPostionHeld.Text;
            objexpericence.Experience_AreaOfExperience  = txtbxExpericenceArea.Text;
            objexpericence.EExperience_Responsibilites  = txtbxResposibities.Text;
            objexpericence.Experience_Duration          = txtbxDuration.Text;
            if (btnAdd.Text == "Submit")
            {
                ClearExperience();
                objexpericence.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
                objexpericence.EDIT_DATE = DateTime.Now;
                objexpericence.OCODE     = ((SessionUser)Session["SessionUser"]).OCode;

                int result = employeeSetupDal.InsertEmpExperiences(objexpericence);
                if (result == 1)
                {
                    lblModalMessage.Text = "Data Save Successfully";
                    getExperienceInfo();
                }
            }
            else
            {
                int exId   = Convert.ToInt32(ExperienceId.Value);
                int result = employeeSetupDal.UpdateExperienceEdit(exId, objexpericence);
                if (result == 1)
                {
                    lblModalMessage.Text = "Data Update Successfully";
                    getExperienceInfo();
                }
            }
        }
        protected void btnexperienceEdit_Click(object sender, EventArgs e)
        {
            Button      imgbtn = (Button)sender;
            GridViewRow row    = (GridViewRow)imgbtn.NamingContainer;

            try
            {
                string exId    = "";
                Label  lblexId = (Label)grdExpericencesInfo.Rows[row.RowIndex].FindControl("lblExpericenceId");
                if (lblexId != null)
                {
                    string OCODE = ((SessionUser)Session["SessionUser"]).OCode;
                    exId = lblexId.Text;
                    //int result = experienceBll.DeleteexprienceIdandOcode(exId, OCODE);
                    HRM_Experiences expericence = experienceBll.GetAExprenceByExpericenceId(exId, OCODE);
                    ExperienceId.Value        = exId;
                    txtbxCompanyName.Text     = expericence.Experience_Company;
                    txtbxBusiness.Text        = expericence.Experience_CompanyBussiness;
                    txtbxCompanyLocation.Text = expericence.Experience_CompanyLocation;
                    txtbxWorkingLoction.Text  = expericence.Experience_CompanyDepartment;
                    txtbxPostionHeld.Text     = expericence.Experience_PositionHeld;
                    txtbxExpericenceArea.Text = expericence.Experience_AreaOfExperience;
                    txtbxResposibities.Text   = expericence.EExperience_Responsibilites;
                    txtbxDuration.Text        = expericence.Experience_Duration;
                }

                btnedit.Visible = true;
                btnAdd.Visible  = true;
                btnAdd.Text     = "Update";
                ModalPopupExtender.Show();
            }
            catch (Exception ex)
            {
                throw;
            }
        }