/// <summary> /// gets the list of chemicals from 'keresek' table /// </summary> /// <param name="userId">DB identifier of user</param> /// <param name="area">area of the user</param> /// <returns></returns> public List <string> getUserConnectedChemThreats(string area) { List <string> result = new List <string>(); try { param = new KeyValuePair <string, string>("@area", area); } catch (Exception e) { throw new ErrorServiceProfileDetailsManage("Az adatbázis felé a kérés megalkotása sikertelen (ModPersonThreats) " + e.Message); } mdi.openConnection(); result = mdi.execPrepGetOneColumnToListWithKVP(queryToGetChemicalThreaths, param); mdi.closeConnection(); return(result); }