コード例 #1
0
        public async Task <ActionResult <StockColor> > PostStockColor(StockColor stockColor)
        {
            _context.StockColors.Add(stockColor);
            await _context.SaveChangesAsync();

            return(CreatedAtAction("GetStockColors", new { id = stockColor.Id }, stockColor));
        }
        public void InsertIntoDataBase(IEnumerable <CreateProductsModel> list)
        {
            var repository = new ProductsRepository();

            foreach (var item in list)
            {
                var productlist = new Products();
                productlist.Category    = item.Category;
                productlist.ProductName = item.ProductName;
                productlist.UnitPrice   = item.Price;
                var _productID = repository.CreateProductDetail(productlist);


                var sizelist = new Size(); //productID
                sizelist.SizeType  = item.Size;
                sizelist.ProductID = _productID;
                var _sizeID = repository.CreateProductSize(sizelist);


                var StockColor = new StockColor();
                StockColor.Color  = item.Color;
                StockColor.Stock  = item.Stock;
                StockColor.SizeID = _sizeID;
                repository.CreateStockColor(StockColor);
            }
        }
コード例 #3
0
        //新增顏色、存貨
        public bool CreateStockColor(StockColor model)
        {
            SqlConnection connection = new SqlConnection(source.connectcloud);

            connection.Execute("INSERT INTO StockColor(SizeID , Color , Stock) Values(@SizeID , @Color , @Stock)", new {
                model.SizeID,
                model.Color,
                model.Stock
            });

            var result = connection.Query("SELECT SizeID ,Color ,Stock From StockColor Where SizeID = @SizeID  and Color = @Color and Stock = @Stock ", new
            {
                model.SizeID,
                model.Color,
                model.Stock
            });

            if (result.Count() > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
        public void Delete(StockColor model)
        {
            SqlConnection connection = new SqlConnection(source.connectcloud);
            var           sql        = "Delete FROM Products WHERE ColorID = @colorid";

            SqlCommand command = new SqlCommand(sql, connection);

            command.Parameters.AddWithValue("@colorid", model.ColorID);

            connection.Open();
            command.ExecuteNonQuery();
            connection.Close();
        }
        public void Update(StockColor model)
        {
            SqlConnection connection = new SqlConnection(source.connectcloud);
            var           sql        = "UPDATE StockColor SET ColorID = @colorid, SizeID=@sizeid, Color=@color,Stock=@stock";
            SqlCommand    command    = new SqlCommand(sql, connection);

            command.Parameters.AddWithValue("@colorid", model.ColorID);
            command.Parameters.AddWithValue("@sizeid", model.SizeID);
            command.Parameters.AddWithValue("@color", model.Color);
            command.Parameters.AddWithValue("@stock", model.Stock);

            connection.Open();
            command.ExecuteNonQuery();
            connection.Close();
        }
        public void Create(StockColor model)
        {
            SqlConnection connection = new SqlConnection(source.connectcloud);
            var           sql        = "INSERT INTO StockColor VALUES (@colorid, @sizeid,@color,@stock)";
            SqlCommand    command    = new SqlCommand(sql, connection);

            command.Parameters.AddWithValue("@colorid", model.ColorID);
            command.Parameters.AddWithValue("@sizeid", model.SizeID);
            command.Parameters.AddWithValue("@color", model.Color);
            command.Parameters.AddWithValue("@stock", model.Stock);

            connection.Open();
            command.ExecuteNonQuery();
            connection.Close();
        }
コード例 #7
0
        private void UpdateStatus(string text, StockColor color = StockColor.Disabled)
        {
            switch (color)
            {
            case StockColor.Green:
                labelForStatus.ForeColor = Color.FromArgb(0, 255, 0);
                break;

            case StockColor.Red:
                labelForStatus.ForeColor = Color.Red;
                break;

            case StockColor.Disabled:
                labelForStatus.ForeColor = Color.White;
                labelForStatus.Tag       = null;
                break;
            }
            labelForStatus.Text = text;
        }
コード例 #8
0
        private void UpdateStatus(string text, StockColor color = StockColor.Disabled)
        {
            switch (color)
            {
            case StockColor.Green:
                //labelForStatus.ForeColor = Color.FromArgb(128, 0, 0xCC, 0x99);
                labelForStatus.ForeColor = Color.White;
                break;

            case StockColor.Red:
                //labelForStatus.ForeColor = Color.FromArgb(128, 0xcc, 0x33, 0);
                labelForStatus.ForeColor = Color.White;
                break;

            case StockColor.Disabled:
                labelForStatus.ForeColor = Color.White;
                labelForStatus.Tag       = null;
                break;
            }
            labelForStatus.Text = text;
        }