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