private void RebootCheck()
{
entering = new firmEntities();
var checks = from Check_emp in entering.Check_emp_ET select Check_emp;
DataTable dt_checks = new DataTable("Check_emp");
dt_checks.Columns.Add("ID", typeof(Int32));
dt_checks.Columns.Add("Фамилия сотрудника", typeof(String));
dt_checks.Columns.Add("Сумма", typeof(Double));
dt_checks.Columns.Add("Код", typeof(Int32));
dt_checks.Columns.Add("Название типа расходов", typeof(String));
dt_checks.Columns.Add("Дата", typeof(DateTime));
foreach (var ch in checks)
{
dt_checks.Rows.Add(
ch.ID_check,
ch.Employee.FIO_employee,
ch.Amount,
ch.Code,
ch.Expense.Expense_name,
ch.Date_check
);
}
dgv_Check.DataSource = dt_checks;
}
private void RebootDepartment()
{
entering = new firmEntities();
var deps = from Department in entering.Department_ET select Department;
DataTable dt_departments = new DataTable("Employee");
dt_departments.Columns.Add("ID", typeof(Int32));
dt_departments.Columns.Add("Название", typeof(String));
dt_departments.Columns.Add("Количество работников", typeof(Int32));
foreach (var dep in deps)
{
dt_departments.Rows.Add(
dep.ID_department,
dep.Department_name,
dep.Employee_count);
}
dgv_Department.DataSource = dt_departments;
}
private void RebootEmployee()
{
entering = new firmEntities();
var employees = from Employee in entering.Employee_ET select Employee;
DataTable dt_employees = new DataTable("Employee");
dt_employees.Columns.Add("ID", typeof(Int32));
dt_employees.Columns.Add("ФИО", typeof(String));
dt_employees.Columns.Add("Отдел", typeof(String));
foreach (var employee in employees)
{
dt_employees.Rows.Add(
employee.ID_employee,
employee.FIO_employee,
employee.Department.Department_name);
}
dgv_employee.DataSource = dt_employees;
}
private void RebootExpense()
{
entering = new firmEntities();
var expenses = from Expense in entering.Expense_ET select Expense;
DataTable dt_expenses = new DataTable("Expense");
dt_expenses.Columns.Add("ID", typeof(Int32));
dt_expenses.Columns.Add("Название вида расходов", typeof(String));
dt_expenses.Columns.Add("Предельная сумма", typeof(Double));
dt_expenses.Columns.Add("Описание вида расходов", typeof(String));
dt_expenses.Columns.Add("Баланс", typeof(Double));
foreach (var expense in expenses)
{
dt_expenses.Rows.Add(
expense.ID_expense,
expense.Expense_name,
expense.Limit_sum,
expense.Expense_describe,
expense.Balance
);
}
dgv_Expense.DataSource = dt_expenses;
}
private void button1_Click(object sender, EventArgs e)
{
entering = new firmEntities();
Expense expense;
expense = new Expense();
string name_expense = tb_Name.Text;
string descr_expense = tb_description.Text;
string limit = tb_Limit.Text;
if ((name_expense != "") && (name_expense != "") && (limit != ""))
{
expense.Balance = Convert.ToInt32(limit);
expense.Expense_describe = descr_expense;
expense.Expense_name = name_expense;
expense.Limit_sum = Convert.ToInt32(limit);
entering.Expense_ET.Add(expense);
entering.SaveChanges();
RebootExpense();
}
}
