/// <summary>
/// Create report WorkerReport
/// </summary>
/// <param name="viewName">viewName </param>
/// <returns>List<ReportWorker></returns>
public static List <ReportProject> CreateReportsProject(string viewName)
{
Func <MySqlDataReader, List <ReportProject> > func = (reader) =>
{
List <ReportProject> reportProject = new List <ReportProject>();
while (reader.Read())
{
reportProject.Add(ConvertReport.ConvertDBtoReport(reader));
}
return(reportProject);
};
List <ReportProject> reportProjects = DBAccess.RunReader(func, "report", new List <string>()
{
viewName
}, new List <string>()
{
"viewName"
});
foreach (var item in reportProjects)
{
item.Items = GetDepartmentsWorkersProject(item.Id);
}
return(reportProjects);
}
public static List <ReportProject> CreateReportsProject(string viewName)
{
Func <MySqlDataReader, List <ReportProject> > func = (reader) =>
{
List <ReportProject> reportProject = new List <ReportProject>();
while (reader.Read())
{
reportProject.Add(ConvertReport.ConvertDBtoReport(reader));
}
return(reportProject);
};
List <ReportProject> reportProjects = DBAccess.RunReader(func, "report", new List <string>()
{
viewName
}, new List <string>()
{
"viewName"
});
foreach (var item in reportProjects)
{
item.Project.workers = new List <UserWithoutPassword>();
List <ProjectWorker> workerInProject = LogicManager.getUsersBelongProjects(item.Project.ProjectId);
var workerInProjectGroup = workerInProject.GroupBy(p => p.User.DepartmentId);
foreach (var departmentWorkers in workerInProjectGroup)
{
item.DepartmentUser.Add(new HourDepartmentProject());
}
}
return(reportProjects);
}
public static List <ReportProject> CreateReports(List <string> param)
{
Func <MySqlDataReader, List <ReportProject> > func = (reader) =>
{
List <ReportProject> reportProject = new List <ReportProject>();
while (reader.Read())
{
reportProject.Add(ConvertReport.ConvertDBtoReport(reader));
}
return(reportProject);
};
return(DBAccess.RunReader(func, "CreateReport", new List <string>()
{
param[0]
}, new List <string>()
{
param[1]
}));
}
public static List <ReportProject> CreateReports1(string viewName)
{
Func <MySqlDataReader, List <ReportProject> > func = (reader) =>
{
List <ReportProject> reportProject = new List <ReportProject>();
while (reader.Read())
{
reportProject.Add(ConvertReport.ConvertDBtoReport(reader));
}
return(reportProject);
};
return(DBAccess.RunReader(func, "report", new List <string>()
{
viewName
}, new List <string>()
{
"viewName"
}));
}