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