public bool IsEmpty()
{
using (var db = new OpsisContext())
{
return(db.VersionHistories.Count() == 0);
}
}
public void EncryptConnectionStringsSection_CheckDbConnection()
{
AppConfig.EncryptSectionIfPlain("connectionStrings", "Opsis.Database.Tests.dll");
using (var db = new OpsisContext())
{
Assert.AreEqual(true, db.Database.Exists());
var versionData = db.VersionHistories.ToList();
}
}
public string GetCurrentVersionNumber()
{
using (var db = new OpsisContext())
{
return(db.VersionHistories
.OrderByDescending(v => v.Id)
.Select(v => v.VersionNumber)
.SingleOrDefault());
}
}
private void InsertInitialRecord(OpsisContext db)
{
var init = new VersionHistory
{
Id = 1,
InitDate = DateTime.Now,
VersionNumber = "1.0"
};
db.VersionHistories.Add(init);
db.SaveChanges();
}
public void Initialize()
{
if (IsEmpty())
{
using (var db = new OpsisContext())
{
InsertInitialRecord(db);
InsertUserStatuses(db);
InsertUserRoles(db);
InsertAdminUser(db);
}
}
}
private void InsertUserRoles(OpsisContext db)
{
var roles = new List <UserRole>
{
new UserRole {
Id = 1, Name = Constants.AdminRoleName, IsSystemRole = true
},
new UserRole {
Id = 2, Name = Constants.UserRoleName, IsSystemRole = true
}
};
foreach (var r in roles)
{
db.UserRoles.Add(r);
}
db.SaveChanges();
}
private void InsertUserStatuses(OpsisContext db)
{
var statuses = new List <UserStatus>
{
new UserStatus {
Id = 1, Name = Constants.UserStatusActive
},
new UserStatus {
Id = 2, Name = Constants.UserStatusBlocked
}
};
foreach (var s in statuses)
{
db.UserStatuses.Add(s);
}
db.SaveChanges();
}
public LoginState Login(string username, string password)
{
using (var db = new OpsisContext())
{
User user = db.Users.SingleOrDefault(u => u.Username == username);
if (user != null && user.Password == BCryptHelper.HashPassword(password, user.Salt))
{
if (IsBlocked(user))
{
return(LoginState.Blocked);
}
LoggedOnUser = new LoggedOnUserDTO(user.Id, user.Username, user.Name, user.Surname, user.IsSystemUser);
GetPermissions(user);
return(LoginState.LoggedOn);
}
return(LoginState.WrongCredentials);
}
}
private void InsertAdminUser(OpsisContext db)
{
var salt = BCryptHelper.GenerateSalt();
var password = BCryptHelper.HashPassword(Constants.AdminUserDefaultPassword, salt);
var user = new User
{
Id = 1,
Username = Constants.AdminUsername,
Password = password,
Salt = salt,
IsSystemUser = true,
Name = Constants.AdminName,
Surname = Constants.AdminSurname,
UserStatus = db.UserStatuses.SingleOrDefault(s => s.Id == 1),
UserRoles = db.UserRoles.Where(r => r.Id == 1).ToList()
};
db.Users.Add(user);
db.SaveChanges();
}
