public SecurityModels.GetRolesResponse GetRoles(SecurityModels.GetListRequest getRolesRequest)
{
SecurityModels.GetRolesResponse getRolesResponse = new SecurityModels.GetRolesResponse();
List <SecurityModels.Role> Roles = new List <SecurityModels.Role>();
using (SqlConnection con = new SqlConnection(securityConnectionString))
{
using (SqlCommand cmd = new SqlCommand("GetRoles", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@searchParm", SqlDbType.VarChar, 30).Value = getRolesRequest.searchParm;
cmd.Parameters.Add("@pageSize", SqlDbType.Int, 0).Value = getRolesRequest.pageSize;
cmd.Parameters.Add("@pageNumber", SqlDbType.Int, 0).Value = getRolesRequest.pageNumber;
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
int recordNumber = 1;
while (reader.Read())
{
if (recordNumber == 1)
{
getRolesResponse.recordCount = Convert.ToInt32(reader["recordCount"].ToString());
}
recordNumber++;
Roles.Add(new SecurityModels.Role
{
id = Convert.ToInt32(reader["ID"].ToString()),
name = reader["Name"].ToString(),
displayName = reader["displayName"].ToString(),
active = Convert.ToBoolean(reader["Active"].ToString())
});
}
getRolesResponse.roles = Roles;
}
con.Close();
}
return(getRolesResponse);
}
public IActionResult GetRoles([FromQuery] SecurityModels.GetListRequest getRolesRequest)
{
SecurityModels.GetRolesResponse getRolesResponse = securityInventoryRepo.GetRoles(getRolesRequest);
return(StatusCode(StatusCodes.Status200OK, getRolesResponse));
}