Exemple #1
0
        public string GetConnexionString()
        {
            string sResult = "";

            try {
                // Recherche des connexion pour BDD :
                var appSetting = ConfigurationManager.AppSettings;
                foreach (var app in appSetting)
                {
                    var appItem = app;
                }
                var config = ConfigurationManager.ConnectionStrings;
                foreach (var s in config)
                {
                    string sconfig         = s.ToString();
                    var    liste           = sconfig.Split(';').ToList();
                    string SourceProvider  = "";
                    string SourceCatalogue = "";
                    foreach (var param in liste)
                    {
                        if (param.Contains("provider connection string=\"data source="))
                        {
                            SourceProvider = param.Replace("provider connection string=\"data source=", "");
                        }
                        if (param.Contains("initial catalog="))
                        {
                            SourceCatalogue = param.Replace("initial catalog=", "");
                        }
                    }
                    if (!string.IsNullOrEmpty(SourceProvider) && !string.IsNullOrEmpty(SourceCatalogue))
                    {
                        StatutItemBDD statutItemBDD = new StatutItemBDD()
                        {
                            SourceProvider = SourceProvider, SourceCatalogue = SourceCatalogue
                        };
                        publishStatutAllBDD.listStatutItemBDD.Add(statutItemBDD);
                        sResult += "SourceProvider : " + SourceProvider + "  \nSourceCatalogue : " + SourceCatalogue;
                    }
                    else
                    {
                        sResult += "No SourceProvider and NoSourceCatalogue";
                    }
                }
            }
            catch (Exception ex) {
                GlobalLog.Instance().AjouteLog("SingleStatutBDD", "GetConnexionString ex :" + ex.Message);
                sResult += "Exception : " + ex.Message;
            }
            return(sResult);
        }
Exemple #2
0
        public void FirstConnexionStatut(string BddName, string EntitieName, bool IsOK, string sResult)
        {
            var bdd = publishStatutAllBDD.listStatutItemBDD.Where(c => c.SourceCatalogue == BddName).FirstOrDefault();

            if (bdd != null)
            {
                bdd.EntitieName = EntitieName;
                bdd.isOK        = IsOK;
                bdd.sResult     = sResult;
            }
            else
            {
                StatutItemBDD statutItemBDD = new StatutItemBDD()
                {
                    SourceProvider = "NC", SourceCatalogue = "NC", EntitieName = EntitieName, isOK = IsOK, sResult = sResult
                };
                publishStatutAllBDD.listStatutItemBDD.Add(statutItemBDD);
            }
        }