public static List <SalaryDetailDTO> GetSalaries()
{
List <SalaryDetailDTO> salaryList = new List <SalaryDetailDTO>();
var list = (from s in db.SALARY
join e in db.EMPLOYEE on s.EmployeeID equals e.ID
join m in db.MONTH on s.MonthID equals m.ID
select new
{
UserNo = e.UserNo,
Name = e.Name,
Surname = e.Surname,
EmployeeID = e.ID,
Amount = s.Amount,
Year = s.Year,
MonthName = m.MonthName,
MonthID = m.ID,
SalaryID = s.ID,
DepartmentID = e.DepartmentID,
PositionID = e.PositionID
}).OrderBy(x => x.Year).ToList();
foreach (var item in list)
{
SalaryDetailDTO dto = new SalaryDetailDTO();
dto.UserNo = item.UserNo;
dto.Name = item.Name;
dto.Surname = item.Surname;
dto.EmployeeID = item.EmployeeID;
dto.SalaryAmount = item.Amount;
dto.SalaryYear = item.Year;
dto.MonthName = item.MonthName;
dto.MonthID = item.MonthID;
dto.SalaryID = item.SalaryID;
dto.DepartmentID = item.DepartmentID;
dto.PositionID = item.PositionID;
dto.OldSalary = item.Amount;
salaryList.Add(dto);
}
return(salaryList);
}
public static List <SalaryDetailDTO> GetSalarys()
{
List <SalaryDetailDTO> salarylist = new List <SalaryDetailDTO>();
var list = (from s in db.Salary
join e in db.Employee on s.EmployeeID equals e.ID
join m in db.Months on s.MonthID equals m.ID
select new
{
UserNo = e.UserNo,
name = e.Name,
surname = e.Surname,
employeeID = s.EmployeeID,
amount = s.Amount,
year = s.Year,
monthname = m.MonthName,
monthID = s.MonthID,
SalaryID = s.ID,
departmentID = e.DepartmentID,
PositionID = e.PositionID
}).OrderBy(x => x.year).ToList();
foreach (var item in list)
{
SalaryDetailDTO dto = new SalaryDetailDTO();
dto.UserNo = item.UserNo;
dto.Name = item.name;
dto.Surname = item.surname;
dto.EmployeeID = item.employeeID;
dto.SalaryAmount = item.amount;
dto.SalaryYear = item.year;
dto.MonthName = item.monthname;
dto.MonthID = item.monthID;
dto.SalaryID = item.SalaryID;
dto.DepartmentID = item.departmentID;
dto.PositionID = item.PositionID;
dto.OldSalary = item.amount;
salarylist.Add(dto);
}
return(salarylist);
}
