public static List <Removed_events> getEvents()
{
List <Removed_events> list = new List <Removed_events>();
DB db = new DB();
DataTable items = db.query("SELECT * FROM removed_events");
foreach (DataRow row in items.Rows)
{
object[] item = row.ItemArray;
Removed_events newEvent = new Removed_events();
newEvent.id = Convert.ToInt32(item[0]);
newEvent.description = Convert.ToString(item[1]);
newEvent.date = Convert.ToDateTime(item[2]);
newEvent.note = Convert.ToString(item[3]);
newEvent.price = Convert.ToInt32(item[4]);
newEvent.childs = getChildInfoFromEventId(newEvent.id);
list.Add(newEvent);
}
return(list);
}
private void SetupRemovedEventsTable()
{
List <Removed_events> events = Removed_events.getEvents();
foreach (Removed_events item in events)
{
this.dataGridView4.Rows.Add(item.id, item.getChildsName(), item.description, item.date, item.note, item.price);
}
}
