/// <summary>
/// Fake DbContext
/// </summary>
/// <returns></returns>
public static HRTrainDbContext GetDbContext()
{
var options = new DbContextOptionsBuilder <HRTrainDbContext>()
.UseInMemoryDatabase(databaseName: "HRTrainDb")
.Options;
var context = new HRTrainDbContext(options);
Seed(context);
return(context);
}
private void DEVELOP_SEED()
{
var optionsBuilder = new DbContextOptionsBuilder <HRTrainDbContext>();
optionsBuilder.UseSqlServer(Configuration.GetConnectionString("SqlServerConnection"));
HRTrainDbContext db = new HRTrainDbContext(optionsBuilder.Options);
HRMT01 u = new HRMT01()
{
USER_NO = "SuperAdmin",
E_MAIL = "*****@*****.**",
ADDRESS = "none",
PASSWORD = "******",
NAME = "Tester",
CHG_DATE = DateTime.Now,
CHG_PERSON = "System"
};
HRMT24 r = new HRMT24()
{
ROLE_ID = ((int)UserRole.最大管理者).ToString(),
ROLE_NAME = "SuperAdmin",
CHG_PERSON = "System"
};
HRMT25 ur = new HRMT25()
{
USER_NO = u.USER_NO,
ROLE_ID = r.ROLE_ID,
DEFAULT_YN = "Y",
CHG_DATE = DateTime.Now,
CHG_PERSON = "System"
};
if (db.HRMT01.Where(user => user.USER_NO == u.USER_NO).FirstOrDefault() == null)
{
db.HRMT01.Add(u);
}
if (db.HRMT24.Where(role => role.ROLE_ID == r.ROLE_ID).FirstOrDefault() == null)
{
db.HRMT24.Add(r);
}
if (db.HRMT25.Where(userRole => userRole.USER_NO == ur.USER_NO && userRole.ROLE_ID == ur.ROLE_ID)
.FirstOrDefault() == null)
{
db.HRMT25.Add(ur);
}
db.SaveChanges();
}
/// <summary>
/// Fake 種子
/// </summary>
/// <param name="context"></param>
public static void Seed(HRTrainDbContext context)
{
var hrmtList = new List <HRMT01>()
{
new HRMT01()
{
USER_NO = "0000", NAME = "SuperMan", PASSWORD = "******"
},
new HRMT01()
{
USER_NO = "0001", NAME = "Man", PASSWORD = "******"
}
};
context.HRMT01.AddRange(hrmtList);
context.SaveChanges();
}
public GenericRepository(HRTrainDbContext context)
{
this.context = context;
this.dbSet = context.Set <TEntity>();
}
public UnitOfWork(HRTrainDbContext context)
{
this.Db = context;
}
