Exemplo n.º 1
0
        static void Main(string[] args)
        {
            try
            {
                Client client = new Client();
                //вход в систему
                Console.WriteLine("Log in - 1 or register - 2?");
                var input = Console.ReadLine();
                if (input == "1")
                    client = LoggingIn();
                else if (input == "2")
                {
                    Registration();
                    client.role = 1;
                }
                else
                    Environment.Exit(0);

                DaoFactory daofactory = new DaoFactory();
                var a = daofactory.GetRouterDao();

                RealSubject realSubject = new RealSubject();
                Proxy proxy = new Proxy(realSubject, client);

                //изменяем объект, а затем возвращаем предыдущее состояние
                RouterHistory routerHistory = new RouterHistory();

                Router router = new Router.Builder("tp link BIG", 4, 4).manufacturerContry(1).Encryption(2).macAdr("1234535312").Built();

                Console.WriteLine(router);
                routerHistory.History.Push(router.SaveState());

                Console.WriteLine();

                router.MAC_Adress = "NewMacAddres";
                Console.WriteLine(router);

                Console.WriteLine();

                router.RestoreState(routerHistory.History.Pop());
                Console.WriteLine(router);
                a.CreateRouter(router, proxy);
                a.UpdateRouter(router, "1111", proxy);

                Company company = new Company.Builder().AddName("microtk").Build();
                daofactory.GetCompanyDao().CreateCompany(company, proxy);

                ManufacturerCountry manufacturerCountry = new ManufacturerCountry.Builder().AddName("USA").Build();
                daofactory.GetManufacturerDao().CreateCountry(manufacturerCountry, proxy);
            }
            catch (Exception e)
            {
                Console.WriteLine("error" + e.Message + e.StackTrace);
            }
            finally
            {
                Connection.GetInstance().CloseConnection();
            }

            void Registration()
            {
                Console.WriteLine("Enter your login: "******"Enter your password: "******"INSERT INTO users (login, role_id, password) VALUES (""{0}"", ""{1}"", ""{2}"")", login, 1, password);
                using (var connection = Connection.GetInstance().GetConnection())
                {
                    connection.Open();
                    MySqlCommand command = new MySqlCommand(sqlexpression, connection);
                    int number = command.ExecuteNonQuery();
                    Console.WriteLine($"Added {number} elements");
                }
            }

            Client LoggingIn()
            {
                Console.WriteLine("Enter your login: "******"Enter your password: "******"SELECT role_id FROM users WHERE login = ""{0}"" and password=""{1}"" limit 1", login, password);
                using (var connection = Connection.GetInstance().GetConnection())
                {
                    connection.Open();
                    MySqlCommand command = new MySqlCommand(sqlexpression, connection);
                    var reader = command.ExecuteReader();
                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            clt = new Client();
                            clt.role = (int)reader.GetValue(0);
                        }
                    }
                    reader.Close();
                }
                return clt;
            }
        }
Exemplo n.º 2
0
 public Proxy(RealSubject realSubject, Client client)
 {
     this._realSubject = realSubject;
     this._client      = client;
 }