Esempio n. 1
0
        private void alterEmployee_Click(object sender, EventArgs e)
        {
            int    row = mainDataGridView.CurrentCell.RowIndex;
            string ID  = mainDataGridView["ID", row].Value.ToString();

            AlterEmployee alterEmployee = new AlterEmployee(nameTextBox,
                                                            departmentTextBox,
                                                            cathedraTextBox,
                                                            emailTextBox,
                                                            degreeTextBox,
                                                            ratingTextBox,
                                                            yearTextBox,
                                                            indexOfEmployeeVisualization,
                                                            mainDataGridView,
                                                            ctx);
            bool r = false;

            alterEmployee.Change(ref r);
            if (r)
            {
                try
                {
                    ctx.SaveChanges();
                }
                catch (Exception except)
                {
                    if (except is System.Data.Entity.Infrastructure.DbUpdateException ||
                        except is System.Data.Entity.Infrastructure.DbUpdateConcurrencyException ||
                        except is System.Data.Entity.Validation.DbEntityValidationException)
                    {
                        MessageBox.Show("Проблеми під час комунікації з БД");
                        return;
                    }
                }

                mainDataGridView.DataSource = GetMainDGVBindingSource();
            }
            else
            {
                var lst = ctx.ChangeTracker.Entries().Where(x => x.State != EntityState.Unchanged).ToList();
                foreach (var entry in lst)
                {
                    switch (entry.State)
                    {
                    case EntityState.Modified:
                        entry.CurrentValues.SetValues(entry.OriginalValues);
                        entry.State = EntityState.Unchanged;
                        break;

                    case EntityState.Added:
                        entry.State = EntityState.Detached;
                        break;

                    case EntityState.Deleted:
                        entry.State = EntityState.Unchanged;
                        break;
                    }
                }
            }
        }
Esempio n. 2
0
        private void changePhotoBtn_Click(object sender, EventArgs e)
        {
            AlterEmployee  alterEmployee = new AlterEmployee(indexOfEmployeeVisualization, ctx);
            OpenFileDialog ofd           = new OpenFileDialog();

            ofd.Filter = "Image Files(*.BMP;*.JPG;*.GIF;*.PNG)|*.BMP;*.JPG;*.GIF;*.PNG";
            if (ofd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                employeePhotoPB.Image = Image.FromFile(ofd.FileName);
            }

            alterEmployee.ChangePhoto(employeePhotoPB);
        }