public static List <User> getAllTeamLeaders() { string query = $"SELECT * FROM task_managment.users WHERE status=2"; Func <MySqlDataReader, List <User> > func = (reader) => { List <User> teamLeaders = new List <User>(); while (reader.Read()) { teamLeaders.Add(GlobalLogic.InitUser(reader)); } return(teamLeaders); }; return(DBAccess.RunReader(query, func)); }
public static List <User> GetWorkersDeatails(int teamLeaderId) { string query = $"SELECT * FROM task_managment.users WHERE manager={teamLeaderId}"; Func <MySqlDataReader, List <User> > func = (reader) => { List <User> workers = new List <User>(); while (reader.Read()) { workers.Add(GlobalLogic.InitUser(reader)); } return(workers); }; return(DBAccess.RunReader(query, func)); }
public static List <User> GetAllUsers() { string query = $"SELECT * FROM task_managment.users where is_active=1 && status!=1"; Func <MySqlDataReader, List <User> > func = (reader) => { List <User> users = new List <User>(); while (reader.Read()) { users.Add(GlobalLogic.InitUser(reader)); } return(users); }; return(DBAccess.RunReader(query, func)); }
public static List <User> GetWorkersForProject(int teamLeaderId) { string query = $"SELECT u.* FROM users u JOIN user_projects up ON u.user_id= up.user_id" + $" WHERE project_id IN (SELECT project_id from projects WHERE team_leader= {teamLeaderId})" + $" GRUP BY u.user_name; "; Func <MySqlDataReader, List <User> > func = (reader) => { List <User> workers = new List <User>(); while (reader.Read()) { workers.Add(GlobalLogic.InitUser(reader)); } return(workers); }; return(DBAccess.RunReader(query, func)); }