public static decimal Total()
{
var ed = new CompanyDataSetTableAdapters.EmployeeTableAdapter();
ed.Fill(Ds.Employee);
var total = Ds.Employee.Sum(e => e.Salary);
return total;
}
public static decimal Total()
{
var ed = new CompanyDataSetTableAdapters.EmployeeTableAdapter();
ed.Fill(Ds.Employee);
var total = Ds.Employee.Sum(e => e.Salary);
return(total);
}
public static void Cut()
{
var ed = new CompanyDataSetTableAdapters.EmployeeTableAdapter();
ed.Fill(Ds.Employee);
foreach (var emp in Ds.Employee)
{
emp.Salary /= 2;
}
ed.Update(Ds);
}
public static void Cut()
{
var ed = new CompanyDataSetTableAdapters.EmployeeTableAdapter();
ed.Fill(Ds.Employee);
foreach (var emp in Ds.Employee)
{
emp.Salary /= 2;
}
ed.Update(Ds);
}
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);
}
