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