public async Task Add(Blog item) { _db.Blogs.Add(item); await _db.SaveChangesAsync(); if (AppSettings.InitializeData) { var initializer = new DataInitializer(); initializer.SeedPosts(item); } }
public async Task Add(Post item) { using (var context = new BlogiFireContext()) { await context.Posts.AddAsync(item); await context.SaveChangesAsync(); } }
public async Task Delete(int id) { using (var context = new BlogiFireContext()) { var item = await context.Posts.FirstOrDefaultAsync(i => i.Id == id); context.Posts.Remove(item); await context.SaveChangesAsync(); } }
public async Task Add(Comment item) { using (var context = new BlogiFireContext()) { await context.Comments.AddAsync(item); // update comment count if (item.PostId > 0) { var post = context.Posts.Where(p => p.Id == item.PostId).FirstOrDefault(); post.Comments++; await context.Posts.UpdateAsync(post); } await context.SaveChangesAsync(); } }
public async Task Update(Post item) { using (var context = new BlogiFireContext()) { var itemToUpdate = await context.Posts.FirstOrDefaultAsync(i => i.Id == item.Id); itemToUpdate.Saved = DateTime.UtcNow; itemToUpdate.Title = item.Title; itemToUpdate.Content = item.Content; itemToUpdate.Tags = item.Tags; itemToUpdate.Published = item.Published; await context.Posts.UpdateAsync(itemToUpdate); await context.SaveChangesAsync(); } }
public async Task Delete(int id) { using (var context = new BlogiFireContext()) { var item = await context.Comments.FirstOrDefaultAsync(i => i.Id == id); context.Comments.Remove(item); // update comment count if (item.PostId > 0) { var post = context.Posts.Where(p => p.Id == item.PostId).FirstOrDefault(); post.Comments--; await context.Posts.UpdateAsync(post); } await context.SaveChangesAsync(); } }
public async Task Update(Comment item) { using (var context = new BlogiFireContext()) { var itemToUpdate = await context.Comments.FirstOrDefaultAsync(i => i.Id == item.Id); itemToUpdate.Author = item.Author; itemToUpdate.Content = item.Content; itemToUpdate.Ip = item.Ip; itemToUpdate.Website = item.Website; itemToUpdate.UserAgent = item.UserAgent; itemToUpdate.Published = item.Published; itemToUpdate.IsApproved = item.IsApproved; await context.Comments.UpdateAsync(itemToUpdate); await context.SaveChangesAsync(); } }