async public Task <string> Addfriend(Model.FriendAccount user)
{
Model.FriendAccount d1 = await _database.Table <Model.FriendAccount>().Where(x => x.Username == user.Username).FirstOrDefaultAsync();
if (d1 == null)
{
await _database.InsertAsync(user);
return("Successfully Added");
}
else
{
return("The username already exist");
}
}
async void RemoveFriend(object sender, System.EventArgs e)
{
if (!string.IsNullOrEmpty(friendid))
{
Console.WriteLine("test 1 " + friendid);
string path = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), "Chattydata.db3");
SQLiteAsyncConnection _database = new SQLiteAsyncConnection(path);
Model.FriendAccount d1 = await _database.Table <Model.FriendAccount>().Where(x => x.ID == friendid).FirstOrDefaultAsync();
await App.MyDatabase.RemoveFriendInfo(d1);
await DisplayAlert("Successful", "Remove friend successfully", "OK");
await Navigation.PushAsync(new FriendListPage(users));
}
else
{
Console.WriteLine("testing" + friendid);
await DisplayAlert("Friend list", "No specific friend is found", "OK");
}
}
async void AddFriend(object sender, System.EventArgs e)
{
if (!string.IsNullOrEmpty(friendid))
{
Console.WriteLine("testing 0 " + friendid);
string path = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), "Chattydata.db3");
SQLiteAsyncConnection _database = new SQLiteAsyncConnection(path);
Model.UserAccount d1 = await _database.Table <Model.UserAccount>().Where(x => x.ID == friendid).FirstOrDefaultAsync();
Model.FriendAccount d2 = await _database.Table <Model.FriendAccount>().Where(x => (x.Username == users.Username && x.FriendUsername == d1.Username) || (x.Username == d1.Username && x.FriendUsername == users.Username)).FirstOrDefaultAsync();
Model.FriendID d3 = await _database.Table <Model.FriendID>().Where(x => x.ID == "1").FirstOrDefaultAsync();
if (d2 == null)
{
List <Model.FriendAccount> usercnt = await _database.Table <Model.FriendAccount>().ToListAsync();
int id = Convert.ToInt32(d3.FriendlistID);
id = id + 1;
friend.ID = id.ToString();
friend.Username = users.Username;
friend.FriendUsername = d1.Username;
d3.FriendlistID = id.ToString();
await App.MyDatabase.SaveFriendIDInfo(d3);
await App.MyDatabase.SaveFriendInfo(friend);
await DisplayAlert("Successful", "Add friend successfully", "OK");
}
else
{
await DisplayAlert("Fail", "he/she is your friend", "OK");
}
}
else
{
await DisplayAlert("Add Friend", "Please select a friend", "OK");
}
}
public async Task RemoveFriendInfo(Model.FriendAccount info)
{
await _database.DeleteAsync(info);
}
public async Task SaveFriendInfo(Model.FriendAccount info)
{
await _database.InsertAsync(info);
}
