public static string getUserNick(int username)
{
DataBase dal = new DataBase();
string sql = "select Nick from Users where UserID = " + username;
DataSet rs = dal.ReturnDataSet(sql);
return rs.Tables[0].Rows[0][0].ToString();
}
public static DataSet getUserTags(int idUser)
{
DataBase dal = new DataBase();
string sql = "Select distinct Tags.Palavra FROM Tags,Users,User_Tag where (Tags.TagID=User_Tag.TagID and User_Tag.UserID=" + idUser + ")";
DataSet rs = dal.ReturnDataSet(sql);
if (rs.Tables[0].Rows.Count > 0)
{
return rs;
}
else return null;
}
public static ArrayList suggestedFriends(int username)
{
DataBase dal = new DataBase();
string sql = "select User2ID from Ligacaos where User1ID = " + username + "and EstadoDaLigacaoID=2";
sql += " UNION select User1ID from Ligacaos where User2ID = " + username + " and EstadoDaLigacaoID=2;";
//Amigos do utilizador
DataSet rs = dal.ReturnDataSet(sql);
string[] amigos = new string[rs.Tables[0].Rows.Count];
for(int x=0;x<rs.Tables[0].Rows.Count;x++){
amigos[x]=""+rs.Tables[0].Rows[x][0];
}
int id;
ArrayList myAL = new ArrayList();
for (int i = 0; i < rs.Tables[0].Rows.Count; i++)
{
id = ((int)rs.Tables[0].Rows[i][0]);
DataBase dal2 = new DataBase();
string sql2 = "select User2ID from Ligacaos where User1ID = " + id + " and EstadoDaLigacaoID=2 and User2ID <> "+username;
sql2 += " UNION select User1ID from Ligacaos where User2ID = " + id + " and EstadoDaLigacaoID=2 and User1ID <> " + username;
DataSet rs2 = dal2.ReturnDataSet(sql2);
for (int x = 0; x < rs2.Tables[0].Rows.Count; x++)
{
int existe = 0;
for (int y = 0; y < rs.Tables[0].Rows.Count; y++)
{
if (rs2.Tables[0].Rows[x][0].ToString() == amigos[y].ToString())
{
existe = 1;
}
}
if (existe == 0)
{
myAL.Add(rs2.Tables[0].Rows[x][0].ToString());
}
}
}
return myAL;
}