public static decimal SubTotalForDept(Guid deptId)
{
var dda = new CompanyDataSetTableAdapters.DepartmentTableAdapter();
dda.Fill(Ds.Department);
var eda = new CompanyDataSetTableAdapters.EmployeeTableAdapter();
eda.Fill(Ds.Employee);
var root = Ds.Department.Where(d => d.department_id == deptId).Single();
var total = GetSubDeptsTotal(root, root.GetEmployeeRows().Sum(er => er.Salary));
return total;
}
public static decimal SubTotalForDept(Guid deptId)
{
var dda = new CompanyDataSetTableAdapters.DepartmentTableAdapter();
dda.Fill(Ds.Department);
var eda = new CompanyDataSetTableAdapters.EmployeeTableAdapter();
eda.Fill(Ds.Employee);
var root = Ds.Department.Where(d => d.department_id == deptId).Single();
var total = GetSubDeptsTotal(root, root.GetEmployeeRows().Sum(er => er.Salary));
return(total);
}
public static void CutSubDept(Guid deptId)
{
var dda = new CompanyDataSetTableAdapters.DepartmentTableAdapter();
dda.Fill(Ds.Department);
var eda = new CompanyDataSetTableAdapters.EmployeeTableAdapter();
eda.Fill(Ds.Employee);
var root = Ds.Department.Where(d => d.department_id == deptId).Single();
foreach (var employeeRow in root.GetEmployeeRows())
{
employeeRow.Salary /= 2;
}
CutSubDept(root);
eda.Update(Ds);
}
public static void CutSubDept(Guid deptId)
{
var dda = new CompanyDataSetTableAdapters.DepartmentTableAdapter();
dda.Fill(Ds.Department);
var eda = new CompanyDataSetTableAdapters.EmployeeTableAdapter();
eda.Fill(Ds.Employee);
var root = Ds.Department.Where(d => d.department_id == deptId).Single();
foreach (var employeeRow in root.GetEmployeeRows())
{
employeeRow.Salary /= 2;
}
CutSubDept(root);
eda.Update(Ds);
}
