public void RemoveAccessibleLocation(SecLevel targetSecLevel, int locationId) { SqlCommand cmd = new SqlCommand("RemoveAccessibleLocation", _sqlConnection); cmd.CommandType = CommandType.StoredProcedure; SqlParameter secLevelParam = new SqlParameter("@targetSecLevelId", SqlDbType.Int); secLevelParam.Value = targetSecLevel.Id; cmd.Parameters.Add(secLevelParam); SqlParameter locationParam = new SqlParameter("@locationId", SqlDbType.Int); locationParam.Value = locationId; cmd.Parameters.Add(locationParam); cmd.ExecuteNonQuery(); }
public IList <SecLevel> GetSecLevels() { SqlCommand getUsers = new SqlCommand("SELECT * from GetSecLevels()", _sqlConnection); var reader = getUsers.ExecuteReader(); List <SecLevel> result = new List <SecLevel>(); while (reader.Read()) { string name, description; int id; id = (int)reader["Id"]; name = (string)reader["LevelName"]; description = (string)reader["LevelDescription"]; var secLevel = new SecLevel(id, name, description); result.Add(secLevel); } reader.Close(); return(result); }
public IList <Location> GetSecLevelLocations(SecLevel secLevel) { return(GetSecLevelLocations(secLevel.Id)); }
public void RemoveAccessibleLocation(SecLevel targetSecLevel, Location location) { RemoveAccessibleLocation(targetSecLevel, location.Id); }