private string getAppRola(string userId, string appId) { string query = SqlQueries.getUserAppRola.Replace("@appId", appId).Replace("@userId", userId); QueryData windowsUserData = dbReader.readFromDB(query); List <string> rolaList = convertColumnDataToList(windowsUserData.getQueryDataAsStrings()); if (rolaList.Count > 0) { return(rolaList[0]); //zawsze jest tylko jedna rola } return(""); }
private void getAppModules() { App app; string query = SqlQueries.getAppModuleList; QueryData modulesData = dbReader.readFromDB(query); List <string[]> moduleDataList = modulesData.getQueryDataAsStrings(); foreach (string[] moduleData in moduleDataList) { AppModule module = new AppModule(); module.id = moduleData[SqlQueries.getAppModuleList_moduleIdIndex]; module.name = moduleData[SqlQueries.getAppModuleList_moduleNameIndex]; module.appId = moduleData[SqlQueries.getAppModuleList_moduleAppIdIndex]; appDictionary.TryGetValue(module.appId, out app); app.addModule(module); moduleDict.Add(module.id, module); } }