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();
}
