Пример #1
0
        // Добавление записи о сотруднике
        private void addEmployeeButton_Click(object sender, EventArgs e)
        {
            Empoyee empoyee = new Empoyee();

            empoyee.FirstName   = txtFirstName.Text.Trim();
            empoyee.SurName     = txtSurname.Text.Trim();
            empoyee.Patronymic  = txtPatronymic.Text.Trim();
            empoyee.DateOfBirth = dateOfBirthPicker.Value;
            empoyee.DocSeries   = txtSeries.Text.Trim();
            empoyee.DocNumber   = txtNumber.Text.Trim();
            empoyee.Position    = txtPosition.Text.Trim();

            foreach (Department d in context.Department)
            {
                if (d.Name == departmentComboBox.SelectedItem.ToString())
                {
                    empoyee.DepartmentID = d.ID;
                }
            }

            context.Empoyee.Add(empoyee);
            context.SaveChanges();

            ClearTextEmployees();
            UpdateEmployees();
        }
Пример #2
0
        // Получение данных об удаляемой записи о сотруднике
        private void employeeDataGridView_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            if (employeeDataGridView.CurrentRow.Index != -1)
            {
                deleting_employee.ID = (decimal)employeeDataGridView.CurrentRow.Cells["EID"].Value;

                using (TestDBEntities tdb = new TestDBEntities())
                {
                    deleting_employee = tdb.Empoyee.Where(x => x.ID == deleting_employee.ID).FirstOrDefault();
                }

                deleteEmployeeButton.Enabled = true;
            }
        }
Пример #3
0
        // Получение данных о редактируемой записи об сотруднике
        private void employeeDataGridView_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (employeeDataGridView.CurrentRow.Index != -1)
            {
                updating_employee.ID = (decimal)employeeDataGridView.CurrentRow.Cells["EID"].Value;

                using (TestDBEntities tdb = new TestDBEntities())
                {
                    updating_employee = tdb.Empoyee.Where(x => x.ID == updating_employee.ID).FirstOrDefault();

                    txtFirstName.Text       = updating_employee.FirstName;
                    txtSurname.Text         = updating_employee.SurName;
                    txtPatronymic.Text      = updating_employee.Patronymic;
                    dateOfBirthPicker.Value = updating_employee.DateOfBirth;
                    txtSeries.Text          = updating_employee.DocSeries;
                    txtNumber.Text          = updating_employee.DocNumber;
                    txtPosition.Text        = updating_employee.Position;
                }
            }
        }