private string detailheight() { Dictionary <string, Object> Description = cupboard.GetDescription(); Console.WriteLine(String.Format("total height is {0}", ((int)Description["height"]).ToString())); return(((int)Description["height"]).ToString()); }
/*Builder*/ public Box(int height, string pannelsColor, Cupboard cupboard, string door) { this.height = height; this.pannelsColor = pannelsColor; this.hasdoor = (door == "No door") ? false : true; this.doorcolor = ((door == "No door") || (door == "Glass")) ? null : door; this.typedoor = (door == "Glass") ? "GlassDoor" : "ClassicDoor"; this.Cupboard = cupboard.GetDescription(); this.depth = Convert.ToInt32(Cupboard["depth"]); this.width = Convert.ToInt32(Cupboard["width"]); this.stock = new Stock("Server=localhost;Port=3306;Database=mykitbox;Uid=root;Pwd=; Connect Timeout=60"); BuildParts(); ComputePrice(); }
/***************************************************************************** * Pre : - Receives order's infos as parameters * * - Database server is on * * Post : - Calls make order for the cupboard * * - Creates the order in the database * * - Creates the client if he does not exist in the database yet * *****************************************************************************/ public void ConfirmOrder(string clientFirstName, string clientLastName, string adress, string zip, string phoneNumber, Cupboard cupboard) { /*First handles the order's identifiers (idcom and idclient)*/ int idCom = 0; Connect(); this.command.CommandText = "SELECT MAX(idcom) FROM client_partscommand"; try { string stepIDCom = command.ExecuteScalar().ToString(); Console.WriteLine("Command ID is :"); Console.WriteLine(stepIDCom); /* Command ID*/ idCom = Int32.Parse(stepIDCom) + 1; } /*Means that there is no command yet in database*/ catch (FormatException ex) { idCom = 1; Console.WriteLine("no command in the database yet."); Console.WriteLine(ex.Message); Console.WriteLine(ex.StackTrace); } connection.Close(); string idClient = FindClient(clientFirstName, clientLastName); /*If the client was not found in the database, that means he has to be created*/ if (idClient == "") { Connect(); command.CommandText = "SELECT MAX(idclient) FROM client"; try { idClient = ((int)command.ExecuteScalar() + 1).ToString(); } catch (InvalidCastException) { idClient = "1"; Console.WriteLine("No client in the database yet."); } connection.Close(); Connect(); command.CommandText = String.Format("INSERT INTO client(idclient, firstname, lastname, adress, zip, phonenumber) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}');", idClient, clientFirstName, clientLastName, adress, zip, phoneNumber); command.ExecuteNonQuery(); connection.Close(); } //Orders the parts Dictionary <string, int> parts = MakeOrder(cupboard); Connect(); command.CommandText = String.Format("INSERT INTO client_command(idcom, idclient, description) VALUES ('{0}', '{1}', '{2}');", idCom, idClient, cupboard.GetDescription().ToString()); foreach (string code in parts.Keys) { command.CommandText += String.Format("INSERT INTO client_partscommand VALUES ('{0}', '{1}', '{2}');", idCom, code, parts[code]); command.CommandText += String.Format("UPDATE part SET real_quantity= real_quantity-{0} WHERE code='{1}';", parts[code], code); } command.ExecuteNonQuery(); connection.Close(); }