public async Task<IHttpActionResult> Post(Review review)
{
review.UserId = UserId;
await DB.AddReview(review);
return Ok();
}
public void AddReview(int paperId, Model.Review review)
{
Review rev = _context.Reviews.Find(review.Reviewer.User.IdUser, review.Reviewer.ConferenceId, paperId);
rev.Evaluation = (int)review.Verdict;
rev.Recommandations = review.Comments;
_context.SaveChanges();
}
public bool Insert(int articleId, int leaveMsgId, DateTime reviewDate, string reviewContentPath)
{
Review rev = new Review();
rev.ArticleId = articleId;
rev.ReviewDate = reviewDate;
rev.ReviewContentPath = reviewContentPath;
DaoReview dao = new DaoReview();
return dao.Insert(rev);
}
public bool Insert(Review review)
{
string sql = "insert into Review (ArticleId,ReviewDate,ReviewContentPath) values(?,?,?)";
OleDbParameter[] oleDbParameters = { new OleDbParameter("@ArticleId",review.ArticleId),
new OleDbParameter("@ReviewDate",review.ReviewDate),
new OleDbParameter("@ReviewContentPath",review.ReviewContentPath)};
if (SQLHelper.ExecuteSql(sql, oleDbParameters) > 0)
return true;
return false;
}
public List<Review> Select(string sql)
{
DataSet ds = SQLHelper.Query(sql);
DataTable dt = ds.Tables[0];
List<Review> l = new List<Review>();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
Review review = new Review();
review.Id = int.Parse(dr["Id"].ToString());
review.ArticleId = int.Parse(dr["ArticleId"].ToString());
review.ReviewDate = DateTime.Parse(dr["ReviewDate"].ToString());
review.ReviewContentPath = dr["ReviewContentPath"].ToString();
l.Add(review);
}
}
return l;
}
public List <Model.Review> GetReviewsByPaper(int paperId)
{
List <Model.Review> all = new List <Model.Review>();
var paper = _context.Papers.Find(paperId);
foreach (var r in _context.getReviewsPaper(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);
Verdict v = (Verdict)r.Evaluation;
Model.Review review = new Model.Review(0, participant, v, r.Recommandations);
all.Add(review);
}
return(all);
}
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 void AddReview(int paperId, Model.Review r)
{
repoPaper.AddReview(paperId, r);
}
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);
}
/// <summary>
/// Add a review to the database
/// </summary>
/// <returns>Task</returns>
/// <param name="review">The review that should be added</param>
public async Task AddReview(Review review)
{
await _client.Cypher
.Match ("(e:Event)")
.Where((Event e) => e.Id == review.EventId)
.Create ("(e)-[:HAS_REVIEW]->(review:Review {data})")
.WithParam ("data", review)
.ExecuteWithoutResultsAsync ();
}
