/// <summary>
///
/// </summary>
public ArrayList LoadAll()
{
string sqlstring = PrepareSQL("Manager.UserRoleDetailManager.LoadAll", null);
ArrayList UserRoleDetails = new ArrayList();
if (sqlstring == string.Empty)
{
return(UserRoleDetails);
}
try
{
this.ExecQuery(sqlstring);
while (this.Reader.Read())
{
UserRoleDetail info = PrepareData();
if (info != null)
{
UserRoleDetails.Add(info);
}
}
}
catch (Exception ex)
{
this.ErrCode = ex.Message;
this.Err = ex.Message;
UserRoleDetails.Clear();
}
return(UserRoleDetails);
}
/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int UpdateUserRoleDetail(UserRoleDetail info)
{
string strSql = "";
if (this.Sql.GetSql("Manager.UserRoleDetailManager.UpdateUserRoleDetail", ref strSql) == -1)
{
return(-1);
}
try
{
strSql = string.Format(strSql, info.PkID, info.DeptCode, info.UserCode, info.RoleCode, info.GrantDept, info.GrantEmpl, FrameWork.Function.NConvert.ToInt32(info.GrantFlag), this.Operator.ID, info.Mark);
}
catch (Exception ex)
{
this.ErrCode = ex.Message;
this.Err = ex.Message;
return(-1);
}
try
{
return(this.ExecNoQuery(strSql));
}
catch (Exception ex)
{
this.ErrCode = ex.Message;
this.Err = ex.Message;
return(-1);
}
}
/// <summary>
/// Create a new UserRoleDetail
/// </summary>
/// <param name="body">Message-Body</param>
/// <returns></returns>
public UserRoleDetail createUserRoleDetail(UserRoleDetail body)
{
// create path and map variables
var path = "/userRoleDetails".Replace("{format}", "json");
// query params
var queryParams = new Dictionary <String, String>();
var headerParams = new Dictionary <String, String>();
string paramStr = null;
try {
var response = apiClient.invokeAPI(path, "POST", queryParams, body, headerParams);
if (response != null)
{
return((UserRoleDetail)ApiClient.deserialize(response, typeof(UserRoleDetail)));
}
else
{
return(null);
}
} catch (ApiException ex) {
if (ex.ErrorCode == 404)
{
return(null);
}
else
{
throw ex;
}
}
}
private UserRoleDetail PrepareData()
{
UserRoleDetail info = new UserRoleDetail();
info.PkID = this.Reader[0].ToString();
info.DeptCode = this.Reader[1].ToString();
info.UserCode = this.Reader[2].ToString();
info.RoleCode = this.Reader[3].ToString();
info.GrantDept = this.Reader[4].ToString();
info.GrantEmpl = this.Reader[5].ToString();
info.GrantFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[6].ToString());
info.Mark = this.Reader[7].ToString();
return(info);
}
/// <summary>
/// Update a UserRoleDetail by a given ID
/// </summary>
/// <param name="ID">Unique ID</param>
/// <param name="body">Message-Body</param>
/// <returns></returns>
public UserRoleDetail updateUserRoleDetail(string ID, UserRoleDetail body)
{
// create path and map variables
var path = "/userRoleDetails/{ID}".Replace("{format}", "json").Replace("{" + "ID" + "}", apiClient.escapeString(ID.ToString()));
// query params
var queryParams = new Dictionary <String, String>();
var headerParams = new Dictionary <String, String>();
// verify required params are set
if (ID == null)
{
throw new ApiException(400, "missing required params");
}
string paramStr = null;
try {
var response = apiClient.invokeAPI(path, "PUT", queryParams, body, headerParams);
if (response != null)
{
return((UserRoleDetail)ApiClient.deserialize(response, typeof(UserRoleDetail)));
}
else
{
return(null);
}
} catch (ApiException ex) {
if (ex.ErrorCode == 404)
{
return(null);
}
else
{
throw ex;
}
}
}
/// <summary>
///
/// </summary>
public ArrayList LoadByUserCode(string userCode)
{
string sqlstring = PrepareSQL("Manager.UserRoleDetailManager.LoadByUserCode", new string[] { userCode });
ArrayList UserRoleDetails = new ArrayList();
if (sqlstring == string.Empty)
{
return(UserRoleDetails);
}
PowerRoleManager roleMgr = new PowerRoleManager();
try
{
this.ExecQuery(sqlstring);
while (this.Reader.Read())
{
UserRoleDetail info = PrepareData();
if (info != null)
{
info.Role = roleMgr.Load(info.RoleCode);
UserRoleDetails.Add(info);
}
}
}
catch (Exception ex)
{
this.ErrCode = ex.Message;
this.Err = ex.Message;
UserRoleDetails.Clear();
}
return(UserRoleDetails);
}
private static async Task SeedDatabaseAsync(UserManager <User> signInManager, RoleManager <IdentityRole> roleManager, AnraConfiguration anraConfiguration)
{
UserRoleDetail urd;
#region "Roles Creation"
var roles = new[] { "SuperAdmin", "Administrator", "SystemUser", "Other" };//"Pilot", "Payload Operator", "Visual Observer",
if (!(context.MantiScanRole.Any(u => roles.Contains(u.RoleName))))
{
foreach (var roleName in roles)
{
var role = new Role {
RoleName = roleName, IsActive = true,
};
context.MantiScanRole.Add(role);
}
context.SaveChanges();
}
#endregion "Roles Creation"
#region "Module Creation"
if (!(context.Modules.Any(u => u.ModuleName == nameof(User))))
{
var lstModule = new List <Module>
{
new Module {
ModuleId = 1, ModuleName = "User", IsActive = true
},
new Module {
ModuleId = 2, ModuleName = "Organization", IsActive = true
},
new Module {
ModuleId = 4, ModuleName = "Plateform", IsActive = true
},
new Module {
ModuleId = 3, ModuleName = "Incident", IsActive = true
},
new Module {
ModuleId = 5, ModuleName = "Report", IsActive = true
}
};
context.Modules.AddRange(lstModule);
context.SaveChanges();
}
#endregion "Module Creation"
#region "Role Detail Creation"
if (!(context.RoleDetails.Any(u => u.RoleDetailId == 1)))
{
var roleSAdmin = context.MantiScanRole.First(v => v.RoleId == 1);
var roleAdmin = context.MantiScanRole.First(v => v.RoleId == 2);
var roleSuser = context.MantiScanRole.First(v => v.RoleId == 3);
var roleOther = context.MantiScanRole.First(v => v.RoleId == 4);
var lstrd = new List <RoleDetail>
{
new RoleDetail
{
Role = roleSAdmin,
Module = context.Modules.First(v => v.ModuleId == 1),
Add = true,
Edit = true,
Delete = true,
View = true,
IsActive = true
},
new RoleDetail
{
Role = roleAdmin,
Module = context.Modules.First(v => v.ModuleId == 1),
Add = true,
Edit = true,
Delete = true,
View = true,
IsActive = true
},
new RoleDetail
{
Role = roleSAdmin,
Module = context.Modules.First(v => v.ModuleId == 2),
Add = true,
Edit = true,
Delete = true,
View = true,
IsActive = true
},
new RoleDetail
{
Role = roleAdmin,
Module = context.Modules.First(v => v.ModuleId == 2),
Add = true,
Edit = true,
Delete = true,
View = true,
IsActive = true
},
new RoleDetail
{
Role = roleSAdmin,
Module = context.Modules.First(v => v.ModuleId == 3),
Add = true,
Edit = true,
Delete = true,
View = true,
IsActive = true
},
new RoleDetail
{
Role = roleAdmin,
Module = context.Modules.First(v => v.ModuleId == 3),
Add = true,
Edit = true,
Delete = true,
View = true,
IsActive = true
},
new RoleDetail
{
Role = roleSAdmin,
Module = context.Modules.First(v => v.ModuleId == 4),
Add = true,
Edit = true,
Delete = true,
View = true,
IsActive = true
},
new RoleDetail
{
Role = roleAdmin,
Module = context.Modules.First(v => v.ModuleId == 4),
Add = true,
Edit = true,
Delete = true,
View = true,
IsActive = true
},
new RoleDetail
{
Role = roleSAdmin,
Module = context.Modules.First(v => v.ModuleId == 5),
Add = true,
Edit = true,
Delete = true,
View = true,
IsActive = true
},
new RoleDetail
{
Role = roleAdmin,
Module = context.Modules.First(v => v.ModuleId == 5),
Add = true,
Edit = true,
Delete = true,
View = true,
IsActive = true
}
};
context.RoleDetails.AddRange(lstrd);
context.SaveChanges();
}
#endregion "Role Detail Creation"
#region "Organization Creation"
if (!(context.Organizations.Any(u => u.Name == anraConfiguration.DefaultOrganization)))
{
var lstOrg = new List <Organization>
{
new Organization
{
Name = anraConfiguration.DefaultOrganization,
Website = "www.anratechnolgies.com",
ContactEmail = "*****@*****.**"
}
};
//Main Organization - ANRA Technologies
context.Organizations.AddRange(lstOrg);
context.SaveChanges();
}
#endregion "Organization Creation"
var defaultOrganization = context.Organizations.First(v => v.Name == anraConfiguration.DefaultOrganization);
#region "User Creation"
if (!(context.User.Any(u => u.UserName == anraConfiguration.DefaultSuperAdmin)))
{
#region create superadmin user
var superAdminUser = new User
{
Id = Guid.NewGuid().ToString(),
UserName = anraConfiguration.DefaultSuperAdmin,
Email = anraConfiguration.DefaultSuperAdmin,
FirstName = "John",
LastName = "Doe",
IsActive = true,
Organization = defaultOrganization,
DateCreated = DateTime.UtcNow,
DateModified = DateTime.UtcNow,
LastLogin = DateTime.UtcNow
};
await signInManager.CreateAsync(superAdminUser, "AnRaBaSe1$");
await signInManager.SetLockoutEnabledAsync(superAdminUser, false);
urd = new UserRoleDetail
{
Role = context.MantiScanRole.First(v => v.RoleId == (int)Roles.SuperAdmin),
User = superAdminUser,
IsActive = true
};
context.UserRoleDetails.Add(urd);
context.SaveChanges();
#endregion create superadmin user
}
#endregion "User Creation"
}
