public static List <Project> GetProjectsUser(int id)
{
string query = $"SELECT * FROM task.projectworker WHERE workerId={id} ;";
List <Project> projects = new List <Project>();
Func <MySqlDataReader, List <PresentDay> > func = (reader) =>
{
List <PresentDay> projectsWorker = new List <PresentDay>();
while (reader.Read())
{
projectsWorker.Add(ConvertorPresentDay.convertDBtoProjectWorker(reader));
}
return(projectsWorker);
};
List <PresentDay> ProjectWorker = DBAccess.RunReader(query, func);
foreach (var item in ProjectWorker)
{
projects.Add(LogicProjects.GetProjectDetails(item.ProjectId));
}
return(projects);
}
