public void RefreshGrid()
{
using (testEntities context = new testEntities())
{
dataGridView2.DataSource = context.TableTests.ToList();
List <TableTest> newList = new List <TableTest>();
newList = context.TableTests.ToList();
int sum = 0, workingsUsers = 0;
double middleSalary;
foreach (TableTest tableTest in newList)
{
if (tableTest.FireDate == null)
{
sum += tableTest.Salary;
workingsUsers++;
}
}
middleSalary = sum / workingsUsers;
textBoxUserCount.Text = workingsUsers.ToString();
textBoxMiddleSalary.Text = Convert.ToInt32(middleSalary).ToString();
}
}
private void buttonDeleteUser_Click(object sender, EventArgs e)
{
int selectedRowCount = dataGridView2.Rows.GetRowCount(DataGridViewElementStates.Selected);
try
{
using (testEntities context = new testEntities())
{
for (int i = 0; i < selectedRowCount; i++)
{
DataGridViewRow row = dataGridView2.SelectedRows[i];
int rowId = Int32.Parse(row.Cells[0].Value.ToString());
TableTest forDelete = context.TableTests.FirstOrDefault(u => u.id == rowId);
context.TableTests.Remove(forDelete);
}
context.SaveChanges();
RefreshGrid();
}
}
catch (ArgumentOutOfRangeException ex)
{
MessageBox.Show("Вы не выбрали сотрудника для удаления");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void buttonSaveFile_Click(object sender, EventArgs e)
{
using (testEntities context = new testEntities())
{
List <TableTest> newList = new List <TableTest>();
newList = context.TableTests.ToList();
XDocument xdoc = new XDocument(
new XDeclaration("1.0", "utf-8", "yes"),
new XElement("Workers",
from worker in newList
select
new XElement("Worker", new XAttribute("ID", worker.id),
new XElement("Name", worker.Name),
new XElement("Surname", worker.Surname),
new XElement("ThirdName", worker.ThirdName),
new XElement("JobPosition", worker.JobPosition),
new XElement("Salary", worker.Salary),
new XElement("HireDate", worker.HireDate),
new XElement("FireDate", worker.FireDate))));
saveFileDialog1.Filter = "XML-File | *.xml";
if (saveFileDialog1.ShowDialog() == DialogResult.Cancel)
{
return;
}
string filename = saveFileDialog1.FileName;
xdoc.Save(filename);
}
}
private void buttonAddUser_Click(object sender, EventArgs e)
{
try
{
string name = textBoxName.Text;
string surname = textBoxSurname.Text;
string thirdName = textBoxThirdName.Text;
string jobPosition = textBoxJobPosition.Text;
int salary = Decimal.ToInt32(numericSalary.Value);
DateTime hireDate = dateTimePickerFired.Value.Date;
Nullable <DateTime> fireDate;
if (checkBoxIsFired.Checked)
{
fireDate = dateTimePickerFired.Value.Date;
}
else
{
fireDate = null;
}
TableTest newUser = new TableTest
{
Name = name,
Surname = surname,
ThirdName = thirdName,
JobPosition = jobPosition,
Salary = salary,
HireDate = hireDate,
FireDate = fireDate
};
using (testEntities context = new testEntities())
{
context.TableTests.Add(newUser);
context.SaveChanges();
}
}
catch when(ContainInappropriateSymbols(textBoxName))
{
MessageBox.Show("Введенноё имя не соответствует требованиям");
}
