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)); } } }