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());
}
}
