public List <Model.Session> GetByConference(int confId)
{
List <Model.Session> all = new List <Model.Session>();
foreach (var s in _context.getSessionsForConference(confId))
{
List <Model.Reservation> reservations = new List <Model.Reservation>();
foreach (var p in _context.getPapersSession(s.SessionId))
{
User u = _context.Users.Find(p.UserId);
Model.User user = new Model.User(u.UserId, u.Username, u.Password, u.Name, u.Affilliation, u.Email, u.canBePCMember, u.WebPage);
Model.Paper paper = new Model.Paper(p.PaperId, confId, user, p.Name, p.Filepath, p.Domain, p.Subdomain, p.Resume, p.TopicName);
List <Author> authors = new List <Author>();
foreach (var a in _context.getAdditionalAuthors(p.PaperId))
{
Author au = new Author(0, a.Name, a.Affiliation);
authors.Add(au);
}
paper.AdditionalAuthors = authors;
foreach (var b in _context.getBidsResult(p.PaperId))
{
User use = _context.Users.Find(b.PCMemberUserId);
PCMember pcm = _context.PCMembers.Find(b.PCMemberUserId, confId);
Model.User userr = new Model.User(use.UserId, use.Username, use.Password, use.Name, use.Affilliation, use.Email, use.canBePCMember, use.WebPage);
Participant participant = new Participant(userr, confId, pcm.isChair, pcm.isCoChair, true, false);
paper.AddBid(participant, b.BiddingEvaluation);
}
foreach (var r in _context.getReviewsPaper(p.PaperId))
{
User use = _context.Users.Find(r.PCMemberUserId);
PCMember pcm = _context.PCMembers.Find(r.PCMemberUserId, confId);
Model.User userr = new Model.User(use.UserId, use.Username, use.Password, use.Name, use.Affilliation, use.Email, use.canBePCMember, use.WebPage);
Participant participant = new Participant(userr, confId, pcm.isChair, pcm.isCoChair, true, false);
Model.Review rev = new Model.Review(0, participant, (Verdict)r.Evaluation, r.Recommandations);
paper.AddReview(rev);
paper.AddReviewer(participant);
}
foreach (var res in _context.getReservationPaper(paper.Id))
{
string room = "Room: " + res.RoomName + ", Street: " + res.Street + ", City: " + res.City;
Reservation rv = new Reservation(0, paper, room, DateTime.Parse(res.Timp.ToString()), res.Duration, DateTime.Parse(res.Data.ToString()));
reservations.Add(rv);
}
}
User us = _context.Users.Find(s.SessionChairId);
PCMember pc = _context.PCMembers.Find(s.SessionChairId, confId);
Model.User user2 = new Model.User(us.UserId, us.Username, us.Password, us.Name, us.Affilliation, us.Email, us.canBePCMember, us.WebPage);
Participant sesChair = new Participant(user2, confId, pc.isChair, pc.isCoChair, true, false);
Model.Session se = new Model.Session(s.SessionId, reservations, sesChair);
all.Add(se);
}
return(all);
}
public List <Model.Paper> GetByConference(int confId)
{
List <Model.Paper> all = new List <Model.Paper>();
foreach (Paper paper in _context.Papers)
{
if (paper.ConferenceId == confId)
{
User u = _context.Users.Find(paper.UserId);
Model.User user = new Model.User(u.UserId, u.Username, u.Password, u.Name, u.Affilliation, u.Email, u.canBePCMember, u.WebPage);
Topic t = _context.Topics.Find(paper.TopicId);
Model.Paper p = new Model.Paper(paper.PaperId, paper.ConferenceId, user, paper.Name, paper.Filepath, paper.Domain, paper.Subdomain, paper.Resume, t.TopicName);
List <Author> authors = new List <Author>();
foreach (AdditionalAuthor a in _context.AdditionalAuthors)
{
if (a.PaperId == paper.PaperId)
{
Author au = new Author(a.AdditionalAuthorId, a.Name, a.Affiliation);
authors.Add(au);
}
}
p.AdditionalAuthors = authors;
foreach (Bid b in _context.Bids)
{
if (b.PaperId == paper.PaperId)
{
User us = _context.Users.Find(b.PCMemberUserId);
PCMember pcm = _context.PCMembers.Find(b.PCMemberUserId, b.PCMemberConferenceId);
Model.User bidder = new Model.User(us.UserId, us.Username, us.Password, us.Name, us.Affilliation, us.Email, us.canBePCMember, us.WebPage);
Model.Participant participant = new Model.Participant(bidder, b.PCMemberConferenceId, pcm.isChair, pcm.isCoChair, true, false);
p.AddBid(participant, b.BiddingEvaluation);
}
}
foreach (var r in _context.getReviewsPaper(paper.PaperId))
{
User us = _context.Users.Find(r.PCMemberUserId);
PCMember pcm = _context.PCMembers.Find(r.PCMemberUserId, paper.ConferenceId);
Model.User reviewer = new Model.User(us.UserId, us.Username, us.Password, us.Name, us.Affilliation, us.Email, us.canBePCMember, us.WebPage);
Model.Participant participant = new Model.Participant(reviewer, paper.ConferenceId, pcm.isChair, pcm.isCoChair, true, false);
Model.Review review;
if (r.Evaluation != null)
{
Verdict v = (Verdict)r.Evaluation;
review = new Model.Review(0, participant, v, r.Recommandations);
p.AddReview(review);
}
p.AddReviewer(participant);
}
all.Add(p);
}
}
return(all);
}