/// <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" })); }