public static List <Project> GetAllProjects()
{
string query = $"SELECT p.*,u.* FROM managertasks.project p join user u on u.id=p.managerId";
Func <MySqlDataReader, List <Project> > func = (reader) =>
{
List <Project> projects = new List <Project>();
while (reader.Read())
{
projects.Add(ConvertProject.convertDBtoProjectsWithManager(reader));
}
return(projects);
};
return(DBAccess.RunReader(query, func));
}
/// <summary>
/// Gets all projects
/// </summary>
/// <returns>List<Project> all projects</returns>
public static List <Project> GetAllProjects()
{
string query = $"SELECT p.*,u.* FROM managertasks.project p join user u on u.id=p.managerId";
Func <MySqlDataReader, List <Project> > func = (reader) =>
{
List <Project> projects = new List <Project>();
while (reader.Read())
{
projects.Add(ConvertProject.convertDBtoProjectsWithManager(reader));
}
return(projects);
};
List <Project> allProjects = DBAccess.RunReader(query, func);
allProjects.ForEach(p =>
{
p.HoursForDepartment = GetHoursDepartmentsProject(p.ProjectId);
});
return(allProjects);
}