Exemple #1
0
        /// <summary>
        /// Регистрация
        /// </summary>
        /// <param name="user"></param>
        /// <returns></returns>
        public String Regisrg(UserRegistr user)
        {
            if (!user.noNull())
            {
                return("Data empty");
            }
            if (CheckReg(user.user.login))
            {
                return("This login is already used");
            }
            MySqlCommand comm = Connection();

            String CommStr = "INSERT INTO user (login, password, address, name, last_name) VALUES ('" + user.user.login + "', '" + user.user.password + "', '" + user.address + "', '" + user.name + "', '" + user.last_name + "' );";

            try
            {
                comm.Connection.Open();

                comm.CommandText = CommStr;
                comm.ExecuteNonQuery();
            }
            catch (MySqlException ex)
            {
                return("Error: \r\n{0}" + ex.ToString());
            }
            finally
            {
                comm.Connection.Close();
            }
            return("Готово!");
        }
Exemple #2
0
        public MakeOrder(Controller controller, UserRegistr curUser)
        {
            InitializeComponent();

            this.controller = controller;
            this.user       = curUser;

            this.product = controller.LoadProduct();
            category     = controller.LoadCategory();
            //category = new List<UserCategory>();

            //int i = 0;
            //foreach (UserProduct tmpProduct in this.product)
            //{
            //    if (i > 1 && category[i - 1].id == tmpProduct.category.id)
            //    {
            //        break;
            //    }
            //    else
            //    {
            //        category.Add(tmpProduct.category);
            //    }
            //    i++;
            //}
            listProduct = new Dictionary <UserProduct, int>();
        }
Exemple #3
0
        private void LoadDataGredOrder(int row)
        {
            dataGridOrder.Rows.Clear();
            int idUser = (int)dataGridUser.Rows[row].Cells[0].Value;

            foreach (List <UserOrder> tmpList in order)
            {
                if (tmpList.Count != 0)
                {
                    if (tmpList[0].user.id == idUser)
                    {
                        curUser = tmpList[0].user;
                        foreach (UserOrder tmpOrder in tmpList)
                        {
                            dataGridOrder.Rows.Add(tmpOrder.id, tmpOrder.date, tmpOrder.pickup, tmpOrder.cash);
                        }
                        break;
                    }
                }
                else
                {
                    dataGridOrder.Rows.Add("Пусто");
                }
            }
        }
Exemple #4
0
        public string Registr(UserRegistr user)
        {
            Hash hash = new Hash(user.user.password);

            user.user.password = hash.sum;

            return(db.Regisrg(user));
        }
Exemple #5
0
 public Client(UserRegistr user)
 {
     Id        = user.id;
     Login     = user.user.login;
     Name      = user.name;
     Address   = user.address;
     Last_name = user.last_name;
     Order     = new List <model.Order>();
 }
Exemple #6
0
 private int idClient(UserRegistr user)
 {
     for (int i = 0; i < client.Count; i++)
     {
         if (client[i].Id == user.id)
         {
             return(i);
         }
     }
     return(0);
 }
Exemple #7
0
        public List <UserOrder> LoadOrder(UserRegistr user)
        {
            List <UserOrder> order;

            order = db.LoadOrder(user);
            int i = idClient(user);

            foreach (UserOrder tmpOrder in order)
            {
                client[i].AddOrder(new Order(tmpOrder));
            }
            return(order);
        }
Exemple #8
0
        private void makeOrder_Click(object sender, EventArgs e)
        {
            if (status == false)
            {
                curUser = user[0];
            }
            MakeOrder    makeOrder = new MakeOrder(controller, curUser);
            DialogResult result    = makeOrder.ShowDialog();

            if (makeOrder.DialogResult == DialogResult.OK)
            {
                MessageBox.Show(makeOrder.result);
                loadOrder();
                LoadDataGredOrder(0);
            }
        }
Exemple #9
0
        public List <UserOrder> LoadOrder(UserRegistr tmpUser)
        {
            List <UserOrder> order = new List <UserOrder>();
            String           str;
            MySqlCommand     comm = Connection();

            String CommOrderStr   = "select * from orders where user in (select id from user ";
            String CommProductStr = "select orders.id, product.*, orders_product.count, category.* from category, orders right join orders_product on orders_product.orders = orders.id right join product on product.id = orders_product.product where product.category = category.id and orders.user in (select id from user ";

            if (!tmpUser.user.compareAdmin())
            {
                str = "where login = '******');";
            }
            else
            {
                str = ")";
            }
            CommOrderStr   += str;
            CommProductStr += str;

            MySqlDataReader reader;

            try
            {
                comm.Connection.Open();

                comm.CommandText = CommOrderStr;
                reader           = comm.ExecuteReader();
                while (reader.Read())
                {
                    UserOrder tmpOrder;
                    tmpOrder.id      = reader.GetInt32(0);
                    tmpOrder.date    = reader.GetString(1);
                    tmpOrder.pickup  = (reader.GetInt32(3) == 1) ? true : false;
                    tmpOrder.cash    = (reader.GetInt32(4) == 1) ? true : false;
                    tmpOrder.user    = tmpUser;
                    tmpOrder.product = new Dictionary <UserProduct, int>();
                    order.Add(tmpOrder);
                }
                reader.Close();

                comm.CommandText = CommProductStr;
                reader           = comm.ExecuteReader();
                while (reader.Read())
                {
                    foreach (UserOrder tmpOrder in order)
                    {
                        if (tmpOrder.id == reader.GetInt32(0))
                        {
                            UserProduct tmpProduct;
                            tmpProduct.id                   = reader.GetInt32(1);
                            tmpProduct.name                 = reader.GetString(2);
                            tmpProduct.cost                 = reader.GetInt32(3);
                            tmpProduct.description          = reader.GetString(5);
                            tmpProduct.category.id          = reader.GetInt32(7);
                            tmpProduct.category.name        = reader.GetString(8);
                            tmpProduct.category.description = reader.GetString(9);

                            tmpOrder.product.Add(tmpProduct, reader.GetInt32(6));
                        }
                    }
                }
                reader.Close();
            }
            catch (MySqlException ex)
            {
                Console.WriteLine("Error: \r\n{0}", ex.ToString());
            }
            finally
            {
                comm.Connection.Close();
            }
            return(order);
        }