Exemple #1
0
        static void Main(string[] args)
        {
            BD.BDOpen();
            //bool tmp = myBD.AddPerson("vovaa", "12345dfvvg");
            bool tmp = BD.Update("vovaa", false);
            Console.WriteLine(tmp);
            //Console.WriteLine(BD.ShowInfo("vovaa"));
            //BD.Authorization("Masya", "bdc23");
            //BD.Authorization("Masya", "bdc123");
            //BD.AddPerson("Masya","bdc123");
            //BD.ShowInfo("Vasya");
            //BD.Update("Vasya", true);
            //BD.Update("Vasya", false);
            //BD.GetNumberOfGames("Vasya");
            Statistic stat = new Statistic();

            Console.ReadKey(true);
        }
Exemple #2
0
 public static MemoryStream ShowInfo(string name)
 {
     Statistic stat = new Statistic();
     SQLiteCommand command = connection.CreateCommand();
     command.CommandText = "SELECT * FROM 'Users' WHERE Name =@name";
     command.Parameters.Add(new SQLiteParameter("@name", @name));
     SQLiteDataReader reader = command.ExecuteReader();
     stat.id = reader["Id"].ToString(); ;
     stat.name = reader["Name"].ToString(); ;
     stat.all = Convert.ToInt32(reader["CntAll"]); ;
     stat.win = Convert.ToInt32(reader["CntWin"]); ;
     stat.lose = Convert.ToInt32(reader["CntLose"]); ;
     MemoryStream stream1 = new MemoryStream();
     DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(Statistic));
     ser.WriteObject(stream1, stat);
     return stream1;
     //Deserilization
         //stream1.Position = 0;
         //StreamReader sr = new StreamReader(stream1);
         //Console.Write("JSON form of Statistic object: ");
        // Console.WriteLine(sr.ReadToEnd());
 }