async void Favorites()
{
var conn = sqlite.GetConnection();
var x = conn.Query <Teamm>("SELECT * From Teamm");
if (x.Count == 0)
{
Visible = true;
ListVisible = false;
}
else
{
Visible = false;
ListVisible = true;
foreach (var item in x)
{
Teams.Add(item);
}
}
}
async void Entries()
{
if (string.IsNullOrEmpty(User.Name) || string.IsNullOrEmpty(User.Email) || !User.Email.Contains("@") || !User.Email.Contains(".com"))
{
await PageDialogService.DisplayAlertAsync("Advice", "Empty fields", "ok");
}
else
{
var x = sqliteInterface.GetConnection();
x.Insert(User);
await NavigationService.NavigateAsync(new Uri(NavConstants.MasterMenu, UriKind.Absolute));
}
}
public MenuViewModel(INavigationService navigation, ISqliteInterface sqliteInterface, IPageDialogService pageDialog) : base(pageDialog, navigation)
{
onNavigate = new DelegateCommand <string>(Navigate);
if (Device.RuntimePlatform == Device.UWP)
{
User.Name = "User";
}
else if (Device.RuntimePlatform == Device.Android || Device.RuntimePlatform == Device.iOS)
{
sqlite = sqliteInterface;
var profile = sqlite.GetConnection().Query <User>("select * from User");
User.Name = profile.First().Name;
}
}
//Get favorites teams from local db//
async Task GetFavoriteTeams()
{
var teamslist = sqlite.GetConnection().Query <Teamm>("SELECT * From Teamm");
if (teamslist.Count == 0)
{
Visible = true;
ListVisible = false;
}
else
{
Teams = teamslist; //Fill list//
Visible = false;
ListVisible = true;
}
}
//Sign In button//
async Task LoginButton()
{
try
{
if (!string.IsNullOrEmpty(User.Name) && !string.IsNullOrEmpty(User.Email) && User.Email.Contains("@") && User.Email.Contains(".com"))
{
sqliteInterface.GetConnection().Insert(User); //Insert user into local db//
await NavigationService.NavigateAsync(new Uri(NavConstants.TabbedPage, UriKind.Relative)); //Navigate to another page//
}
}
catch (Exception e)
{
Debug.WriteLine($"{e.Message}"); //Error message//
}
}
//Save Team//
async void SaveTeam()
{
var x = Sqlite.GetConnection();
var search = x.Query <Teamm>("Select * from Teamm");
var team = search.Where(elemento => elemento.Name == Table.Team.Name).ToList();
if (search.Count == 0)
{
x.Insert(Table.Team);
}
else if (team.Count != 0)
{
await dialogService.DisplayAlertAsync("", "This team exist in your favorites list", "ok");
}
else
{
x.Insert(Table.Team);
}
}
protected override void OnInitialized()
{
InitializeComponent();
if (Device.RuntimePlatform == Device.UWP)
{
NavigationService.NavigateAsync(new Uri(NavConstants.MasterMenu, UriKind.Relative));
}
else if (Device.RuntimePlatform == Device.Android || Device.RuntimePlatform == Device.iOS)
{
var x = sqlite.GetConnection();
x.CreateTable <User>();
x.CreateTable <Teamm>();
var List = x.Query <User>("Select * From User");
if (List.Any())
{
NavigationService.NavigateAsync(new Uri(NavConstants.TabbedPage, UriKind.Relative));
}
else
{
NavigationService.NavigateAsync(new Uri(NavConstants.StartPage, UriKind.Relative));
}
}
}
