Exemple #1
0
        private void AddMenuItem_Click(object sender, EventArgs e)
        {
            EmployeeAddEditForm temp = new EmployeeAddEditForm();

            DialogResult resultDialog = temp.ShowDialog();

            if (resultDialog == DialogResult.OK)
            {
                Employee item = temp.ResultModel;

                mainTable.Rows.Add(item.Id, item.FirstName, item.LastName, item.MiddleName, item.Phone, item.Position.Id, item.Position.Title, item.Email);
            }
        }
Exemple #2
0
        private void EditMenuItem_Click(object sender, EventArgs e)
        {
            Employee temp = new Employee()
            {
                Id         = (int)MainGrid.SelectedRows[0].Cells[0].Value,
                FirstName  = MainGrid.SelectedRows[0].Cells[1].Value.ToString(),
                LastName   = MainGrid.SelectedRows[0].Cells[2].Value.ToString(),
                MiddleName = MainGrid.SelectedRows[0].Cells[3].Value.ToString(),
                Phone      = MainGrid.SelectedRows[0].Cells[4].Value.ToString(),
                Position   = new Position()
                {
                    Id    = (int)MainGrid.SelectedRows[0].Cells[5].Value,
                    Title = MainGrid.SelectedRows[0].Cells[6].Value.ToString()
                },
                Email = MainGrid.SelectedRows[0].Cells[7].Value.ToString()
            };

            byte[] imageBytes = connString.QueryFirst <byte[]>("SELECT dbo.Employee.Avatar FROM dbo.Employee WHERE dbo.Employee.Id = @id", new { temp.Id });

            temp.Avatar = imageBytes;

            EmployeeAddEditForm tempForm     = new EmployeeAddEditForm(temp);
            DialogResult        resultDialog = tempForm.ShowDialog();

            if (resultDialog == DialogResult.OK)
            {
                Employee item = tempForm.ResultModel;

                mainTable.Rows.Find(item.Id).SetField(1, item.FirstName);
                mainTable.Rows.Find(item.Id).SetField(2, item.LastName);
                mainTable.Rows.Find(item.Id).SetField(3, item.MiddleName);
                mainTable.Rows.Find(item.Id).SetField(4, item.Phone);
                mainTable.Rows.Find(item.Id).SetField(5, item.Position.Id);
                mainTable.Rows.Find(item.Id).SetField(6, item.Position.Title);
                mainTable.Rows.Find(item.Id).SetField(7, item.Email);
            }
        }