public NoticeBoardDbContext CreateContext(DbTransaction transaction = null)
{
var context = new NoticeBoardDbContext
(new DbContextOptionsBuilder <NoticeBoardDbContext>()
.UseSqlServer(Connection)
.Options);
if (transaction != null)
{
context.Database.UseTransaction(transaction);
}
return(context);
}
private async Task Initialize(IServiceProvider serviceProvider,
string adminPassword,
string user1Password,
string user2Password)
{
using (var context = new NoticeBoardDbContext(
serviceProvider.GetRequiredService <DbContextOptions <NoticeBoardDbContext> >()))
{
// The admin user can do anything
var adminID = await EnsureUser(serviceProvider, adminPassword, _loginViewModels[0].Email);
var user1ID = await EnsureUser(serviceProvider, user1Password, _loginViewModels[1].Email);
var user2ID = await EnsureUser(serviceProvider, user2Password, _loginViewModels[2].Email);
await EnsureRole(serviceProvider, adminID, NotificationConstants.ContactAdministratorsRole);
//TODO:ensure more roles
SeedDB(context, adminID, user1ID, user2ID);
}
}
private void SeedDB(NoticeBoardDbContext context, string adminID, string user1Id, string user2Id)
{
var Notifications = new Notification[]
{
new Notification()
{
Name = "I want to sell my car",
Description = "best car in the world, my number is 12345",
OwnerID = adminID
},
new Notification
{
Name = "Test notification 2",
Description = " Test description for 2 notificaton.",
OwnerID = adminID
},
new Notification
{
Name = "Apple MQAG2B/A iPhone X",
Description = "Get ready for a stunning experience with this Apple iPhone X smartphone.",
OwnerID = user1Id
},
new Notification
{
Name = "Samsung Galaxy Note10 SM-N970U",
Description = "Samsung",
OwnerID = user1Id
},
new Notification
{
Name = "Smartwatch Lenovo",
Description = "Smartwatch Lenovo HW10H BlazeMotorola.",
OwnerID = user2Id
}
};
if (!context.Notifications.Any())
{
context.Notifications.AddRange(Notifications);
context.SaveChanges();
}
var Comments = new Comment[]
{
new Comment()
{
OwnerID = adminID,
Description = "Test comment for 0 notification content"
},
new Comment()
{
OwnerID = user1Id,
Description = "Test 1 comment for 0 notification content"
},
new Comment()
{
OwnerID = adminID,
Description = "Test 3 comment for 0 notification content"
},
new Comment()
{
OwnerID = user1Id,
Description = "Test 1 comment for 1 notification content"
},
new Comment()
{
OwnerID = adminID,
Description = "Test 2 comment for 1 notification content"
},
new Comment()
{
OwnerID = user2Id,
Description = "Test 1 comment for 2 notification content"
}
};
if (!context.Comments.Any())
{
context.Comments.AddRange(Comments);
context.SaveChanges();
}
}
public NotificationsRepository(NoticeBoardDbContext context)
: base(context)
{
}
public CommentsRepository(NoticeBoardDbContext context)
: base(context)
{
}
public GenericRepository(NoticeBoardDbContext dbContext)
{
_dbContext = dbContext;
_dbSet = _dbContext.Set <TEntity>();
}
