private void delFriend()
{
int search = (int)this.lUsername.Tag;
Datas.User caller = (from u in Bdd.DbAccess.Users
where u.ID == search
select u).FirstOrDefault();
if (caller != null)
{
Datas.Relationship relationship1 = (from ar in Bdd.DbAccess.Relationships
where ar.userId1 == caller.ID && ar.userId2 == App.user.ID
select ar).FirstOrDefault();
Datas.Relationship relationship2 = (from ar in Bdd.DbAccess.Relationships
where ar.userId2 == caller.ID && ar.userId1 == App.user.ID
select ar).FirstOrDefault();
if (relationship1 != null && relationship2 != null)
{
Bdd.DbAccess.DeleteObject(relationship1);
Bdd.DbAccess.DeleteObject(relationship2);
Bdd.DbAccess.SaveChanges();
}
}
}
public void acceptFriendshipRequest()
{
int search = (int)this.lUsername.Tag;
Datas.User caller = (from u in Bdd.DbAccess.Users
where u.ID == search
select u).FirstOrDefault();
if (caller != null)
{
Datas.RelationshipRequest addRequest = (from ar in Bdd.DbAccess.RelationshipRequests
where ar.idCaller == caller.ID
select ar).FirstOrDefault();
if (addRequest != null)
{
Datas.Relationship relationship1 = new Datas.Relationship()
{
userId1 = App.user.ID,
userId2 = caller.ID
};
Datas.Relationship relationship2 = new Datas.Relationship()
{
userId2 = App.user.ID,
userId1 = caller.ID
};
Datas.Relationship relationship1Exists = (from i in Bdd.DbAccess.Relationships
where i.userId1 == App.user.ID &&
i.userId2 == caller.ID
select i).FirstOrDefault();
Datas.Relationship relationship2Exists = (from i in Bdd.DbAccess.Relationships
where i.userId2 == App.user.ID &&
i.userId1 == caller.ID
select i).FirstOrDefault();
//ajoute 2 lignes pour éviter les problèmes de doublons dans les requetes
if (relationship1Exists == null)
{
Bdd.DbAccess.AddToRelationships(relationship1);
}
if (relationship2Exists == null)
{
Bdd.DbAccess.AddToRelationships(relationship2);
}
Bdd.DbAccess.DeleteObject(addRequest);
Bdd.DbAccess.SaveChanges();
}
}
}
public List <Datas.User> onlineList()
{
con.Open();
List <Datas.User> onlineList = new List <Datas.User>();
string sorgu = "SELECT * FROM kullanici WHERE online = " + 1 + "";
cmd = new MySqlCommand(sorgu, con);
dr = cmd.ExecuteReader();
while (dr.Read())
{
Datas.User User = new Datas.User();
User.UserID = Int32.Parse(dr[0].ToString());
User.Username = dr[1].ToString();
onlineList.Add(User);
}
con.Close();
return(onlineList);
}
private void refusFriendshipRequest()
{
int search = (int)this.lUsername.Tag;
Datas.User caller = (from u in Bdd.DbAccess.Users
where u.ID == search
select u).FirstOrDefault();
if (caller != null)
{
Datas.RelationshipRequest addRequest = (from ar in Bdd.DbAccess.RelationshipRequests
where ar.idCaller == caller.ID
select ar).FirstOrDefault();
if (addRequest != null)
{
Datas.Relationship relationship1Exists = (from i in Bdd.DbAccess.Relationships
where i.userId1 == App.user.ID &&
i.userId2 == caller.ID
select i).FirstOrDefault();
Datas.Relationship relationship2Exists = (from i in Bdd.DbAccess.Relationships
where i.userId2 == App.user.ID &&
i.userId1 == caller.ID
select i).FirstOrDefault();
if (relationship1Exists != null)
{
Bdd.DbAccess.DeleteObject(relationship1Exists);
}
if (relationship2Exists != null)
{
Bdd.DbAccess.DeleteObject(relationship2Exists);
}
Bdd.DbAccess.DeleteObject(addRequest);
Bdd.DbAccess.SaveChanges();
}
}
}
public List <Datas.User> SiramalaGetir()
{
List <Datas.User> liste = new List <User>();
con.Open();
string sorgu = "SELECT username,galibiyet,malubiyet,avaraj FROM kullanici ORDER BY avaraj DESC";
cmd = new MySqlCommand(sorgu, con);
dr = cmd.ExecuteReader();
while (dr.Read())
{
Datas.User User = new Datas.User();
User.Username = dr[0].ToString();
User.Galibiyet = Int32.Parse(dr[1].ToString());
User.Malubiyet = Int32.Parse(dr[2].ToString());
User.Avaraj = Int32.Parse(dr[3].ToString());
liste.Add(User);
}
con.Close();
return(liste);
}
