public Response Update(ProductIncomeDetail productIncomeDetail) { Response response = new Response(); SqlConnection connection = new SqlConnection(); connection.ConnectionString = ConnectionHelper.GetConnectionString(); SqlCommand command = new SqlCommand(); command.CommandText = "UPDATE PRODUCTS_INCOME_DETAILS SET PRECO = @PRECO, QUANTIDADE = @QUANTIDADE WHERE ID = @ID"; command.Parameters.AddWithValue("@PRECO", productIncomeDetail.Price); command.Parameters.AddWithValue("@QUANTIDADE", productIncomeDetail.Quantity); command.Parameters.AddWithValue("@ID", productIncomeDetail.IDProductIncome); command.Connection = connection; try { connection.Open(); command.ExecuteNonQuery(); response.Success = true; response.Message = "Atualizado com sucesso."; } catch (Exception ex) { response.Success = false; response.Message = "Erro no banco de dados, contate o administrador."; response.StackTrace = ex.StackTrace; response.ExceptionError = ex.Message; } finally { connection.Close(); } return(response); }
public SingleResponse <int> InsertProductIncomeDetail(ProductIncomeDetail productIncomeDetail) { SingleResponse <int> response = new SingleResponse <int>(); SqlConnection connection = new SqlConnection(); connection.ConnectionString = ConnectionHelper.GetConnectionString(); SqlCommand command = new SqlCommand(); command.CommandText = "INSERT INTO PRODUCTS_INCOME_DETAILS (IDPRODUCTS_INCOME, IDPRODUCTS, PRECO, QUANTIDADE) VALUES (@IDPRODUCTS_INCOME, @IDPRODUCTS, @PRECO, @QUANTIDADE) SELECT SCOPE_IDENTITY()"; command.Parameters.AddWithValue("@IDPRODUCTS_INCOME", productIncomeDetail.IDProductIncome); command.Parameters.AddWithValue("@IDPRODUCTS", productIncomeDetail.IDProduct); command.Parameters.AddWithValue("@PRECO", productIncomeDetail.Price); command.Parameters.AddWithValue("@QUANTIDADE", productIncomeDetail.Quantity); command.Connection = connection; try { connection.Open(); int idGerado = Convert.ToInt32(command.ExecuteScalar()); response.Success = true; response.Message = "Cadastrado com sucesso."; response.Data = idGerado; } catch (Exception ex) { response.Success = false; response.Message = "Erro no banco de dados, contate o administrador."; response.StackTrace = ex.StackTrace; response.ExceptionError = ex.Message; } finally { connection.Close(); } return(response); }
private void ProductPriceAtt(ProductIncomeDetail item) { ProductBLL productBLL = new ProductBLL(); Storage storage = new Storage(); storage.ProductsID = item.IDProduct; double qtdProductsStorage = Convert.ToDouble(storageDAO.GetQuantityByIDProducts(item).Data); double productPrice = Convert.ToDouble(productBLL.GetPriceByID(item.IDProduct)); double qtdProductsEntry = item.Quantity; double products = ((qtdProductsStorage * productPrice) + (qtdProductsEntry * item.Price)) / qtdProductsStorage + qtdProductsEntry; productBLL.UpdatePrice(item.IDProduct, products); }
private void btnInsertProductsIncomeDetail_Click(object sender, EventArgs e) { ProductIncomeDetail productIncomeDetail = new ProductIncomeDetail(); productIncomeDetail.IDProduct = product.ID; productIncomeDetail.Price = Convert.ToDouble(txtPrice.Text); productIncomeDetail.Quantity = Convert.ToDouble(txtQuantity.Text); productIncome.Items.Add(productIncomeDetail); MessageBox.Show("Produto vinculado com sucesso!"); if (productIncome.Items.Count == 0) { MessageBox.Show("É necessário vincular produtos."); } }
public SingleResponse <Storage> GetQuantityByIDProducts(ProductIncomeDetail productIncomeDetail) { SingleResponse <Storage> response = new SingleResponse <Storage>(); SqlConnection connection = new SqlConnection(); connection.ConnectionString = ConnectionHelper.GetConnectionString(); SqlCommand command = new SqlCommand(); command.CommandText = "SELECT QUANTIDADE FROM STORAGE WHERE IDPRODUCTS = @IDPRODUCTS"; command.Parameters.AddWithValue("@IDPRODUCTS", productIncomeDetail.IDProduct); command.Connection = connection; try { connection.Open(); SqlDataReader reader = command.ExecuteReader(); Storage storage = new Storage(); if (!reader.Read()) { response.Quantity = 0; return(response); } while (reader.Read()) { response.Quantity = (double)reader["QUANTIDADE"]; } response.Success = true; response.Message = "Dados selecionados com sucesso."; return(response); } catch (Exception ex) { response.Success = false; response.Message = "Erro no banco de dados contate o adm."; response.ExceptionError = ex.Message; response.StackTrace = ex.StackTrace; return(response); } finally { connection.Close(); } }
public SingleResponse <Storage> AddProduct(ProductIncomeDetail item) { SingleResponse <Storage> singleResponse = new SingleResponse <Storage>(); Storage storage = new Storage(); storage.ProductsID = item.IDProduct; StorageDAO storageDAO = new StorageDAO(); if (storageDAO.GetQuantityByIDProducts(item).Quantity == 0) { item.Quantity = storageDAO.GetQuantityByIDProducts(item).Quantity; storage.Quantity = item.Quantity; Update(storage); } else if (storageDAO.GetQuantityByIDProducts(item).Quantity > 0) { ProductPriceAtt(item); item.Quantity += storageDAO.GetQuantityByIDProducts(item).Quantity; storage.Quantity = item.Quantity; Update(storage); } return(singleResponse); }