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);
}