public static List <PermissionDetailDTO> GetPermissions()
{
List <PermissionDetailDTO> permissions = new List <PermissionDetailDTO>();
var list = (from p in db.Permission
join s in db.PermissionState on p.PermissionState equals s.ID
join e in db.Employee on p.EmployeeID equals e.ID
select new
{
UserNo = e.UserNo,
name = e.Name,
surname = e.Surname,
StateName = s.StateName,
StateID = p.PermissionState,
startdate = p.PermissionStartDate,
enddate = p.PermissionEndDate,
employeeID = p.EmployeeID,
PermissionID = p.ID,
explanation = p.PermissionExplain,
Dayamount = p.PermissionDay,
departmentID = e.DepartmentID,
positionID = e.PositionID
}).OrderBy(x => x.startdate).ToList();
foreach (var item in list)
{
PermissionDetailDTO dto = new PermissionDetailDTO();
dto.UserNo = item.UserNo;
dto.Name = item.name;
dto.Surname = item.surname;
dto.StateName = item.StateName;
dto.StartDay = item.startdate;
dto.EndDay = item.enddate;
dto.EmployeeID = item.employeeID;
dto.PermissionDayAmount = item.Dayamount;
dto.PositionID = item.positionID;
dto.Sate = item.StateID;
dto.Explanation = item.explanation;
dto.DepartmentID = item.departmentID;
dto.PositionID = item.PermissionID;
dto.PermissionID = item.PermissionID;
permissions.Add(dto);
}
return(permissions);
}
public static List <PermissionDetailDTO> GetPermissions()
{
List <PermissionDetailDTO> listPermissions = new List <PermissionDetailDTO>();
var list = (from p in db.PERMISSIONs
join s in db.PERMISSIONSTATEs on p.PermissionState equals s.ID
join e in db.EMPLOYEEs on p.EmployeeID equals e.ID
select new
{
UserNo = e.UserNo,
Name = e.Name,
Surname = e.Surname,
StateName = s.StateName,
stateID = s.ID,
startDate = p.PermissionStartDate,
endDate = p.PermissionEndDate,
employeeID = p.EmployeeID,
permissionID = p.ID,
explanation = p.PermissionExplanation,
dayAmount = p.PermissionDay,
departmentID = e.DepartmentID,
positionID = e.PositionID,
}).OrderBy(x => x.startDate).ToList();
foreach (var item in list)
{
PermissionDetailDTO dto = new PermissionDetailDTO();
dto.UserNo = item.UserNo;
dto.Name = item.Name;
dto.Surname = item.Surname;
dto.EmployeeID = item.employeeID;
dto.PermissionDayAmount = item.dayAmount;
dto.StartDate = item.startDate;
dto.EndDate = item.endDate;
dto.DepartmentID = item.departmentID;
dto.PositionID = item.positionID;
dto.State = item.stateID;
dto.StateName = item.StateName;
dto.Explanation = item.explanation;
dto.PermissionID = item.permissionID;
listPermissions.Add(dto);
}
return(listPermissions);
}
public static List <PermissionDetailDTO> GetDetails()
{
List <PermissionDetailDTO> permissionsList = new List <PermissionDetailDTO>();
var list = (from p in db.PERMISSION
join ps in db.PERMISSIONSTATE on p.PermissionState equals ps.ID
join e in db.EMPLOYEE on p.EmployeeID equals e.ID
select new
{
UserNo = e.UserNo,
Name = e.Name,
Surname = e.Surname,
StateName = ps.StateName,
StateID = p.PermissionState,
EndDate = p.PermissionEndDate,
StartDate = p.PermissionStartDate,
EmployeeID = p.EmployeeID,
PermissionID = p.ID,
Explanation = p.PermissionExplanation,
DayAmount = p.PermissionDay,
DepartmentID = e.DepartmentID,
PosistionID = e.PositionID
}).OrderBy(x => x.StartDate).ToList();
foreach (var item in list)
{
PermissionDetailDTO dto = new PermissionDetailDTO();
dto.UserNo = item.UserNo;
dto.Name = item.Name;
dto.Surname = item.Surname;
dto.StateName = item.StateName;
dto.State = item.StateID;
dto.EndDate = item.EndDate;
dto.StartDate = item.StartDate;
dto.EmployeeID = item.EmployeeID;
dto.PermissionID = item.PermissionID;
dto.Explanation = item.Explanation;
dto.PermissionDayAmount = item.DayAmount;
dto.DepartmentID = item.DepartmentID;
dto.PositionID = item.PosistionID;
permissionsList.Add(dto);
}
return(permissionsList);
}
