private void button1_Click(object sender, EventArgs e) { form.OpenConnection(); //supprime les pièces dans la base de donnée DeleteParts(); //renvoie la facture CupBoard cupBoard = form.GetCupBoard(form.connection, GetFkOrder()); int lockerNumber = cupBoard.GetLockerList().Count(); string colorExtrusion = cupBoard.GetExtrusion().GetColor(); string path = @"/Users/Fatine/source/Bill.txt"; using (StreamWriter sw = File.CreateText(path)) { sw.WriteLine("BILL"); //ajouter le prénom et la date? sw.WriteLine(" "); sw.WriteLine("You bought 1 cupboard with " + lockerNumber + " locker(s)."); sw.WriteLine(" "); int i = 1; foreach (Locker locker in cupBoard.GetLockerList()) { sw.WriteLine("Locker n°" + i + ": "); sw.WriteLine("Color: " + locker.GetColor() + " Price: " + locker.GetPrice(form.connection)); if (locker.HasDoor()) { if (locker.GetDoor().GetColor() == "glass") { sw.WriteLine(" This locker has 2 glass doors"); } else { sw.WriteLine(" This locker has 2 " + locker.GetDoor().GetColor() + " wood doors "); } } else { sw.WriteLine(" "); } sw.WriteLine(" "); i++; } sw.WriteLine("Corner : "); sw.WriteLine("Color: " + colorExtrusion + " Price : " + cupBoard.GetExtrusion().GetPrice(form.connection)); sw.WriteLine(" "); sw.WriteLine("Total : " + cupBoard.GetPrice(form.connection) + "euros"); } form.CloseConnection(); }
public CupBoard GetCupBoard(MySqlConnection connection, int FkOrder) { List <Locker> lockerList = GetLockerList(connection, FkOrder); List <int> idLockers = GetLockersID(connection, FkOrder); int idLocker = idLockers[0]; Dictionary <string, string> lockerAttribute = GetLockerAttribute(connection, FkOrder, idLocker); string color = lockerAttribute["color"]; double width = Convert.ToDouble(lockerAttribute["width"]); double depth = Convert.ToDouble(lockerAttribute["depth"]); Extrusion extrusion = GetExtrusion(FkOrder, idLocker); CupBoard cupBoard = new CupBoard(width, depth, lockerList, extrusion); double extrusionHeight = cupBoard.GetTotalHeight(); cupBoard.GetExtrusion().SetHeight(extrusionHeight); return(cupBoard); }
private void button4_Click(object sender, EventArgs e) { form.OpenConnection(); CupBoard cupBoard = form.GetCupBoard(form.connection, GetFkOrder()); int lockerNumber = cupBoard.GetLockerList().Count(); string colorExtrusion = cupBoard.GetExtrusion().GetColor(); string path = @"/Users/Fatine/source/DetailParts.txt"; using (StreamWriter sw = File.CreateText(path)) { sw.WriteLine("DETAIL PARTS"); sw.WriteLine(" "); sw.WriteLine("there is in this order: 1 cupboard with " + lockerNumber + " locker(s)."); sw.WriteLine(" "); int i = 1; foreach (Locker locker in cupBoard.GetLockerList()) { sw.WriteLine("Locker n°" + i + " "); sw.WriteLine("Color: " + locker.GetColor() + " Price: " + locker.GetPrice(form.connection) + " euros"); sw.WriteLine(" Parts : "); foreach (Accessory access in locker.GetAccessoryList()) { string availability; if (access.GetInstock(form.connection) > 1) { availability = "available"; } else { availability = "not available"; } sw.WriteLine(" Type : " + access.GetAccessType() + " color : " + GetRealColor(access.GetColor()) + " dimensions : " + GetDimension(access.GetHeight(), access.GetWidth(), access.GetDepth()) + " price : " + access.GetPrice(form.connection) + " euros" + " " + availability); } sw.WriteLine(" "); i++; } Extrusion extrusion = cupBoard.GetExtrusion(); string availabilityC; if (extrusion.GetInstock(form.connection) > 1) { availabilityC = "available"; } else { availabilityC = "not available"; } sw.WriteLine("Corner "); sw.WriteLine("Color: " + colorExtrusion + " height : " + extrusion.GetHeight() + " Price : " + extrusion.GetPrice(form.connection) + " euros " + " " + availabilityC); sw.WriteLine(" "); sw.WriteLine("Total : " + cupBoard.GetPrice(form.connection) + " euros"); } form.CloseConnection(); }
public void DeleteParts() { CupBoard cupBoard = form.GetCupBoard(form.connection, GetFkOrder()); string idPart = ""; int numberOfPart = 0; int InStock = 0; foreach (Kitbox.Locker locker in cupBoard.GetLockerList()) { foreach (Accessory access in locker.GetAccessoryList()) { //Prendre les references de toutes les parts d'un locker MySqlDataReader reader; MySqlCommand command = new MySqlCommand("SELECT Idpart FROM `kitboxdb2.0`.`parts` WHERE ref='" + access.GetRefDB() + "'AND height='" + Convert.ToString(access.GetHeight()) + "'AND width='" + Convert.ToString(access.GetWidth()) + "'AND depth='" + Convert.ToString(access.GetDepth()) + "'AND color='" + access.GetColorDB(access.GetColor()) + "'", form.connection); reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { idPart = reader.GetString(0); } } else { MessageBox.Show("there is no idPart in the datareader"); } reader.Close(); } } foreach (Kitbox.Locker locker in cupBoard.GetLockerList()) { foreach (Accessory access in locker.GetAccessoryList()) { MySqlDataReader reader3; MySqlCommand command3 = new MySqlCommand("SELECT PartForLocker FROM `kitboxdb2.0`.`parts` WHERE ref='" + access.GetRefDB() + "'AND height='" + Convert.ToString(access.GetHeight()) + "'AND width='" + Convert.ToString(access.GetWidth()) + "'AND depth='" + Convert.ToString(access.GetDepth()) + "'AND color='" + access.GetColorDB(access.GetColor()) + "'", form.connection); reader3 = command3.ExecuteReader(); if (reader3.HasRows) { while (reader3.Read()) { numberOfPart = Convert.ToInt32(reader3.GetString(0)); } } else { MessageBox.Show("there is no idPart in the datareader"); } reader3.Close(); } } foreach (Kitbox.Locker locker in cupBoard.GetLockerList()) { foreach (Accessory access in locker.GetAccessoryList()) { MySqlDataReader reader4; MySqlCommand command4 = new MySqlCommand("SELECT Instock FROM `kitboxdb2.0`.`parts` WHERE ref='" + access.GetRefDB() + "'AND height='" + Convert.ToString(access.GetHeight()) + "'AND width='" + Convert.ToString(access.GetWidth()) + "'AND depth='" + Convert.ToString(access.GetDepth()) + "'AND color='" + access.GetColorDB(access.GetColor()) + "'", form.connection); reader4 = command4.ExecuteReader(); if (reader4.HasRows) { while (reader4.Read()) { InStock = Convert.ToInt32(reader4.GetString(0)); } } else { MessageBox.Show("there is no idPart in the datareader"); } reader4.Close(); } } //retirer les parts liés à la commande. MySqlCommand command2 = new MySqlCommand("Update `kitboxdb2.0`.`parts` SET Instock= '" + (InStock - numberOfPart) + "' WHERE Idpart='" + idPart + "'", form.connection); command2.ExecuteNonQuery(); }
public void CompleteLinkedTable() { CupBoard cupBoard = Form1.GetCupBoard(); foreach (Kitbox.Locker locker in cupBoard.GetLockerList()) { foreach (Accessory access in locker.GetAccessoryList()) { //Prendre les references de toutes les parts d'un locker MySqlDataReader reader; MySqlCommand command = new MySqlCommand("SELECT Idpart FROM `kitboxdb2.0`.`parts` WHERE ref='" + access.GetRefDB() + "'AND height='" + Convert.ToString(access.GetHeight()) + "'AND width='" + Convert.ToString(access.GetWidth()) + "'AND depth='" + Convert.ToString(access.GetDepth()) + "'AND color='" + access.GetColorDB(access.GetColor()) + "'", form.connection); reader = command.ExecuteReader(); string idPart = ""; if (reader.HasRows) { while (reader.Read()) { idPart = reader.GetString(0); } } else { MessageBox.Show("there is no idPart in the datareader"); } reader.Close(); //insérer les IDPARTS dans la table linked, ainsi on sait quel type de part est concerné pour chaque locker --> facile pour faire -1 MySqlCommand command2 = new MySqlCommand("INSERT INTO `kitboxdb2.0`.`linked` (FkkOrder, FkkLocker,`FkkPart`) VALUES ('" + order.GetIdOrder() + " ', '" + Convert.ToString(locker.GetID()) + "', '" + idPart + "');", form.connection); command2.ExecuteNonQuery(); } } //Ajout de extrusion dans linked : une seule fois Extrusion extrusion = cupBoard.GetExtrusion(); double extrusionHeight = 0; if (extrusion.IsCut(extrusion.GetHeight())) { extrusionHeight = extrusion.GetExistingTopHeight(extrusion.GetHeight()); } else { extrusionHeight = extrusion.GetHeight(); } string refcor = "Cornières"; MySqlDataReader reader3; MySqlCommand command3 = new MySqlCommand("SELECT Idpart FROM `kitboxdb2.0`.`parts` WHERE ref='" + refcor + "'AND height='" + Convert.ToString(extrusionHeight) + "'AND color='" + extrusion.GetColorDB(extrusion.GetColor()) + "'", form.connection); reader3 = command3.ExecuteReader(); string idCor = ""; if (reader3.HasRows) { while (reader3.Read()) { idCor = reader3.GetString(0); } } else { MessageBox.Show("there is no extrusion in the datareader"); } reader3.Close(); //prendre nptqel id de locker int fkkLocker = cupBoard.GetLockerList()[0].GetID(); MySqlCommand command4 = new MySqlCommand("INSERT INTO `kitboxdb2.0`.`linked` (FkkOrder, FkkLocker,`FkkPart`) VALUES ('" + order.GetIdOrder() + "', '" + fkkLocker + "', '" + idCor + "');", form.connection); command4.ExecuteNonQuery(); }