private void button1_Click(object sender, EventArgs e) { try { emp.Job = (Job)comboBox1.SelectedItem; emp.Name = textBox2.Text; emp.Surname = textBox1.Text; emp.Patronymic = textBox3.Text; emp.CardId = long.Parse(textBox4.Text); if (fileSelect) { emp.Photo = ConvertToByteArray(pictureBox1.Image); } if (filedelete) { emp.Photo = null; } context.SaveChanges(); //comboBox2.DataSource = null; //comboBox2.DataSource = context.Employees.Local; //comboBox2.DisplayMember = "FullName"; //comboBox2.ValueMember = "Id"; this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button1_Click(object sender, EventArgs e) { try { Employee emp = new Employee(); emp.CardId = long.Parse(textBox4.Text); emp.JobId = (int)comboBox1.SelectedValue; emp.Name = textBox2.Text; emp.Surname = textBox1.Text; emp.Patronymic = textBox3.Text; emp.Status = false; if (fileSelect) { emp.Photo = ConvertToByteArray(Image.FromFile(openFileDialog1.FileName)); } if ((!fileSelect && MessageBox.Show("Вы не выбрали фото, продолжить?", "СКУД", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) || fileSelect) { context.Employees.Add(emp); context.SaveChanges(); this.Close(); } } catch (DbEntityValidationException) { MessageBox.Show("Заполните ФИО"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button1_Click(object sender, EventArgs e) { context.JournalRecors.Add(new JournalRecord() { Date = DateTime.Now, EmployeeId = 5, In = DateTime.Now, Out = DateTime.Now }); context.SaveChanges(); dataGridView1.DataSource = null; dataGridView1.DataSource = context.JournalRecors.Local; }
//private void Test(string id) //{ // try // { // long CardId = long.Parse(id); // Employee employee = context.Employees.Where(emp => emp.CardId == CardId).FirstOrDefault(); // if (employee == null) // { // CreateEployee emp = new CreateEployee(CardId, context); // emp.ShowDialog(); // } // else // { // string status = AddJournalRecord(employee.Id); // string job = context.Jobs.Find(employee.JobId).JobDescription; // EmployeeInfo info = new EmployeeInfo(employee, status, job); // info.ShowDialog(); // } // } // catch (Exception ex) // { // MessageBox.Show(ex.Message); // } //} public string AddJournalRecord(Employee emp) { string status = string.Empty; try { JournalRecord record = new JournalRecord(); record = context.JournalRecors.Where(j => j.EmployeeId == emp.Id).ToList().LastOrDefault(); if (record == null) { context.JournalRecors.Add(new JournalRecord() { EmployeeId = emp.Id, Date = DateTime.Now.Date, In = DateTime.Now }); emp.Status = true; status = "Вход"; } else if (record.Out != null) // сотрудник вышел { context.JournalRecors.Add(new JournalRecord() { EmployeeId = emp.Id, Date = DateTime.Now.Date, In = DateTime.Now }); // вход emp.Status = true; status = "Вход"; } else // сотрудник вошел { record.Out = DateTime.Now; // выход emp.Status = false; status = "Выход"; } context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } return(status); }