/// <summary> /// process of collect user personal details and rights of its group /// </summary> public void collectDatasOfVerifiedUser() { try { param = new KeyValuePair <string, string>("@userID", userId); } catch (Exception e) { throw new ErrorServiceLoginDBAccess("Lekérdezés összeállítási hiba (ModLoginUserDetSeek) " + e.Message); } mdi = startDBconnect.kapcsolodas(dbci, parent); mdi.openConnection(); rightFromDB = mdi.execPrepScalarQueryInStringWithKVP(queryOfRights, param); userDatas = mdi.execPrepQueryOneRowInStringArrWithKVP(queryOfUserPersonalDet, param); mdi.closeConnection(); }
/// <summary> /// gets the user_name valu from 'felhaszn' table by the specific id /// </summary> /// <param name="userId">the DB id of the user</param> /// <returns>user_name of the user</returns> public string[] getNameAndTajOfUser(string userId) { string[] result = null; try { param = new KeyValuePair <string, string>("@userId", userId); } catch (Exception e) { throw new ErrorServiceProfileDetailsManage("Az adatbázis felé a kérés összeállítása sikertelen (ModProfUNTaj) " + e.Message); } mdi.openConnection(); result = mdi.execPrepQueryOneRowInStringArrWithKVP(queryGettingTheUserNameofUser, param); mdi.closeConnection(); return(result); }