private void buttonDelete_Click(object sender, EventArgs e)
{
try
{
if (dataGridView1.SelectedRows[0] != null)
{
int id = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["Id"].Value);
using (MyModel context = new MyModel())
{
Employee employee = context.Employees.First(emp => emp.id == id);
context.Employees.Remove(employee);
context.SaveChanges();
}
TextBoxManager.ClearTextBoxes(this.Controls.OfType <TextBox>());
InitializeDataGridView();
}
}
catch { }
}
private void buttonUpdate_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrWhiteSpace(textBoxDuration.Text) && dataGridView1.SelectedRows[0] != null)
{
DateTime date = Convert.ToDateTime(dataGridView1.SelectedRows[0].Cells["Date"].Value);
int empId = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["EmpId"].Value);
using (MyModel context = new MyModel())
{
Vacation vacation = context.Vacations.First(v => v.dtStart.Equals(date) && v.idEmployee == empId);
vacation.duration = Convert.ToInt32(textBoxDuration.Text);
context.SaveChanges();
}
TextBoxManager.ClearTextBoxes(this.Controls.OfType <TextBox>());
this.comboBoxEmployee.Text = string.Empty;
InitializeDataGridView();
}
}
catch { }
}
private void buttonUpdate_Click(object sender, EventArgs e)
{
try
{
if (TextBoxManager.IsNotNullOrWhiteSpaceTextBoxes(this.Controls.OfType <TextBox>()) &&
dataGridView1.SelectedRows[0] != null)
{
int id = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["Id"].Value);
using (MyModel context = new MyModel())
{
Position position = context.Positions.First(p => p.id == id);
position.name = textBoxName.Text;
position.description = textBoxDescription.Text;
context.SaveChanges();
}
TextBoxManager.ClearTextBoxes(this.Controls.OfType <TextBox>());
InitializeDataGridView();
}
}
catch { }
}
private void buttonUpdate_Click(object sender, EventArgs e)
{
try
{
if (TextBoxManager.IsNotNullOrWhiteSpaceTextBoxes(this.Controls.OfType <TextBox>()) &&
dataGridView1.SelectedRows[0] != null)
{
int id = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells["Id"].Value);
using (MyModel context = new MyModel())
{
Employee employee = context.Employees.First(emp => emp.id == id);
employee.name = textBoxName.Text;
employee.surname = textBoxSurname.Text;
employee.passport = Convert.ToInt32(textBoxPassport.Text);
context.SaveChanges();
}
TextBoxManager.ClearTextBoxes(this.Controls.OfType <TextBox>());
InitializeDataGridView();
}
}
catch { }
}
private void buttonInsert_Click(object sender, EventArgs e)
{
try
{
if (TextBoxManager.IsNotNullOrWhiteSpaceTextBoxes(this.Controls.OfType <TextBox>()))
{
Position position = new Position()
{
name = textBoxName.Text,
description = textBoxDescription.Text
};
using (MyModel context = new MyModel())
{
context.Positions.Add(position);
context.SaveChanges();
}
TextBoxManager.ClearTextBoxes(this.Controls.OfType <TextBox>());
InitializeDataGridView();
}
}
catch { }
}
private void buttonInsert_Click(object sender, EventArgs e)
{
try
{
if (TextBoxManager.IsNotNullOrWhiteSpaceTextBoxes(this.Controls.OfType <TextBox>()))
{
Employee employee = new Employee()
{
name = textBoxName.Text,
surname = textBoxSurname.Text,
passport = Convert.ToInt32(textBoxPassport.Text)
};
using (MyModel context = new MyModel())
{
context.Employees.Add(employee);
context.SaveChanges();
}
TextBoxManager.ClearTextBoxes(this.Controls.OfType <TextBox>());
InitializeDataGridView();
}
}
catch { }
}
private void buttonInsert_Click(object sender, EventArgs e)
{
try
{
if (TextBoxManager.IsNotNullOrWhiteSpaceTextBoxes(this.Controls.OfType <TextBox>()))
{
Vacation vacation = new Vacation()
{
duration = Convert.ToInt32(textBoxDuration.Text),
dtStart = Convert.ToDateTime(textBoxDate.Text),
idEmployee = (comboBoxEmployee.SelectedItem as Employee).id
};
using (MyModel context = new MyModel())
{
context.Vacations.Add(vacation);
context.SaveChanges();
}
TextBoxManager.ClearTextBoxes(this.Controls.OfType <TextBox>());
this.comboBoxEmployee.Text = string.Empty;
InitializeDataGridView();
}
}
catch { }
}
private void buttonInsert_Click(object sender, EventArgs e)
{
try
{
if (TextBoxManager.IsNotNullOrWhiteSpaceTextBoxes(this.Controls.OfType <TextBox>()))
{
Salary salary = new Salary()
{
amount = Convert.ToInt32(textBoxAmount.Text),
dtSalary = Convert.ToDateTime(textBoxDate.Text),
idPosition = (comboBoxPosition.SelectedItem as Position).id
};
using (MyModel context = new MyModel())
{
context.Salaries.Add(salary);
context.SaveChanges();
}
TextBoxManager.ClearTextBoxes(this.Controls.OfType <TextBox>());
this.comboBoxPosition.Text = string.Empty;
InitializeDataGridView();
}
}
catch { }
}
