public Angle(int len, string color, int qty)
{
Oledb.Connection();
length = len;
angleColor = color;
// Getting the stock reference by the length and color
stockRef = Oledb.SqlRequest("SELECT Référence FROM Piece WHERE Référence LIKE 'COR%' AND hauteur = " + length.ToString() + " AND Couleur = '" + angleColor + "'");
quantity = qty;
CalculPrice();
// Updating the reservation in the data base
Oledb.UpdateReservation(quantity, stockRef);
stock = Oledb.GetDBStock(stockRef);
}
private void Form1_Load(object sender, EventArgs e) //Connection to the DB and loading the data into the box
{
Oledb.Connection();
Loaddata();
}
private void LoadList(object sender, EventArgs e) //loading data
{
Oledb.Connection();
Loaddata();
}