public bool CheckAngle(CupboardAngle cupboardAngle)
{
if ((OurOrder.GetQuantityCode(cupboardAngle.Code) + cupboardAngle.CountComponents()) < cupboardAngle.AvailableStock + 1)
{
return(true);
}
return(false);
}
public static CupboardAngle SearchCupboardAngle(int height, string color, MySqlConnection conn)
{
CupboardAngle cupboardAngle;
conn.Open();
if (height % 36 == 0 || height % 46 == 0 || height % 56 == 0)
{
var cupboardReader = MethodsDB.DataBaseMethods.SqlSearchComponent("Piece", "Ref", "hauteur", "Couleur", "Couleur", "Cornieres", height.ToString(), color, color, conn);
cupboardReader.Read();
cupboardAngle = new CupboardAngle(cupboardReader.GetString("Couleur"), cupboardReader.GetInt32("hauteur"), cupboardReader.GetInt32("largeur"), cupboardReader.GetInt32("profondeur"), cupboardReader.GetInt32("Enstock"), cupboardReader.GetInt32("Stock minimum"), cupboardReader.GetString("Code"), cupboardReader.GetString("Dimensions(cm)"));
cupboardReader.Close();
}
else
{
var reader = MethodsDB.DataBaseMethods.SqlSearchCupboardAngle(color, height, conn);
Dictionary <string, string> min = new Dictionary <string, string>()
{
{ "Height", "50000" }
};
while (reader.Read())
{
if (int.Parse(reader["hauteur"].ToString()) < int.Parse(min["Height"]))
{
min = new Dictionary <string, string>()
{
{ "Ref", reader["Ref"].ToString() },
{ "Code", reader["Code"].ToString() },
{ "Dimensions", reader["Dimensions(cm)"].ToString() },
{ "Height", reader["hauteur"].ToString() },
{ "Width", reader["largeur"].ToString() },
{ "Depth", reader["profondeur"].ToString() },
{ "Color", reader["Couleur"].ToString() },
{ "Stock", reader["Enstock"].ToString() },
{ "StockMin", reader["Stock minimum"].ToString() },
{ "SupplierOnePrice", reader["Prix-Fourn 1"].ToString() },
{ "SupplierTwoPrice", reader["Prix-Fourn2"].ToString() },
{ "SupplierOneDelay", reader["Delai-Fourn 1"].ToString() },
{ "SupplierTwoDelay", reader["Delai-Fourn2"].ToString() },
};
}
}
Console.WriteLine($"Cupboard angle fund :{min["Height"]} cm !");
cupboardAngle = new CupboardAngle(min["Color"], int.Parse(min["Height"]), int.Parse(min["Width"]), int.Parse(min["Depth"]), int.Parse(min["Stock"]), int.Parse(min["StockMin"]), min["Code"], min["Dimensions"]);
reader.Close();
}
conn.Close();
return(cupboardAngle);
}
private void CheckCupboard()
{
if (Cupboard.CountBox() > 0)
{
if (pepCombobox6.SelectedItem.ToString() != "Undefined")
{
CupboardAngle cupboardAngle = GetGoodCupAngle();
if (cupboardAngle is null)
{
AddChat($"✗ We are very sorry, we cannot find CupboardAngle. Please select an another one.", Color.Red);
return;
}
if (MainTreeView.CheckAngle(cupboardAngle))
{
Cupboard.CupboardAngle = cupboardAngle;
if (Cupboard.CheckState() == "Completed ✓")
{
MainTreeView.UpdateTag(Uid, "true");
AddChat($"✓ Your cupboard (height: {Cupboard.GetSizes()["Height"]} cm, width: {Cupboard.GetSizes()["Width"]} cm, depth: {Cupboard.GetSizes()["Depth"]} cm) is approved !", Color.White);
}
else
{
MainTreeView.UpdateTag(Uid, null);
AddChat("Your cupboard is approved but some components are missing!", Color.White);
}
}
else
{
AddChat($"We are very sorry, your CupboardAngle ({cupboardAngle.Code}) is no longer available. Please continue, pay a deposit and get your order later or select an another CupboardAngle.", Color.Red);
pepButton5.Visible = true;
}
}
else
{
AddChat($"✗ Please select your angle color !", Color.Red);
}
}
else
{
AddChat($"✗ We are very sorry, your Cupboard contains 0 box. Please make your box.", Color.Red);
}
}
