public Employee[] listDepartmentParticipators(Project prj, Department dpt) { DataTable dtEmpID = SqlHelper.ExecuteDataTable(@"select employeeID from T_PrjParticipation where projectID=@prjID and departmentID=@dptID", new SqlParameter("@prjID", prj.projectID), new SqlParameter("@dptID", dpt.DepartmentID)); Employee[] employees = new Employee[dtEmpID.Rows.Count]; for (int i = 0; i < dtEmpID.Rows.Count; i++) { employees[i] = new EmployeeDAL().getByID((Guid)dtEmpID.Rows[i][0]); } return(employees); }
public void Update(SalarySheetItem item) { SqlHelper.ExecuteNonQuery(@"Update T_SalarySheetItem set BaseSalary = @BaseSalary, Bonus = @Bonus, Deduction = @Deduction, AfterTaxWage = @AfterTaxWage where SalarySheetItemID = @SalarySheetItemID", new SqlParameter("@BaseSalary", SqlHelper.ToDBValue(item.BaseSalary)), new SqlParameter("@Bonus", SqlHelper.ToDBValue(item.Bonus)), new SqlParameter("@Deduction", SqlHelper.ToDBValue(item.Deduction)), new SqlParameter("@AfterTaxWage", SqlHelper.ToDBValue(item.AfterTaxWage)), new SqlParameter("@SalarySheetItemID", item.SalarySheetItemID)); EmployeeDAL employDAL = new EmployeeDAL(); employDAL.UpdateEmployeeSalarys(item); }
public decimal?costInwageNew(Participation parti) { EmployeeDAL empDAL = new EmployeeDAL(); decimal? cost = 0; DataTable dtParti = SqlHelper.ExecuteDataTable(@"select * from T_PrjParticipation where projectID = @prjID and employeeID=@empID", new SqlParameter("@prjID", parti.projectID), new SqlParameter("@empID", parti.employeeID)); if (dtParti.Rows.Count > 0) { Employee emp = empDAL.getByID(parti.employeeID); cost = countEmpPeriod(parti) * emp.AfterTaxWage; } return(cost); }
public Employee[] listAllParticipators(Project prj) { DataTable dtEmpID = SqlHelper.ExecuteDataTable( @"select employeeID from T_PrjParticipation where projectID=@prjID", new SqlParameter("@prjID", SqlHelper.ToDBValue(prj.projectID))); if (dtEmpID.Rows.Count > 0) { Employee[] employees = new Employee[dtEmpID.Rows.Count]; for (int i = 0; i < dtEmpID.Rows.Count; i++) { employees[i] = new EmployeeDAL().getByID((Guid)dtEmpID.Rows[i][0]); } return(employees); } else { return(null); } }
public void Generate(int year, int month, Guid dptId) { Guid sheetID = Guid.NewGuid(); SqlHelper.ExecuteNonQuery(@"insert into T_SalarySheet(SalarySheetID,Year,Month,DepartmentID) values(@SalarySheetID,@Year,@Month,@DepartmentID)", new SqlParameter("@SalarySheetID", sheetID), new SqlParameter("@Year", year), new SqlParameter("@Month", month), new SqlParameter("@DepartmentID", dptId)); Employee[] employees = new EmployeeDAL().SearchByDpt(dptId); foreach (Employee employee in employees) { SqlHelper.ExecuteNonQuery(@"insert into T_SalarySheetItem(SalarySheetItemID,SalarySheetID,EmployeeID,BaseSalary,Bonus,Deduction,AfterTaxWage) values(newid(),@SalarySheetID,@EmployeeID,0,0,0,0)", new SqlParameter("@SalarySheetID", sheetID), new SqlParameter("@EmployeeID", employee.ID)); } }