public int UpdatePermission(SecurityModels.Permission permission)
{
try
{
using (SqlConnection con = new SqlConnection(securityConnectionString))
{
using (SqlCommand cmd = new SqlCommand("UpdatePermission", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = permission.id;
cmd.Parameters.Add("@Name", SqlDbType.VarChar, 50).Value = permission.name;
cmd.Parameters.Add("@displayName", SqlDbType.VarChar, 50).Value = permission.displayName;
cmd.Parameters.Add("@Active", SqlDbType.Bit).Value = permission.active ? 1 : 0;
con.Open();
permission.id = Convert.ToInt32(cmd.ExecuteScalar());
}
con.Close();
}
}
catch
{
throw;
}
return(permission.id);
}
public SecurityModels.Permission GetPermission(int id)
{
SecurityModels.Permission permission = new SecurityModels.Permission();
using (SqlConnection con = new SqlConnection(securityConnectionString))
{
using (SqlCommand cmd = new SqlCommand("GetPermission", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = id;
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
permission.id = Convert.ToInt32(reader["ID"].ToString());
permission.name = reader["Name"].ToString();
permission.displayName = reader["displayName"].ToString();
permission.active = id == 0 ? false : Convert.ToBoolean(reader["Active"].ToString());
}
}
con.Close();
}
return(permission);
}
public void UpdatePermissionStatus(SecurityModels.Permission permission)
{
try
{
using (SqlConnection con = new SqlConnection(securityConnectionString))
{
using (SqlCommand cmd = new SqlCommand("UpdatePermissionStatus", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = permission.id;
cmd.Parameters.Add("@Active", SqlDbType.Bit).Value = permission.active;
con.Open();
cmd.ExecuteNonQuery();
}
con.Close();
}
}
catch
{
throw;
}
}
public IActionResult GetPermission(int id)
{
SecurityModels.Permission permission = securityInventoryRepo.GetPermission(id);
return(StatusCode(StatusCodes.Status200OK, permission));
}
public IActionResult UpdatePermissionStatus([FromBody] SecurityModels.Permission permission)
{
securityInventoryRepo.UpdatePermissionStatus(permission);
return(StatusCode(StatusCodes.Status200OK, permission));
}
