/* * Nacist hru pro vedouciho */ void NacistHruVzhled() { mujprofil.Children.Clear(); MySqlCommand prikaz = new MySqlCommand("Select nazev from bakalarka.hra;"); prikaz.Parameters.AddWithValue("@id", Hrac.iduzivatel); MySqlDataReader data = DBConnector.ProvedeniPrikazuSelect(prikaz); Picker seznamBox = new Picker() { Title = "Název", VerticalOptions = LayoutOptions.CenterAndExpand }; while (data.Read()) { seznamBox.Items.Add(data["nazev"].ToString()); } Grid.SetColumnSpan(seznamBox, 2); Grid.SetRow(seznamBox, 1); Grid.SetColumn(seznamBox, 1); mujprofil.Children.Add(seznamBox); var nazevlbl = new Label { Text = "název:" }; mujprofil.Children.Add(nazevlbl, 0, 1); var nacist = new Button() { Text = "Načíst hru", BackgroundColor = Color.RoyalBlue, TextColor = Color.DarkGray, FontSize = 15, CornerRadius = 4, BorderColor = Color.DarkGray, BorderWidth = 2 }; Grid.SetColumnSpan(nacist, 3); Grid.SetRow(nacist, 2); Grid.SetColumn(nacist, 0); mujprofil.Children.Add(nacist); nacist.Clicked += async(sender, args) => { if (seznamBox.SelectedIndex == -1) { await DisplayAlert("Chyba", "Musí být vybrán název hry!", "Zavřít"); } else { Hra.idHry(seznamBox.Items[seznamBox.SelectedIndex]); Hra.nacteniHry(Hra.idhry); Hra.AktualizacePolohy(); MujProfilVedouci(); } }; var zpet = new Button() { Text = "Zpět", BackgroundColor = Color.DarkGray, TextColor = Color.RoyalBlue, FontSize = 15, CornerRadius = 4, BorderColor = Color.RoyalBlue, BorderWidth = 2 }; Grid.SetColumnSpan(zpet, 3); Grid.SetRow(zpet, 3); Grid.SetColumn(zpet, 0); mujprofil.Children.Add(zpet); zpet.Clicked += async(sender, args) => { MujProfilVedouci(); }; }
/* * prihlaseni hrace do aplikace */ static public String Prihlaseni(int id, String heslo) { Hra.stavZivotu = new Label() { HorizontalOptions = LayoutOptions.Start, VerticalOptions = LayoutOptions.Center, FontSize = 15, TextColor = Color.Black }; Hra.invObsah = new Label() { HorizontalOptions = LayoutOptions.StartAndExpand, VerticalOptions = LayoutOptions.Center, FontSize = 15, TextColor = Color.Black }; MySqlCommand prikaz = new MySqlCommand("SELECT * FROM bakalarka.uzivatel WHERE heslo=@heslo and iduzivatel=@id; "); prikaz.Parameters.AddWithValue("@heslo", heslo); prikaz.Parameters.AddWithValue("@id", id); MySqlDataReader data = DBConnector.ProvedeniPrikazuSelect(prikaz); if (data.HasRows) { while (data.Read()) { iduzivatel = (int)data["iduzivatel"]; jmeno = data["iduzivatel"].ToString(); role = (int)data["role"]; zivot = (int)data["zivot"]; if (Hrac.role == 0)//vedouci nema tym { Hrac.tym = 0; } else { tym = (int)data["tym"]; } if (Hrac.role != 0)// nacteni hry a inventare { MySqlCommand prikazNacteniHry = new MySqlCommand("Select hra from tym where idtym=@idtym;"); prikazNacteniHry.Parameters.AddWithValue("@idtym", tym); MySqlDataReader dataNacteni = DBConnector.ProvedeniPrikazuSelect(prikazNacteniHry); dataNacteni.Read(); Hra.nacteniHry((int)dataNacteni["hra"]); Hra.AktualizacePolohy(); if (!Convert.IsDBNull(data["inventar"])) { inventarNazev = Hra.produkty.Find(x => x.id == (int)data["inventar"]).nazev; inventar = (int)data["inventar"]; } } prihlaseny = true; } return(null); } else { return("Neco se nepovedlo pri prihlaseni"); } }