private void button_cart_Click(object sender, EventArgs e) { if (numericUpDown_quantity.Value > 0 && listBox_products.Items.Count == 1) { ItemModel item = null; using (SqlConnection sqlConn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\MarotoDB.mdf;Integrated Security=True;")) { using (SqlCommand sqlCommand = new SqlCommand()) { sqlCommand.Parameters.AddWithValue("id", textBox_id.Text); sqlCommand.CommandText = "SELECT * FROM PRODUCT WHERE ID = @id"; sqlCommand.Connection = sqlConn; sqlConn.Open(); SqlDataReader dataReader; dataReader = sqlCommand.ExecuteReader(); if (dataReader.Read()) { ProductModel product = new ProductModel(Int32.Parse(dataReader["ID"].ToString()), dataReader["NAME"].ToString(), dataReader["PROVIDER"].ToString(), Convert.ToDateTime(dataReader["EXPIRATION_DATE"].ToString()), Int32.Parse(dataReader["QUANTITY"].ToString()), Decimal.Parse(dataReader["PURCHASE_PRICE"].ToString()), Decimal.Parse(dataReader["SALE_PRICE"].ToString()), dataReader["DESCRIPTION"].ToString()); item = new ItemModel(10, product, Int32.Parse(numericUpDown_quantity.Value.ToString())); } sqlConn.Close(); } } updateSale(item); } }
private void updateSale(ItemModel item) { listBox_saleItems.Items.Clear(); bool containsIntem = saleItems.Contains(item); if (containsIntem) { foreach (ItemModel model in saleItems) { if (model.Equals(item)) { model.Quantity += item.Quantity; model.Parcial = model.Quantity * model.Product.SalePrice; } } } else { saleItems.Add(item); } decimal total = 0; foreach (ItemModel model in saleItems) { listBox_saleItems.Items.Add(model.Product.ProductName + " " + model.Quantity + " " + model.Parcial); total += model.Parcial; } label_value.Text = total.ToString(); }