public int Insert(ArticleReviewer item) { using (var conn = db.GetOpenConnection()) { return conn.Execute("INSERT INTO ArticleReviewer(ArticleID, UserID, ReviewTemplateID) VALUES(@ArticleID, @UserID, @ReviewTemplateID)", new { ArticleID = item.ArticleID, UserID = item.Reviewer.UserID, ReviewTemplateID = item.Template.ReviewTemplateID }); } }
public void Update(ArticleReviewer item) { using (var conn = db.GetOpenConnection()) { string sql = @"UPDATE [ArticleReviewer] SET [ArticleID] = @ArticleID ,[UserID] = @UserID ,[ReviewStatusID] = @ReviewStatusID ,[ReviewTemplateID] = @ReviewTemplateID ,[Comments] = @Comments ,[RejectReason] = @RejectReason WHERE ArticleReviewerID = @ArticleReviewerID"; var parameters = new DynamicParameters(item); conn.Execute(sql, parameters); } }
public CallResult AddReviewerToArticle(int articleId, int userId, int templateId) { try { bool alreadyAssigned = GetReviewsForArticle(articleId) .Where(x => x.UserID == userId && x.ReviewTemplateID == templateId).Any(); if (!alreadyAssigned) { var item = new ArticleReviewer(); item.Reviewer.UserID = userId; item.ArticleID = articleId; item.Template.ReviewTemplateID = templateId; articleReviewerRepository.Insert(item); result.SetSuccess("Se asignó el revisor al artículo."); } else result.SetWarning("Ya asignó el revisor al artículo con la plantilla seleccionada."); } catch(Exception e) { Logger.Log(e); result.SetError(); } return result; }