private void SeedAdmin(MsSqlDbContext context)
{
if (!context.Roles.Any())
{
var roleStore = new RoleStore <IdentityRole>(context);
var roleManager = new RoleManager <IdentityRole>(roleStore);
var role = new IdentityRole("Admin");
roleManager.Create(role);
var userStore = new UserStore <User>(context);
var userManager = new UserManager <User>(userStore);
var user = new User
{
UserName = AdministratorUserName,
Email = AdministratorUserName,
EmailConfirmed = true
};
userManager.Create(user, AdministratorPassword);
userManager.AddToRole(user.Id, "Admin");
}
}
public EfRepository(MsSqlDbContext context)
{
Guard.WhenArgument(context, nameof(IMsSqlDbContext)).IsNull().Throw();
this.Context = context;
this.DbSet = this.Context.Set <T>();
}
protected override void Seed(MsSqlDbContext context)
{
this.SeedUsers(context);
this.SeedSampleData(context);
base.Seed(context);
}
protected MsSqlDatabaseFixture(string connString)
{
Db = new MsSqlDbContext(connString);
DropDatabase();
InitDb();
}
public EfRepository(MsSqlDbContext context)
{
Guard.WhenArgument(context, "Context").IsNull().Throw();
this.dbContext = context;
this.dbSet = this.dbContext.Set <T>();
}
protected void Application_Start()
{
Database.SetInitializer <MsSqlDbContext>(null);
using (var db = new MsSqlDbContext())
{
db.Database.Initialize(false);
}
var migrator = new DbMigrator(new Configuration());
if (migrator.GetPendingMigrations().Any())
{
migrator.Update();
}
Database.SetInitializer(new MigrateDatabaseToLatestVersion <MsSqlDbContext, Configuration>());
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
var mapper = new AutoMapperConfig();
mapper.Execute(Assembly.GetExecutingAssembly());
}
private void SeedSampleData(MsSqlDbContext context)
{
//if (context.Events.Any())
//{
// return;
//}
//var events = Newtonsoft.Json.JsonConvert.DeserializeObject<ICollection<Data.JsonModels.Event>>(System.IO.File.ReadAllText(Resource.DbSeedPath));
//var dbEvents = events.AsQueryable().ProjectTo<Models.Event>().ToList();
//foreach (var betEvent in dbEvents)
//{
// context.Events.Add(betEvent);
//}
context.Events.AddOrUpdate(new Models.Event {
EventName = "Juventus vs Milan", OddsForFirstTeam = 1, OddsForDraw = 3, OddsForSecondTeam = 2, EventStartDate = new DateTime(2013, 6, 1, 12, 32, 30)
},
new Models.Event {
EventName = "RealM vs Barselona", OddsForFirstTeam = 1, OddsForDraw = 3, OddsForSecondTeam = 2, EventStartDate = new DateTime(2013, 6, 1, 12, 32, 30)
},
new Models.Event {
EventName = "Lazio vs Inter", OddsForFirstTeam = 1, OddsForDraw = 3, OddsForSecondTeam = 2, EventStartDate = new DateTime(2013, 6, 1, 12, 32, 30)
},
new Models.Event {
EventName = "Liverpool vs Arsenal", OddsForFirstTeam = 1, OddsForDraw = 3, OddsForSecondTeam = 2, EventStartDate = new DateTime(2013, 6, 1, 12, 32, 30)
},
new Models.Event {
EventName = "BorusiaD vs Shalke", OddsForFirstTeam = 1, OddsForDraw = 3, OddsForSecondTeam = 2, EventStartDate = new DateTime(2013, 6, 1, 12, 32, 30)
});
context.SaveChanges();
}
private void SeedUsers(MsSqlDbContext context)
{
if (!context.Roles.Any())
{
var roleName = "Admin";
var roleStore = new RoleStore <IdentityRole>(context);
var roleManager = new RoleManager <IdentityRole>(roleStore);
var role = new IdentityRole {
Name = roleName
};
roleManager.Create(role);
var userStore = new UserStore <User>(context);
var userManager = new UserManager <User>(userStore);
var user = new User
{
UserName = AdministratorUserName,
Email = AdministratorUserName,
EmailConfirmed = true,
CreatedOn = DateTime.Now
};
userManager.Create(user, AdministratorPassword);
userManager.AddToRole(user.Id, roleName);
}
}
private void SeedAdmin(MsSqlDbContext context)
{
// Create admin account
const string AdministratorUserName = "******";
const string AdministratorPassword = "******";
if (!context.Roles.Any())
{
var roleStore = new RoleStore <IdentityRole>(context);
var roleManager = new RoleManager <IdentityRole>(roleStore);
var role = new IdentityRole {
Name = "Admin"
};
roleManager.Create(role);
var userStore = new UserStore <User>(context);
var userManager = new UserManager <User>(userStore);
var user = new User {
UserName = AdministratorUserName, Email = AdministratorUserName, EmailConfirmed = true
};
userManager.Create(user, AdministratorPassword);
userManager.AddToRole(user.Id, "Admin");
}
}
private void SeedSampleData(MsSqlDbContext context)
{
if (!context.Products.Any())
{
Category category = new Category()
{
Id = Guid.NewGuid(),
Name = "Other"
};
context.Categories.Add(category);
for (int i = 0; i < 3; i++)
{
var product = new Product()
{
Id = Guid.NewGuid(),
Name = "Product " + i,
LongDescription = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed sit amet lobortis nibh. Nullam bibendum, tortor quis porttitor fringilla, eros risus consequat orci, at scelerisque mauris dolor sit amet nulla. Vivamus turpis lorem, pellentesque eget enim ut, semper faucibus tortor. Aenean malesuada laoreet lorem.",
Description = "Other Product",
Quantity = i + 3,
CategoryId = category.Id.Value,
PictureUrl = "http://www.freepngimg.com/download/special_offer/5-2-special-offer-png-pic.png",
Price = 2M
};
context.Products.Add(product);
}
}
}
public void Constructor_Should_HaveParameterlessConstructor()
{
// Arrange & Act
var context = new MsSqlDbContext();
// Assert
Assert.IsInstanceOf <MsSqlDbContext>(context);
}
public void Constructor_ShouldThrowArgumentNullException_WhenContextIsNull()
{
// Arrange
MsSqlDbContext msSqlDbContext = null;
// Act & Assert
Assert.Throws <ArgumentNullException>(() => new SaveContext(msSqlDbContext));
}
public void ReturnInstanceOfIMsSqlDbContext_WhenParamsAreValid()
{
//Arrange
var context = new MsSqlDbContext();
//Act & Assert
Assert.IsInstanceOf <MsSqlDbContext>(context);
}
public void Constructor_Should_Return_InstanceOfMsSqlDbContext()
{
// Arrange & Act
var context = new MsSqlDbContext();
// Assert
Assert.IsInstanceOf <IMsSqlDbContext>(context);
}
public void TestInit()
{
kernel = InjectionConfig.CreateKernel();
MsSqlDbContext dbContext = kernel.Get <MsSqlDbContext>();
dbContext.Products.Add(dbProduct);
dbContext.SaveChanges();
}
public void Create_Should_ReturnNewDbContextInstance()
{
// Arrange & Act
var newContext = MsSqlDbContext.Create();
// Assert
Assert.IsNotNull(newContext);
Assert.IsInstanceOf <IMsSqlDbContext>(newContext);
}
public void Create_ShouldReturnNewInstanceOfMsSqlDbContextClass()
{
// Arrange and Act
var result = MsSqlDbContext.Create();
// Assert
Assert.IsInstanceOf <MsSqlDbContext>(result);
Assert.AreEqual("MsSqlDbContext", result.GetType().Name);
}
public void TestInit()
{
kernel = InjectionConfig.CreateKernel();
MsSqlDbContext dbContext = kernel.Get <MsSqlDbContext>();
dbContext.Categories.Add(dbCategory);
dbContext.SaveChanges();
}
public void TestCleanup()
{
MsSqlDbContext dbContext = kernel.Get <MsSqlDbContext>();
dbContext.Products.Attach(dbProduct);
dbContext.Products.Remove(dbProduct);
dbContext.SaveChanges();
}
public void TestCleanup()
{
MsSqlDbContext dbContext = kernel.Get <MsSqlDbContext>();
dbContext.Categories.Attach(dbCategory);
dbContext.Categories.Remove(dbCategory);
dbContext.SaveChanges();
}
public void ReturnNewDbContext_WhenParamsAreValid()
{
// Arrange & Act
var newContext = MsSqlDbContext.Create();
// Assert
Assert.IsNotNull(newContext);
Assert.IsInstanceOf <MsSqlDbContext>(newContext);
}
public void ThrowArgumentNullException_WhenDbContextIsNull()
{
//Arrange
MsSqlDbContext nullContext = null;
//Act & Assert
Assert.That(() => new SaveContext(nullContext),
Throws.InstanceOf <ArgumentNullException>().With.Message.Contains("Db context is null!"));
}
public void ThrowArgumentNullException_IfDbContextPassedIsNull()
{
// Arrange
MsSqlDbContext nullContext = null;
// Act & Assert
Assert.That(() => new EfRepository <Book>(nullContext),
Throws.InstanceOf <ArgumentNullException>().With.Message.Contains(nameof(IMsSqlDbContext)));
}
public RoleService(MsSqlDbContext dbContext)
{
//Guard.WhenArgument(rolesRepo, "rolesRepo").IsNull().Throw();
//Guard.WhenArgument(context, "context").IsNull().Throw();
//this.rolesRepo = rolesRepo;
this.dbContext = dbContext;
this.RoleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(this.dbContext));
//this.context = context;
}
public void Contructor_Should_ThrowArgumentNullException_IfPassedDbContextIsNull()
{
// Arrange
MsSqlDbContext dbContextThatIsNull = null;
// Act & Assert
Assert.That(
() => new SaveContext(dbContextThatIsNull),
Throws.InstanceOf <ArgumentNullException>().With.Message.Contains("MsSqlDbContext"));
}
private void CreateRole(string roleName, MsSqlDbContext context)
{
var roleStore = new RoleStore <IdentityRole>(context);
var roleManager = new RoleManager <IdentityRole>(roleStore);
var role = new IdentityRole {
Name = roleName
};
roleManager.Create(role);
}
public ActionResult AddHacked(string cookie)
{
var db = new MsSqlDbContext();
db.Hacks.Add(new Hack()
{
Cookie = cookie
});
db.SaveChanges();
return(this.RedirectToAction("Index"));
}
static void Main(string[] args)
{
Database.SetInitializer <MsSqlDbContext>(null);
Database.SetInitializer <NpgSqlDbContext>(null);
var ctx = new MsSqlDbContext(@"name=MsSqlDbContext");
var countries = ctx.Countries.Take(10).ToList();
var npgsqlctx = new NpgSqlDbContext("name=NpgSqlDbContext");
var users = npgsqlctx.Users.Take(10).ToList();
}
public MsSqlDatabaseFixture()
{
var connString = "Server=bhg-dc1-sqldev1;Initial Catalog=master;Integrated Security=True";
//if (Environments.IsAppVeyor)
// connString = "Server=(local)\\SQL2016;Database=master;User ID=sa;Password=Password12!";
Db = new MsSqlDbContext(connString);
InitDb();
}
public void MsSqlDbContext_ShouldSet_PostCategories()
{
// Arrange
var mockDbSet = new Mock <IDbSet <PostCategory> >();
var msSqlDbContext = new MsSqlDbContext();
// Act
msSqlDbContext.PostCategories = mockDbSet.Object;
// Assert
Assert.AreEqual(mockDbSet.Object, msSqlDbContext.PostCategories);
}
