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