示例#1
0
        /*
         * 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();
            };
        }
示例#2
0
        /*
         * 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");
            }
        }