public List <MachinePartTemp> getAllparts() { List <MachinePartTemp> list = new List <MachinePartTemp>(); for (int i = 0; i < MachinePark.Count; i++) { for (int j = 0; j < MachinePark[i].Get_Parts().Count; j++) { MachinePartTemp part = new MachinePartTemp() { Machine = MachinePark[i].Machine_name, Module = MachinePark[i].Get_Parts()[j].Module, PanelsMade = MachinePark[i].Get_Parts()[j].Panels_made, Part = MachinePark[i].Get_Parts()[j].Part, Maintenance = DateTime.Today.AddDays(rnd.randomstatus()) }; list.Add(part); } } return(list); }
public List <MachinePartTemp> GetParts() { MachinePartTemp temp; if (!isOpen) { Open_Datebase(); } List <MachinePartTemp> Parts = new List <MachinePartTemp> { }; sqlstatment = Connection.CreateCommand(); sqlstatment.CommandText = "SELECT * FROM `machine_part`"; try { MySqlDataReader reder = sqlstatment.ExecuteReader(); while (reder.Read()) { temp = new MachinePartTemp { Machine = reder["Machine"].ToString(), Module = (int)reder["Module_id"], Part = reder["Part"].ToString(), PanelsMade = (int)reder["Panels_made"] }; Parts.Add(temp); } } catch (Exception) { return(null); } Close_Datebase(); return(Parts); }