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