Skip to content

Instantly share code, notes, and snippets.

@gsedubun
Last active April 2, 2018 02:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gsedubun/1140193b078cb2667dc98df6be2adaa4 to your computer and use it in GitHub Desktop.
Save gsedubun/1140193b078cb2667dc98df6be2adaa4 to your computer and use it in GitHub Desktop.
dbcontext untuk asp.net core inmemory Db provider
using System;
using System.Collections.Generic;
using System.Linq;
using Microsoft.EntityFrameworkCore;
namespace TodoNetCoreAngular.Models
{
public class TodoRepository
{
private readonly TodoDbContext context;
public TodoRepository(TodoDbContext opt)
{
this.context = opt;
}
public TodoViewModel Addtodo(Todo todo)
{
context.Todo.Add(todo);
context.SaveChanges();
return new TodoViewModel { ID = todo.ID, Title = todo.Title, TotalItem = todo.TodoItem.Count };
}
public TodoViewModel Addtodoitem(int id, TodoItem todo)
{
var d = context.Todo.Find(id);
d.TodoItem.Add(todo);
context.SaveChanges();
return new TodoViewModel { ID = d.ID, Title = d.Title, TotalItem = d.TodoItem.Count };
}
public IEnumerable<TodoViewModel> Get()
{
return context.Todo.Select(d => new TodoViewModel { ID = d.ID, Title = d.Title, TotalItem = d.TodoItem.Count }).ToList();
}
public IEnumerable<TodoItem> GetTodoItem(int id)
{
return context.TodoItem.Where(d => d.Todo.ID == id).Select(d => new TodoItem { ID = d.ID, Item = d.Item }).ToList();
}
public TodoViewModel Get(int id)
{
return context.Todo.Select(d => new TodoViewModel { ID = d.ID, Title = d.Title, TotalItem = d.TodoItem.Count }).SingleOrDefault(d => d.ID == id);
}
}
public class TodoDbContext : DbContext
{
public DbSet<Todo> Todo { get; set; }
public DbSet<TodoItem> TodoItem { get; set; }
public TodoDbContext(DbContextOptions opt) : base(opt)
{
}
}
public class TodoViewModel
{
public int ID { get; set; }
public string Title { get; set; }
public int TotalItem { get; set; }
}
public class Todo
{
public int ID { get; set; }
public string Title { get; set; }
public virtual List<TodoItem> TodoItem { get; set; }
public Todo()
{
TodoItem = new List<TodoItem>();
}
}
public class TodoItem
{
public int ID { get; set; }
public string Item { get; set; }
public virtual Todo Todo { get; set; }
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment