public List <ItemExcel> GetExcel(int projectid, int empid)
{
List <ItemExcel> list = new List <ItemExcel>();
var query = (from p in _projects
join t in _TimeSheetSet
on p.Id equals t.ProjectId
join ts in _taskManangement
on t.TaskManagementId equals ts.Id
where t.ProjectId == projectid && ts.ProjectId == projectid &&
ts.EmployeeId == empid
orderby t.Id descending
select new
{
TimeSheetId = t.Id,
ProjectId = t.ProjectId,
ProjectName = p.projectName,
ClientName = p.ClientName,
Task_id = t.TaskManagementId,
TaskDifficult = ts.TaskDifficulty,
TaskName = ts.TaskName,
Task_status = ts.TaskStatus,
StartDate = ts.StartDate,
EndDate = ts.EndDate,
StartTime = t.StartTime,
EndTime = t.EndTime,
Duration = t.Duration,
EmployeeId = ts.EmployeeId,
EmployeeName = ts.EmployeeName,
IsDelete = ts.IsDeleted,
}).AsNoTracking();
foreach (var item in query)
{
ItemExcel excel = new ItemExcel();
excel.ReportId = item.TimeSheetId;
excel.EmployeeName = item.EmployeeName;
excel.ClientName = item.ClientName;
excel.ProjectName = item.ProjectName;
excel.TaskName = item.TaskName;
excel.TaskDifficult = item.TaskDifficult;
excel.StartDate = item.StartDate;
excel.EndDate = item.EndDate;
excel.StartTime = item.StartTime;
excel.EndTime = item.EndTime;
excel.Duration = item.Duration;
list.Add(excel);
}
return(list);
}
public List <ItemExcel> GetExcel()
{
List <ItemExcel> list = new List <ItemExcel>();
var query = from p in _projectSet
join r in _reportSet
on p.Id equals r.ProjectId
join t in _timeSet
on r.TimesheetId equals t.Id
join task in _taskSet
on t.TaskManagementId equals task.Id
select new
{
ReportId = r.Id,
EmployeeName = task.EmployeeName,
ClientName = p.ClientName,
ProjectName = p.projectName,
TaskName = task.TaskName,
TaskDifficult = task.TaskDifficulty,
StartDate = task.StartDate,
EndDate = task.EndDate,
StartTime = t.StartTime,
EndTime = t.EndTime,
Duration = t.Duration
};
foreach (var item in query)
{
ItemExcel excel = new ItemExcel();
excel.ReportId = item.ReportId;
excel.EmployeeName = item.EmployeeName;
excel.ClientName = item.ClientName;
excel.ProjectName = item.ProjectName;
excel.TaskName = item.TaskName;
excel.TaskDifficult = item.TaskDifficult;
excel.StartDate = item.StartDate;
excel.EndDate = item.EndDate;
excel.StartTime = item.StartTime;
excel.EndTime = item.EndTime;
excel.Duration = item.Duration;
list.Add(excel);
}
return(list);
}