//makes a group object with all public Models.Group GetSingleGroup(int id, Dal.AD ad, Dal.SQL sql) { List <Models.Person> members = new List <Models.Person>(); List <Models.Person> membersSmall = new List <Models.Person>(); List <Models.Task> tasks = new List <Models.Task>(); //makes the list of members membersSmall = sql.GetMemberList(id); foreach (Models.Person p in membersSmall) { Models.Person person = ad.GetUserInfo(p.UNI); members.Add(new Models.Person(person.Name, p.UNI, person.Studing, p.Admin)); } //makes the list of tasks tasks = sql.GetTaskList(id, DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd HH:mm:ss")); //gets the base info about the group Models.Group group = sql.GetbasicInfoAboutGroup(id); //gets all the comments for that group List <Models.Comment> comments = sql.GetCommentList(id); for (int i = 0; i < comments.Count; i++) { comments[i] = new Models.Comment(comments[i].ID, ad.GetUserInfo(comments[i].Name).Name, comments[i].Datetime, comments[i].CommentText, true); } return(new Models.Group(group.Name, group.Id, group.Description, group.Complete, group.StartDate, members, tasks, comments, group.EndDate)); }