public static bool AddFriendRequest(string user1, string user2)
{
int user1Id = GetUserId(user1);
int user2Id = GetUserId(user2);
try
{
var userList = new List <User_privilage>();
userList = (from usr in _db.user_privilage
where usr.user1_id == user2Id && usr.user2_id == user1Id && usr.status == "Requested"
select usr).ToList();
if (userList.Count == 0)
{
User_privilage up = new User_privilage()
{
user1_id = user2Id,
user2_id = user1Id,
status = "Requested"
};
try
{
_db.user_privilage.Add(up);
_db.SaveChanges();
return(true);
}
catch { }
}
}
catch { }
return(false);
}
public static bool ConfirmFriendRequest(string user1, string user2)
{
int user1Id = GetUserId(user1);
int user2Id = GetUserId(user2);
int rows = _db.Database.ExecuteSqlRaw($"UPDATE user_privilage SET status = 'Confirmed' " +
$"WHERE user1_id = '{user1Id}' and user2_id = '{user2Id}'");
if (rows >= 1)
{
try
{
var userList = new List <User_privilage>();
userList = (from usr in _db.user_privilage
where usr.user1_id == user2Id && usr.user2_id == user1Id && usr.status == "Confirmed"
select usr).ToList();
if (userList.Count == 0)
{
User_privilage up = new User_privilage()
{
user1_id = user2Id,
user2_id = user1Id,
status = "Confirmed"
};
try
{
_db.user_privilage.Add(up);
_db.SaveChanges();
return(true);
}
catch { }
}
}
catch { }
}
return(false);
}
