public static WebAPIDbContext GetTestDbCotext()
{
var dbContextOptions = new DbContextOptionsBuilder <WebAPIDbContext>()
.UseInMemoryDatabase("TestAppDatabase")
.Options;
var dbContext = new WebAPIDbContext(dbContextOptions);
return(dbContext);
}
public static void SeedHostDb(WebAPIDbContext context)
{
context.SuppressAutoSetTenantId = true;
// Host seed
new InitialHostDbBuilder(context).Create();
// Default tenant seed (in host database).
new DefaultTenantBuilder(context).Create();
new TenantRoleAndUserBuilder(context, 1).Create();
}
public List <Book> Get()
{
List <Book> books = new List <Book>();
using (var context = new WebAPIDbContext())
{
books = (from b in context.Books
orderby b.Title ascending
select b).ToList();
}
return(books);
}
public void Put(int id, [FromBody] Book book)
{
using (var context = new WebAPIDbContext())
{
Book book_2 = (from b in context.Books
where b.Id == id
select b).FirstOrDefault();
book_2.Title = book.Title;
book_2.Author = book.Author;
context.SaveChanges();
}
}
public void Delete(int id)
{
using (var context = new WebAPIDbContext())
{
Book book = (from b in context.Books
where b.Id == id
select b).FirstOrDefault();
if (book != null)
{
context.Books.Remove(book);
context.SaveChanges();
}
}
}
public HttpResponseMessage Post([FromBody] Book c)
{
HttpResponseMessage msg;
Book book = new Book()
{
Author = c.Author, Title = c.Title, TypeOfBook = c.TypeOfBook
};
using (var context = new WebAPIDbContext())
{
context.Books.Add(book);
context.SaveChanges();
}
msg = Request.CreateResponse(HttpStatusCode.Created);
msg.Headers.Location = new Uri(Request.RequestUri + book.Id.ToString());
return(msg);
}
public HttpResponseMessage Get(int id)
{
HttpResponseMessage msg = null;
Book book = new Book();
using (var context = new WebAPIDbContext())
{
book = (from b in context.Books
where b.Id == id
select b).FirstOrDefault();
}
if (book == null)
{
msg = Request.CreateErrorResponse(HttpStatusCode.NotFound, "Book not found!");
}
else
{
msg = Request.CreateResponse <Book>(HttpStatusCode.OK, book);
}
return(msg);
}
public InitialHostDbBuilder(WebAPIDbContext context)
{
_context = context;
}
public StorageRepository(WebAPIDbContext context)
{
_context = context ?? throw new ArgumentNullException(nameof(context));
}
public ProductsController(WebAPIDbContext webAPIDbContext)
{
_webAPIDbContext = webAPIDbContext;
}
public DefaultSettingsCreator(WebAPIDbContext context)
{
_context = context;
}
public TenantRoleAndUserBuilder(WebAPIDbContext context, int tenantId)
{
_context = context;
_tenantId = tenantId;
}
public DefaultEditionCreator(WebAPIDbContext context)
{
_context = context;
}
public DefaultLanguagesCreator(WebAPIDbContext context)
{
_context = context;
}
public DefaultTenantBuilder(WebAPIDbContext context)
{
_context = context;
}
public HostRoleAndUserCreator(WebAPIDbContext context)
{
_context = context;
}
public CarsController(WebAPIDbContext context, IHostingEnvironment hostingEnv)
{
_hostingEnv = hostingEnv;
_context = context;
}
