/// <summary>
/// Adds a district to the system, only if it does not exist.
/// </summary>
private static void AddInitialDistrict(this IDbAppContext context, District initialDistrict)
{
District district = context.GetDistrictByMinistryDistrictId(initialDistrict.MinistryDistrictID);
if (district != null)
{
return;
}
district = new District
{
MinistryDistrictID = initialDistrict.MinistryDistrictID,
Name = initialDistrict.Name,
StartDate = initialDistrict.StartDate,
AppCreateUserid = SystemId,
AppCreateTimestamp = DateTime.UtcNow,
AppLastUpdateUserid = SystemId,
AppLastUpdateTimestamp = DateTime.UtcNow
};
if (initialDistrict.Region != null)
{
Region region = context.GetRegionByMinistryRegionId(initialDistrict.Region.MinistryRegionID);
district.Region = region;
}
else
{
district.Region = null;
}
context.Districts.Add(district);
}
public static CCWJurisdiction GetCCWJurisdictionByCode(this IDbAppContext context, string code)
{
CCWJurisdiction item = context.CCWJurisdictions.Where(x => x.Code != null && x.Code.Equals(code, StringComparison.OrdinalIgnoreCase))
.FirstOrDefault();
return(item);
}
public static CCWJurisdiction GetCCWJurisdictionByCode(this IDbAppContext context, string code)
{
CCWJurisdiction item = context.CCWJurisdictions.Where(x => x.Code != null && x.Code == code)
.FirstOrDefault();
return(item);
}
private static void AddInitialServiceArea(this IDbAppContext context, ServiceArea initialServiceArea)
{
ServiceArea serviceArea = context.GetServiceAreaByMinistryServiceAreaId(initialServiceArea.MinistryServiceAreaID);
if (serviceArea != null)
{
return;
}
serviceArea = new ServiceArea
{
MinistryServiceAreaID = initialServiceArea.MinistryServiceAreaID,
Name = initialServiceArea.Name,
StartDate = initialServiceArea.StartDate
};
if (initialServiceArea.District != null)
{
District district = context.GetDistrictByMinistryDistrictId(initialServiceArea.District.MinistryDistrictID);
serviceArea.District = district;
}
else
{
serviceArea.District = null;
}
context.ServiceAreas.Add(serviceArea);
context.SaveChanges();
}
/// <summary>
/// Adds a district to the system, only if it does not exist.
/// </summary>
private static void AddInitialDistrict(this IDbAppContext context, District initialDistrict)
{
District district = context.GetDistrictByMinistryDistrictId(initialDistrict.MinistryDistrictID);
if (district != null)
{
return;
}
district = new District
{
MinistryDistrictID = initialDistrict.MinistryDistrictID,
Name = initialDistrict.Name,
StartDate = initialDistrict.StartDate
};
if (initialDistrict.Region != null)
{
Region region = context.GetRegionByMinistryRegionId(initialDistrict.Region.MinistryRegionID);
district.Region = region;
}
else
{
district.Region = null;
}
context.Districts.Add(district);
context.SaveChanges();
}
private static void AddInitialServiceArea(this IDbAppContext context, ServiceArea initialServiceArea)
{
ServiceArea serviceArea = context.GetServiceAreaByMinistryServiceAreaId(initialServiceArea.MinistryServiceAreaID);
if (serviceArea != null)
{
return;
}
serviceArea = new ServiceArea
{
MinistryServiceAreaID = initialServiceArea.MinistryServiceAreaID,
Name = initialServiceArea.Name,
StartDate = initialServiceArea.StartDate,
AppCreateUserid = SystemId,
AppCreateTimestamp = DateTime.UtcNow,
AppLastUpdateUserid = SystemId,
AppLastUpdateTimestamp = DateTime.UtcNow
};
if (initialServiceArea.District != null)
{
District district = context.GetDistrictByMinistryDistrictId(initialServiceArea.District.MinistryDistrictID);
serviceArea.District = district;
}
else
{
serviceArea.District = null;
}
context.ServiceAreas.Add(serviceArea);
}
/// <summary>
/// Returns a region for a given Ministry Id
/// </summary>
/// <param name="context"></param>
/// <param name="id">The Ministry Id</param>
/// <returns>Region</returns>
public static Region GetRegionByMinistryRegionId(this IDbAppContext context, int id)
{
Region region = context.Regions.Where(x => x.MinistryRegionID == id)
.FirstOrDefault();
return(region);
}
/// <summary>
/// Returns a service area for a given Ministry Id
/// </summary>
/// <param name="context"></param>
/// <param name="id">The Ministry Id</param>
/// <returns>Region</returns>
public static ServiceArea GetServiceAreaByMinistryServiceAreaId(this IDbAppContext context, int id)
{
ServiceArea serviceArea = context.ServiceAreas.Where(x => x.MinistryServiceAreaID == id)
.Include(x => x.District.Region)
.FirstOrDefault();
return(serviceArea);
}
/// <summary>
/// Create regions from a (json) file
/// </summary>
/// <param name="context"></param>
/// <param name="regionJsonPath"></param>
public static void AddInitialRegionsFromFile(this IDbAppContext context, string regionJsonPath)
{
if (!string.IsNullOrEmpty(regionJsonPath) && File.Exists(regionJsonPath))
{
string regionJson = File.ReadAllText(regionJsonPath);
context.AddInitialRegions(regionJson);
}
}
/// <summary>
/// Returns a district for a given Ministry Id
/// </summary>
/// <param name="context"></param>
/// <param name="id">The Ministry Id</param>
/// <returns>District</returns>
public static District GetDistrictByMinistryDistrictId(this IDbAppContext context, int id)
{
District district = context.Districts.Where(x => x.MinistryDistrictID == id)
.Include(x => x.Region)
.FirstOrDefault();
return(district);
}
/// <summary>
/// Returns a role based on the role name
/// </summary>
/// <param name="context"></param>
/// <param name="name"></param>
/// <returns></returns>
public static Role GetRole(this IDbAppContext context, string name)
{
Role role = context.Roles.Where(x => x.Name.Equals(name, StringComparison.OrdinalIgnoreCase))
.Include(r => r.RolePermissions).ThenInclude(p => p.Permission)
.FirstOrDefault();
return(role);
}
public static User GetUserBySmUserId(this IDbAppContext context, string smUserId)
{
User user = context.Users.Where(x => x.SmUserId != null && x.SmUserId == smUserId && x.Active)
.Include(u => u.UserRoles).ThenInclude(r => r.Role).ThenInclude(rp => rp.RolePermissions).ThenInclude(p => p.Permission)
.FirstOrDefault();
return(user);
}
public static Role GetRole(this IDbAppContext context, string name)
{
Role role = context.Roles.Where(x => x.Name == name)
.Include(r => r.RolePermissions).ThenInclude(p => p.Permission)
.FirstOrDefault();
return(role);
}
/// <summary>
/// Create servive areas from a (json) file
/// </summary>
/// <param name="context"></param>
/// <param name="districtJsonPath"></param>
public static void AddInitialServiceAreasFromFile(this IDbAppContext context, string districtJsonPath)
{
if (!string.IsNullOrEmpty(districtJsonPath) && File.Exists(districtJsonPath))
{
string serviceAreaJson = File.ReadAllText(districtJsonPath);
context.AddInitialServiceAreas(serviceAreaJson);
}
}
/// <summary>
/// Returns a user based on the guid
/// </summary>
/// <param name="context"></param>
/// <param name="guid"></param>
/// <returns></returns>
public static User GetUserByGuid(this IDbAppContext context, string guid)
{
User user = context.Users.Where(x => x.Guid != null && x.Guid.Equals(guid, StringComparison.OrdinalIgnoreCase))
.Include(u => u.UserRoles).ThenInclude(r => r.Role).ThenInclude(rp => rp.RolePermissions).ThenInclude(p => p.Permission)
.FirstOrDefault();
return(user);
}
/// <summary>
/// Create users from a (json) file
/// </summary>
/// <param name="context"></param>
/// <param name="userJsonPath"></param>
public static void AddInitialUsersFromFile(this IDbAppContext context, string userJsonPath)
{
if (!string.IsNullOrEmpty(userJsonPath) && File.Exists(userJsonPath))
{
string userJson = File.ReadAllText(userJsonPath);
context.AddInitialUsers(userJson);
}
}
private static void AddInitialUsers(this IDbAppContext context, string userJson)
{
List <User> users = JsonConvert.DeserializeObject <List <User> >(userJson);
if (users != null)
{
context.AddInitialUsers(users);
}
}
private static void AddInitialCCWJurisdictions(this IDbAppContext context, string CCWJurisdictionJson)
{
List <CCWJurisdiction> CCWJurisdictions = JsonConvert.DeserializeObject <List <CCWJurisdiction> >(CCWJurisdictionJson);
if (CCWJurisdictions != null)
{
context.AddInitialCCWJurisdictions(CCWJurisdictions);
}
}
private static void AddInitialServiceAreas(this IDbAppContext context, string serviceAreaJson)
{
List <ServiceArea> serviceAreas = JsonConvert.DeserializeObject <List <ServiceArea> >(serviceAreaJson);
if (serviceAreas != null)
{
context.AddInitialServiceAreas(serviceAreas);
}
}
/// <summary>
/// Returns a user based on the account name
/// </summary>
/// <param name="context"></param>
/// <param name="smUserId"></param>
/// <returns></returns>
public static User GetUserBySmUserId(this IDbAppContext context, string smUserId)
{
User user = context.Users.Where(x => x.SmUserId != null && x.SmUserId.Equals(smUserId, StringComparison.OrdinalIgnoreCase))
.Include(u => u.UserRoles).ThenInclude(r => r.Role).ThenInclude(rp => rp.RolePermissions).ThenInclude(p => p.Permission)
.Include(u => u.GroupMemberships).ThenInclude(gm => gm.Group)
.FirstOrDefault();
return(user);
}
private static void AddInitialDistricts(this IDbAppContext context, string districtJson)
{
List <District> districts = JsonConvert.DeserializeObject <List <District> >(districtJson);
if (districts != null)
{
context.AddInitialDistricts(districts);
}
}
private static void AddInitialRegions(this IDbAppContext context, string regionJson)
{
List <Region> regions = JsonConvert.DeserializeObject <List <Region> >(regionJson);
if (regions != null)
{
context.AddInitialRegions(regions);
}
}
/// <summary>
/// Adds a user to the system, only if they do not exist.
/// </summary>
private static void AddInitialUser(this IDbAppContext context, User initialUser)
{
User user = context.GetUserBySmUserId(initialUser.SmUserId);
if (user != null)
{
return;
}
user = new User();
user.Active = true;
user.Email = initialUser.Email;
user.GivenName = initialUser.GivenName;
user.Initials = initialUser.Initials;
user.SmAuthorizationDirectory = initialUser.SmAuthorizationDirectory;
user.SmUserId = initialUser.SmUserId;
user.Surname = initialUser.Surname;
District district = null;
if (initialUser.District != null)
{
district = context.GetDistrictByMinistryDistrictId(initialUser.District.MinistryDistrictID);
}
user.District = district;
context.Users.Add(user);
context.SaveChanges();
string[] userRoles = initialUser.UserRoles.Select(x => x.Role.Name).ToArray();
if (user.UserRoles == null)
{
user.UserRoles = new List <UserRole>();
}
foreach (string userRole in userRoles)
{
Role role = context.GetRole(userRole);
if (role != null)
{
user.UserRoles.Add(
new UserRole
{
EffectiveDate = DateTime.UtcNow.Date,
Role = role
});
}
}
context.Users.Update(user);
context.SaveChanges();
}
/// <summary>
/// Adds a region to the system, only if it does not exist.
/// </summary>
private static void AddInitialRegion(this IDbAppContext context, Region initialRegion)
{
Region region = context.GetRegionByMinistryRegionId(initialRegion.MinistryRegionID);
if (region != null)
{
return;
}
region = new Region();
region.MinistryRegionID = initialRegion.MinistryRegionID;
region.Name = initialRegion.Name;
region.StartDate = initialRegion.StartDate;
context.Regions.Add(region);
context.SaveChanges();
}
/// <summary>
/// Adds a CCWJurisdiction to the system, only if it does not exist.
/// </summary>
private static void AddInitialCCWJurisdiction(this IDbAppContext context, CCWJurisdiction initialCCWJurisdiction)
{
CCWJurisdiction CCWJurisdiction = context.GetCCWJurisdictionByCode(initialCCWJurisdiction.Code);
if (CCWJurisdiction != null)
{
return;
}
CCWJurisdiction = new CCWJurisdiction();
CCWJurisdiction.ActiveFlag = initialCCWJurisdiction.ActiveFlag;
CCWJurisdiction.Code = initialCCWJurisdiction.Code;
CCWJurisdiction.Description = initialCCWJurisdiction.Description;
CCWJurisdiction.EffectiveDate = initialCCWJurisdiction.EffectiveDate;
CCWJurisdiction.ExpiryDate = initialCCWJurisdiction.ExpiryDate;
context.CCWJurisdictions.Add(CCWJurisdiction);
context.SaveChanges();
}
/// <summary>
/// Adds a region to the system, only if it does not exist.
/// </summary>
private static void AddInitialRegion(this IDbAppContext context, Region initialRegion)
{
Region region = context.GetRegionByMinistryRegionId(initialRegion.MinistryRegionID);
if (region != null)
{
return;
}
region = new Region
{
MinistryRegionID = initialRegion.MinistryRegionID,
Name = initialRegion.Name,
StartDate = initialRegion.StartDate,
AppCreateUserid = SystemId,
AppCreateTimestamp = DateTime.UtcNow,
AppLastUpdateUserid = SystemId,
AppLastUpdateTimestamp = DateTime.UtcNow
};
context.Regions.Add(region);
}
/// <summary>
/// Load User from HETS database using their userId and guid
/// </summary>
/// <param name="context"></param>
/// <param name="userId"></param>
/// <param name="guid"></param>
/// <returns></returns>
public static User LoadUser(this IDbAppContext context, string userId, string guid = null)
{
User user = null;
if (!string.IsNullOrEmpty(guid))
{
user = context.GetUserByGuid(guid);
}
if (user == null)
{
user = context.GetUserBySmUserId(userId);
}
if (user == null)
{
return(null);
}
if (guid == null)
{
return(user);
}
if (string.IsNullOrEmpty(user.Guid))
{
// self register (write the users Guid to thd db)
user.Guid = guid;
context.SaveChanges();
}
else if (!user.Guid.Equals(guid, StringComparison.OrdinalIgnoreCase))
{
// invalid account - guid doesn't match user credential
return(null);
}
return(user);
}
public static User LoadUser(this IDbAppContext context, string username, string guid = null)
{
User user = null;
if (!string.IsNullOrEmpty(guid))
{
user = context.GetUserByGuid(guid);
}
if (user == null)
{
user = context.GetUserBySmUserId(username);
}
if (user == null)
{
return(null);
}
if (guid != null)
{
if (string.IsNullOrEmpty(user.Guid))
{
// Self register ...
user.Guid = guid;
context.SaveChanges();
}
else if (!user.Guid.Equals(guid, StringComparison.OrdinalIgnoreCase))
{
// Registered users are not allowed to change their SiteMinder IDs ...
return(null);
}
}
return(user);
}
public DevAuthenticationHandler(IDbAppContext context, ILoggerFactory loggerFactory)
{
_logger = loggerFactory.CreateLogger(typeof(SiteminderAuthenticationHandler));
_context = context;
}
/// <summary>
/// Returns a group based on the group name
/// </summary>
/// <param name="context"></param>
/// <param name="name"></param>
/// <returns></returns>
public static Group GetGroup(this IDbAppContext context, string name)
{
return(context.Groups.FirstOrDefault(x => x.Name.Equals(name, StringComparison.OrdinalIgnoreCase)));
}