//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)); }
public List <Models.Group> GetGroupListFull(Dal.AD ad, Dal.SQL sql) { List <Models.Group> groups = sql.GetGroupList(false); for (int i = 0; i < groups.Count; i++) { groups[i].Members = sql.GetMemberList(groups[i].Id); for (int j = 0; j < groups[i].Members.Count; j++) { Models.Person person = new Models.Person(); Models.Course personCourse = sql.GetPersonsCourse(groups[i].Members[j].UNI); if (personCourse.StartCourse < DateTime.Now && personCourse.EndCourse > DateTime.Now) { person.OnCourse = true; } else { person.OnCourse = false; } person.Name = ad.GetUserInfo(groups[i].Members[j].UNI).Name; groups[i].Members[j] = person; } } return(groups); }