Exemple #1
0
        public ProductQrcodewithType GetByQrcode(string Qr, int user_id)
        {
            ProductQrcodewithType X = new ProductQrcodewithType();


            X = _con.ProductQrcodes.Include(p => p.Types).FirstOrDefault(st => st.Qrcode == Qr);
            if (X != null)
            {
                if (_con.Stocks.FirstOrDefault(s => s.product == X) != null)
                {
                    X.Stock(_con.Stocks.FirstOrDefault(s => s.product == X).Value);
                }

                for (int i = 0; i < X.Types.Count(); i++)
                {
                    var test = _con.StocksOfType.FirstOrDefault(s => s.Type == X.Types[i]);
                    if (test != null)
                    {
                        X.Stock(test.Value);
                    }
                }
            }
            User U = new User();

            U = _con.Users.Include(p => p.userClass).FirstOrDefault(st => st.ID == user_id);
            if (U != null)
            {
                var res = _con.StocksByClass.Include(p => p.products).FirstOrDefault(s => s._class == U.userClass);
                if (res != null)
                {
                    if (res.products.FirstOrDefault(p => p == X) != null)
                    {
                        X.Stock(_con.StocksByClass.FirstOrDefault(s => s._class == U.userClass).Value);
                    }
                }
            }

            /*
             * for (int i =0; i< _con.Stocks.Count(); i++)
             * {
             *  if (_con.Stocks[i].product == X ) { X.Stock(_con.Stocks[i].Value); }
             * }
             *
             * for (int i = 0; i < _con.StocksOfType.Count(); i++)
             * {
             *  for (int j = 0; j < X.Types.Count(); j++)
             *  {
             *      if (_con.StocksOfType[i].Type.name == X.Types[j]  ) { X.Stock(_con.StocksOfType[i].Value); }
             *  }
             * }
             */

            return(X);
        }
Exemple #2
0
        public mok_product()
        {
            ProductQrcodewithType adition = new ProductQrcodewithType();

            adition.Name      = "Moloco";
            adition.Price     = 500;
            adition.id        = 1;
            adition.Qrcode    = "4600819351681";
            adition.Producter = new Producter();
            adition.Types     = new List <TypeProduct>();

            Products = new List <ProductQrcodewithType>()
            {
                adition
            };
        }
Exemple #3
0
        public ProductQrcodewithType getbyID(int id, int user_id)
        {
            ProductQrcodewithType X = new ProductQrcodewithType();

            X = _con.ProductQrcodes.Include(p => p.Image).Include(p => p.Types).FirstOrDefault(st => st.id == id);
            _con.ProductQrcodes.Where(p => p.Image == X.Image).Load();
            if (X != null)
            {
                if (_con.Stocks.FirstOrDefault(s => s.product == X) != null)
                {
                    X.Stock(_con.Stocks.FirstOrDefault(s => s.product == X).Value);
                }

                for (int i = 0; i < X.Types.Count(); i++)
                {
                    var test = _con.StocksOfType.FirstOrDefault(s => s.Type == X.Types[i]);
                    if (test != null)
                    {
                        X.Stock(test.Value);
                    }
                }
            }

            User U = new User();

            U = _con.Users.FirstOrDefault(st => st.ID == user_id);

            if (_con.StocksByClass.FirstOrDefault(s => s._class == U.userClass).products.FirstOrDefault(p => p == X) != null)
            {
                X.Stock(_con.StocksByClass.FirstOrDefault(s => s._class == U.userClass).Value);
            }

            /*
             *
             *
             *
             *  for (int i = 0; i < _con.StocksOfType.Count(); i++)
             *  {
             *      for (int j = 0; j < X.Types.Count(); j++)
             *      {
             *          if (_con.StocksOfType[i].Type.name == X.Types[j] ) { X.Stock(_con.StocksOfType[i].Value); }
             *      }
             *  }
             */
            return(X);
        }
Exemple #4
0
        public List <ProductQrcodewithType> ShowStocksProdukts(string Qr)
        {
            ProductQrcodewithType X = new ProductQrcodewithType();

            X = _con.ProductQrcodes.FirstOrDefault(st => st.Qrcode == Qr);
            List <ProductQrcodewithType> Y = new List <ProductQrcodewithType>();

            Stock1_1 s = _con.Stocks1_1.FirstOrDefault(t => t.products.FirstOrDefault(s => s == X) != null);

            if (s != null)
            {
                var z = s.products.Where(t => t != X);

                foreach (ProductQrcodewithType t in z)
                {
                    Y.Add(t);
                }

                for (int k = 0; k < Y.Count(); k++)
                {
                    Y[k].Stock(s.Value);
                }
            }


            /*
             * for (int i = 0; i < _con.Stocks1_1.Count(); i++)
             * {
             *  for (int j = 0; j < _con.Stocks1_1[i].products.Count(); j++) {
             *
             *      if (_con.Stocks1_1[i].products[j] == X) {
             *
             *          for (int k = 0; k < _con.Stocks1_1[i].products.Count(); k++)
             *              if (_con.Stocks1_1[i].products[k] != X)
             *              {
             *                  Y.Add(_con.Stocks1_1[i].products[k]);
             *                  l++;
             *                  Y[l].Stock(_con.Stocks1_1[i].Value);
             *              }
             *      }
             *  }
             * }
             */
            return(Y);
        }