Advertisement
Guest User

Untitled

a guest
Jun 29th, 2016
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.54 KB | None | 0 0
  1. public ConnectionStringList ConnectionStrings(string Path_Config)
  2. {
  3. var result = new List<string>();
  4. var MyConnectionList = new ConnectionStringList();
  5. MyConnectionList.OrcaReorcaConnectionsList = new List<string>();
  6. MyConnectionList.OrcaConnectionsList = new List<string>();
  7. MyConnectionList.ReorcaConnectionsList = new List<string>();
  8. ExeConfigurationFileMap configOld = new ExeConfigurationFileMap();
  9. configOld.ExeConfigFilename = Path_Config;
  10. Configuration config = ConfigurationManager.OpenMappedExeConfiguration(configOld, ConfigurationUserLevel.None);
  11. string GetPrefixes = config.AppSettings.Settings["Prefix"].Value;
  12. var Prefixes = GetPrefixes.Split(';');
  13.  
  14. foreach (var Prefix in Prefixes)
  15. {
  16. var ToAdd = from x in config.AppSettings.Settings.AllKeys
  17. where x.ToLower() == Prefix + "oraconnectionstring"
  18. select config.AppSettings.Settings[x].Value;
  19. // result.Add(ToAdd);
  20. //foreach (var item in config.AppSettings.Settings.AllKeys)
  21. //{
  22.  
  23. // //if (item.ToLower().StartsWith(Prefix) && item.ToLower().EndsWith("oraconnectionstring"))
  24. // //if (item.ToLower() == Prefix.ToLower() + "oraconnectionstring")
  25. // //{
  26. // // result.Add(config.AppSettings.Settings[item.ToString()].Value);
  27. // // break;
  28. // //}
  29. //}
  30.  
  31. }
  32.  
  33. //List<string> result = new List<string>(
  34. // from x in config.AppSettings.Settings.AllKeys
  35. // where x.ToLower().StartsWith("or") && x.ToLower().EndsWith("connectionstring")
  36. // select config.AppSettings.Settings[x].Value);
  37.  
  38. foreach (var ConnectionString in result)
  39. {
  40.  
  41. MyConnectionList.OrcaReorcaConnectionsList.Add(ConnectionString);
  42. var SplitConnection = ConnectionString.Split(';');
  43. var GetUserID = SplitConnection[0].Substring(SplitConnection[0].IndexOf("=") + 1/*, SplitConnection[0].Length*/);
  44. if (GetUserID.ToLower().StartsWith("orca")) MyConnectionList.OrcaConnectionsList.Add(ConnectionString);
  45. else if (GetUserID.ToLower().StartsWith("reorca")) MyConnectionList.ReorcaConnectionsList.Add(ConnectionString);
  46.  
  47. }
  48. return MyConnectionList;
  49. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement