public VolunteerStatisticMapper() { SQLiteDataReader reader = StaticDBConnection.QueryDatabase(dbQuery); while (reader.Read()) { String volunteer = reader["Name"].ToString(); DateTime start = Convert.ToDateTime(reader["Joined"].ToString()); DateTime end = Convert.ToDateTime(reader["Departure"].ToString()); String operationID = reader["Operation_ID"].ToString(); //Creating volunteerStatistic VolunteerStatistic vs = new VolunteerStatistic(volunteer, start, end, operationID); volunteerStatisticList.Add(vs); } StaticDBConnection.CloseConnection(); }
//order the list according to alphabetical order private void orderList() { volunteerStatisticList = volunteerStatisticList.OrderBy(VolunteerStatistic => VolunteerStatistic.getName()).ToList(); }