示例#1
0
        private void Form1_Load(object sender, EventArgs e)
        {
            var         client = new Summator.SummatorClient("NetTcpBinding_ISummator");
            List <User> users  = GetUsers();

            foreach (User i in users)
            {
                Console.WriteLine(i.ID + " : " + i.Login);
            }
        }
示例#2
0
        private void buttonAuthor_Click(object sender, EventArgs e)
        {
            var  log     = login.Text;
            var  passw   = password.Text;
            User newUser = new User(log, passw);
            int  count   = 0;
            var  conn    = new NpgsqlConnection(connectionString);
            var  client  = new Summator.SummatorClient("NetTcpBinding_ISummator");

            try
            {
                conn.Open();

                List <User> users = GetUsers();

                foreach (User user in users)
                {
                    if (user.Login == newUser.Login && user.Password == newUser.Password)
                    {
                        count++;
                    }
                }

                if (count == 0)
                {
                    Console.WriteLine("Пользователя нет в системе ");
                }
                else
                {
                    Console.WriteLine("Пользователm в системе ");
                }
                count = 0;

                conn.Close();
            }
            catch (Exception ex)
            {
                conn.Close();
                MessageBox.Show("Ошибка  " + ex.Message);
            }

            client.Close();


            // ДЛЯ РЕГИСТРАЦИИ. ДОБАВЛЕНИЕ USER В БД

            //var log = login.Text;
            //var passw = password.Text;
            //var conn = new NpgsqlConnection(connectionString);
            //var client = new Summator.SummatorClient("NetTcpBinding_ISummator");

            ////User newUser = new User(log, passw);
            //try
            //{
            //    conn.Open();
            //    sql = @"select* from my_insert(@_login,@_password)";
            //    var cmd = new NpgsqlCommand(sql, conn);
            //    cmd.Parameters.AddWithValue(@"_login", log);
            //    cmd.Parameters.AddWithValue(@"_password", passw);
            //    if ((int)cmd.ExecuteScalar() == 1)
            //    {
            //        MessageBox.Show("Пользователь добавлен");

            //    }
            //    conn.Close();
            //}
            //catch (Exception ex)
            //{
            //    conn.Close();
            //    Console.WriteLine("Ошибка" + ex.Message);
            //    MessageBox.Show("Ошибка при добавлении : " + ex.Message);
            //}

            //client.Close();
        }