public void Test_UserCreationAndDeletion()
{
var options = new DbContextOptionsBuilder <WaffleContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.EnableSensitiveDataLogging()
.Options;
var context = new WaffleContext(options);
var reader = new Reader(context);
var writer = new Writer(context);
Guid uuid = Guid.NewGuid();
var user = new User()
{
ID = uuid,
JoinDate = DateTime.Now,
UserName = "******"
};
writer.CreateUser(user);
var retrievedUser = reader.GetUser(uuid);
Assert.Equal(retrievedUser, user);
var allUsers = reader.GetUsers();
Assert.Contains(retrievedUser, allUsers);
var deleted = writer.DeleteUser(uuid);
Assert.True(deleted);
var deletedUser = reader.GetUser(uuid);
Assert.Null(deletedUser);
}
public ClassInfoVM(Class classInfo)
{
_class = classInfo;
using (var db = WaffleContext.CreateDb())
{
var _topics = db.ClassTopic
.Where(t => t.ClassId == _class.ClassId)
.Include(t => t.Playlists)
.ToList();
var _resources = db.ClassResource
.Where(r => r.ClassId == _class.ClassId)
.ToList();
var _discussions = db.ClassDiscussion
.Where(d => d.ClassId == _class.ClassId)
.ToList();
discussions = _discussions;
resources = _resources;
topics = _topics;
}
}
public ClassController()
{
_db = WaffleContext.CreateDb();
repo = ClassRepository.CreateRepo();
cat = ClassCategoryRepository.CreateRepo();
levels = ClassLevelRepository.CreateRepo();
types = ClassTypeRepository.CreateRepo();
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, WaffleContext dbContext)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
dbContext.Database.EnsureCreated();
app.UseHttpsRedirection();
app.UseRouting();
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllers();
});
}
public ClassTypeRepository() : base(WaffleContext.CreateDb())
{
_db = WaffleContext.CreateDb();
}
public ClassResourcesRepository() : base(WaffleContext.CreateDb())
{
_db = WaffleContext.CreateDb();
}
public Reader(WaffleContext dbContext)
{
_dbContext = dbContext;
}
public ClassPlaylistRepository()
: base(WaffleContext.CreateDb())
{
}
public Writer(WaffleContext dbContext)
{
_dbContext = dbContext;
}
public UserController()
{
_db = WaffleContext.CreateDb();
userRepo = new UserRepository();
}
