private void btnupdate_Click(object sender, RoutedEventArgs e)
        {
            EmployeeDataContext dbc = new EmployeeDataContext();
            Employee            e1  = dbc.Employees.SingleOrDefault(emp => emp.EmpNo == Convert.ToInt32(txtEmpId.Text));

            if (e1 != null)
            {
                try
                {
                    e1.EmpName = txtEmpName.Text.ToString();
                    e1.Basic   = Convert.ToDouble(txtBasic.Text);
                    e1.DeptNo  = Convert.ToInt32(txtDeptNo.Text);

                    dbc.SubmitChanges();

                    MessageBox.Show("Done");
                }
                catch (Exception Ex)
                {
                    MessageBox.Show(Ex.Message);
                }
            }
            else
            {
                MessageBox.Show("Employee not Present");
            }
        }
        private void btnInsert_Click(object sender, RoutedEventArgs e)
        {
            EmployeeDataContext dbc = new EmployeeDataContext();
            Employee            e1  = new Employee();

            try
            {
                e1.EmpNo   = Convert.ToInt32(txtEmpId.Text);
                e1.EmpName = txtEmpName.Text.ToString();
                e1.Basic   = Convert.ToDouble(txtBasic.Text);
                e1.DeptNo  = Convert.ToInt32(txtDeptNo.Text);

                dbc.Employees.InsertOnSubmit(e1);
                dbc.SubmitChanges();

                MessageBox.Show("Done");
            }
            catch
            {
            }
        }
        private void btnDelete_Click(object sender, RoutedEventArgs e)
        {
            EmployeeDataContext dbc = new EmployeeDataContext();
            Employee            e1  = dbc.Employees.SingleOrDefault(emp => emp.EmpNo == Convert.ToInt32(txtEmpId.Text));

            if (e1 != null)
            {
                try
                {
                    dbc.Employees.DeleteOnSubmit(e1);
                    dbc.SubmitChanges();

                    MessageBox.Show("Done");
                }
                catch (Exception Ex)
                {
                    MessageBox.Show(Ex.Message);
                }
            }
            else
            {
                MessageBox.Show("Employee not Present");
            }
        }