/// <summary>
/// Create report WorkerReport
/// </summary>
/// <param name="viewName">viewName </param>
/// <returns>List<ReportWorker></returns>
public static List <ReportWorker> CreateReportsWorker(string viewName)
{
Func <MySqlDataReader, List <ReportWorker> > func = (reader) =>
{
List <ReportWorker> reportWorker = new List <ReportWorker>();
while (reader.Read())
{
reportWorker.Add(ConvertReport.ConvertDBtoReportWorker(reader));
}
return(reportWorker);
};
List <ReportWorker> reportWorkers = DBAccess.RunReader(func, "report", new List <string>()
{
viewName
}, new List <string>()
{
"viewName"
});
reportWorkers.ForEach(r =>
{
r.ParentId = 0;
r.Items = GetReportWorkerDetailsById(r.Id);
});
return(reportWorkers);
}
public static List <ReportWorker> CreateReportsWorker(string viewName)
{
Func <MySqlDataReader, List <ReportWorker> > func = (reader) =>
{
List <ReportWorker> reportWorker = new List <ReportWorker>();
while (reader.Read())
{
reportWorker.Add(ConvertReport.ConvertDBtoReportWorker(reader));
}
return(reportWorker);
};
return(DBAccess.RunReader(func, "report", new List <string>()
{
viewName
}, new List <string>()
{
"viewName"
}));
}
