private void SaveEducationalBG()
        {
            t_EmpEducationalBackground educ = new t_EmpEducationalBackground();

            educ.EmpID               = NewEmpID;
            educ.ElementarySchool    = ElementarySchool.Text;
            educ.ElementaryAddress   = ElementaryAddress.Text;
            educ.ElementaryYear      = ElementaryYear.Text;
            educ.SecondarySchool     = SecondarySchool.Text;
            educ.SecondaryAddress    = SecondaryAddress.Text;
            educ.SecondaryYear       = SecondaryYear.Text;
            educ.TertiarySchool      = TertiarySchool.Text;
            educ.TertiaryAddress     = TertiaryAddress.Text;
            educ.TertiaryCourse      = TertiaryCourse.Text;
            educ.TertiaryYear        = TertiaryYear.Text;
            educ.VocationalSchool    = VocationalSchool.Text;
            educ.VocationalCourse    = VocationalCourse.Text;
            educ.VocationalAddress   = VocationalAddress.Text;
            educ.VocationalYear      = VocationalYear.Text;
            educ.PostGraduateSchool  = PostGraduatedSchool.Text;
            educ.PostGraduateCourse  = PostGraduatedCourse.Text;
            educ.PostGraduateAddress = PostGraduatedAddress.Text;
            educ.PostGraduateYear    = PostGraduatedYear.Text;
            educ.IsLicensed          = Convert.ToBoolean(IsLicensed.IsChecked);
            educ.LastUpdate          = DateTime.Now;

            db.t_EmpEducationalBackground.Add(educ);
            db.SaveChanges();
        }
        public void getEmployeeEBG()
        {
            //t_EmpEducationalBackground educ = new t_EmpEducationalBackground();
            var selectQuery = db.t_EmpEducationalBackground.Where(x => x.EmpID == EmpID.Text);

            foreach (var item in selectQuery)
            {
                t_EmpEducationalBackground myData = item as t_EmpEducationalBackground;
                ElementarySchool.Text  = myData.ElementarySchool;
                ElementaryAddress.Text = myData.ElementaryAddress;

                ElementaryYear.Text   = myData.ElementaryYear;
                SecondarySchool.Text  = myData.SecondarySchool;
                SecondaryAddress.Text = myData.SecondaryAddress;
                SecondaryYear.Text    = myData.SecondaryYear;
                TertiarySchool.Text   = myData.TertiarySchool;
                TertiaryAddress.Text  = myData.TertiaryAddress;
                TertiaryCourse.Text   = myData.TertiaryCourse;
                TertiaryYear.Text     = myData.TertiaryYear;

                VocationalSchool.Text  = myData.VocationalSchool;
                VocationalAddress.Text = myData.VocationalAddress;
                VocationalCourse.Text  = myData.VocationalCourse;
                VocationalYear.Text    = myData.VocationalYear;

                PostGraduateSchool.Text  = myData.PostGraduateSchool;
                PostGraduateAddress.Text = myData.PostGraduateAddress;
                PostGraduateCourse.Text  = myData.PostGraduateCourse;
                IsLicensed.IsChecked     = Convert.ToBoolean(myData.IsLicensed);
                PostGraduateYear.Text    = myData.PostGraduateYear;
            }
        }