public static Project GetProjectDetails(int projectId)
{
string query = $"SELECT * FROM managetasks.project WHERE projectId={projectId}";
Func <MySqlDataReader, List <Project> > func = (reader) =>
{
List <Project> projects = new List <Project>();
while (reader.Read())
{
projects.Add(ConvertProject.convertDBtoProjects(reader));
}
return(projects);
};
return(DBAccess.RunReader(query, func).Count() != 0 ? DBAccess.RunReader(query, func)[0] : null);
}
public static List <Project> getProjectsManager(int id)
{
string query = $"SELECT * FROM managertasks.project WHERE managerId ={id}";
Func <MySqlDataReader, List <Project> > func = (reader) =>
{
List <Project> projectsList = new List <Project>();
while (reader.Read())
{
projectsList.Add(ConvertProject.convertDBtoProjects(reader));
}
return(projectsList);
};
return(DBAccess.RunReader(query, func));
}
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);
}
/// <summary>
/// Gets projects of teamLeader
/// </summary>
/// <param name="id">teamLeaderId</param>
/// <returns></returns>
public static List <Project> GetProjectsManager(int tamLeaderId)
{
string query = $"SELECT * FROM managertasks.project WHERE managerId ={tamLeaderId}";
Func <MySqlDataReader, List <Project> > func = (reader) =>
{
List <Project> projectsList = new List <Project>();
while (reader.Read())
{
projectsList.Add(ConvertProject.convertDBtoProjects(reader));
}
return(projectsList);
};
List <Project> managerProjects = DBAccess.RunReader(query, func);
managerProjects.ForEach(p =>
{
p.HoursForDepartment = LogicProjects.GetHoursDepartmentsProject(p.ProjectId);
});
return(managerProjects);
}
