public SecurityModels.GetUsersResponse GetUsers(SecurityModels.GetListRequest getUsersRequest)
{
SecurityModels.GetUsersResponse getUsersResponse = new SecurityModels.GetUsersResponse();
List <SecurityModels.User> Users = new List <SecurityModels.User>();
using (SqlConnection con = new SqlConnection(securityConnectionString))
{
using (SqlCommand cmd = new SqlCommand("GetUsers", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@searchParm", SqlDbType.VarChar, 30).Value = getUsersRequest.searchParm;
cmd.Parameters.Add("@pageSize", SqlDbType.Int, 0).Value = getUsersRequest.pageSize;
cmd.Parameters.Add("@pageNumber", SqlDbType.Int, 0).Value = getUsersRequest.pageNumber;
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
int recordNumber = 1;
while (reader.Read())
{
if (recordNumber == 1)
{
getUsersResponse.recordCount = Convert.ToInt32(reader["recordCount"].ToString());
}
Users.Add(new SecurityModels.User
{
id = Convert.ToInt32(reader["ID"].ToString()),
userName = reader["UserName"].ToString(),
firstName = reader["firstName"].ToString(),
lastName = reader["lastName"].ToString(),
email = reader["Email"].ToString(),
active = Convert.ToBoolean(reader["Active"].ToString())
});
}
getUsersResponse.users = Users;
}
con.Close();
}
return(getUsersResponse);
}
public SecurityModels.GetPermissionsResponse GetPermissions(SecurityModels.GetListRequest getPermissionsRequest)
{
SecurityModels.GetPermissionsResponse getPermissionsResponse = new SecurityModels.GetPermissionsResponse();
List <SecurityModels.Permission> Permissions = new List <SecurityModels.Permission>();
using (SqlConnection con = new SqlConnection(securityConnectionString))
{
using (SqlCommand cmd = new SqlCommand("GetPermissions", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@searchParm", SqlDbType.VarChar, 30).Value = getPermissionsRequest.searchParm;
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
int recordNumber = 1;
while (reader.Read())
{
if (recordNumber == 1)
{
getPermissionsResponse.recordCount = Convert.ToInt32(reader["recordCount"].ToString());
}
Permissions.Add(new SecurityModels.Permission
{
id = Convert.ToInt32(reader["ID"].ToString()),
name = reader["Name"].ToString(),
displayName = reader["displayName"].ToString(),
active = Convert.ToBoolean(reader["Active"].ToString())
});
}
getPermissionsResponse.permissions = Permissions;
}
con.Close();
}
return(getPermissionsResponse);
}
public IActionResult GetPermissions([FromQuery] SecurityModels.GetListRequest getPermissionsRequest)
{
SecurityModels.GetPermissionsResponse getPermissionsResponse = securityInventoryRepo.GetPermissions(getPermissionsRequest);
return(StatusCode(StatusCodes.Status200OK, getPermissionsResponse));
}
