Beispiel #1
0
        private async void button8_Click(object sender, EventArgs e)
        {
            var brand = await _brandManager.GetByName(cboBrand.Text);

            var category = await _categoryManager.GetByName(cboCategory.Text);

            if (brand == null)
            {
                brand = new Brand();
            }
            if (category == null)
            {
                category = new Category();
            }

            ProductDTO product = new ProductDTO()
            {
                AutomaticCode     = chkCode.Checked,
                AvailableStockStr = txtAvailableStock.Text,
                Brand             = Convert.ToString(brand.BrandID),
                Category          = Convert.ToString(category.CategoryID),
                Code                = txtCode.Text,
                CostStr             = txtCost.Text,
                MarkUpStr           = txtMarkup.Text,
                Name                = txtName.Text,
                SalesPriceStr       = txtSalesPrice.Text,
                AutomaticSalesPrice = chkSalesPrice.Checked
            };

            var result = await _productManager.Add(product);

            if (!result.IsSuccess)
            {
                MessageBox.Show(result.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
            else
            {
                ProductAudit productAudit = new ProductAudit()
                {
                    Quantity      = Convert.ToDecimal(txtAvailableStock.Text),
                    UserCreatedID = Global.User.UserID,
                    ProductID     = result.ID,
                    DateCreated   = DateTime.Now
                };
                await _productAuditManager.Add(productAudit);

                MessageBox.Show($@"Product { txtName.Text } added.", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
                Close();
            }
        }
Beispiel #2
0
        public async Task <Result> Add(ProductAudit productAudit)
        {
            var result = new Result();

            var sql =
                $@"INSERT INTO ProductAudit (ProductID, Quantity, DateCreated, UserCreatedID) VALUES (@ProductID, @Quantity, GETDATE(), @UserCreatedID)";
            var r = await _repositoryNgPinas.ExecuteAsync(sql,
                                                          new
            {
                ProductID     = productAudit.ProductID,
                Quantity      = productAudit.Quantity,
                UserCreatedID = productAudit.UserCreatedID
            });

            result.IsSuccess = r > 0;
            return(result);
        }