public override void UpdateDB(DBTable dbModel) { base.UpdateDB(dbModel); DBReviewable dBReviewable = dbModel as DBReviewable; dBReviewable.Content = ReviewableContentJSON; dBReviewable.Info = ReviewableInfoJSON; }
public Reviewable(DBReviewable dBReviewable) : base(dBReviewable.Id) { Title = dBReviewable.Title; Type = dBReviewable.Type; TitleImageUrl = dBReviewable.TitleImageUrl; Description = dBReviewable.Description; TpId = dBReviewable.TpId; TpName = dBReviewable.TpName; }
public IActionResult Create([FromBody] ReviewableDetail reviewable) { using (var context = new RevojiDataContext()) { DBReviewable dbReviewable = new DBReviewable(); reviewable.UpdateDB(dbReviewable); context.Add(dbReviewable); context.Save(); return(Ok(new Reviewable(dbReviewable))); } }
public override void UpdateDB(DBTable dbModel) { base.UpdateDB(dbModel); DBReviewable dBReviewable = dbModel as DBReviewable; dBReviewable.Title = Title; dBReviewable.Type = Type; dBReviewable.TitleImageUrl = TitleImageUrl; dBReviewable.Description = Description; dBReviewable.TpId = TpId; dBReviewable.TpName = TpName; }
public IActionResult GetInfo(int id) { using (var context = new RevojiDataContext()) { DBReviewable dbReviewable = context.Get <DBReviewable>(id); if (dbReviewable == null) { return(Ok()); } var reviewable = new ReviewableDetail(dbReviewable); return(Ok(reviewable.Info)); } }
public IActionResult Delete(int id) { using (var context = new RevojiDataContext()) { DBReviewable dbReviewable = context.Get <DBReviewable>(id); if (dbReviewable == null) { return(new NotFoundResult()); } context.Remove(dbReviewable); context.Save(); return(Ok()); } }
public IActionResult Update(int id, [FromBody] JObject reviewable) { using (var context = new RevojiDataContext()) { DBReviewable dbReviewable = context.Get <DBReviewable>(id); if (dbReviewable == null) { return(new NotFoundResult()); } dbReviewable.update(reviewable); context.Save(); return(Ok()); } }
public IActionResult SetInfo(int id, [FromBody] JObject reviewableInfo) { using (var context = new RevojiDataContext()) { DBReviewable dbReviewable = context.Get <DBReviewable>(id); if (dbReviewable == null) { return(new NotFoundResult()); } dbReviewable.Content = JsonConvert.SerializeObject(reviewableInfo); context.Save(); return(Ok()); } }
public ReviewableDetail(DBReviewable dBReviewable) : base(dBReviewable) { ReviewableContentJSON = dBReviewable.Content; ReviewableInfoJSON = dBReviewable.Info; using (var context = new RevojiDataContext()) { var reviews = context.Reviews.Where(r => r.ReviewableId == ID); reviewCount = reviews.Count(); if (reviewCount == 0) { emojiCounts = null; } string emojis = new string(reviews.SelectMany(r => r.Emojis) .ToArray()); emojiCounts = emojis.Split(",") .GroupBy(e => e, StringComparer.OrdinalIgnoreCase) .ToDictionary(group => group.Key, group => group.Count()); } }