Beispiel #1
0
        private void Save_Click(object sender, EventArgs e)
        {
            bool b = IsInList(edname.Text);

            if (b == false)
            {
                path = SqlClass.Path();
                var db = new SQLiteConnection(path);
                db.CreateTable <ScoreClass>();
                person = new ScoreClass(edname.Text, 1, edphone.Text);

                Toast.MakeText(this, person.ToString(), ToastLength.Short).Show();

                count++;
                db.Insert(person);
                Toast.MakeText(this, "insert record", ToastLength.Short).Show();
            }
        }
Beispiel #2
0
        public static bool IsInList(string name)
        {
            var db = new SQLiteConnection(SqlClass.Path());

            var players = db.Query <ScoreClass>(SqlClass.StringBuilder());

            List <string> mygamelist = new List <string>();

            if (players != null && players.Count > 0)
            {
                foreach (var item in players)
                {
                    if (item.name == name)
                    {
                        item.IncScore();
                        db.Update(item);
                        return(true);
                    }
                }
            }
            return(false);
        }