// - - - - - - - - - - - - - - - - - - - - - - - - - - - - - public void OpenDB(HttpRequest request) { if (DB_SQL._ViewModel == null || !DB_SQL._ViewModel.CheckConnection()) { string ConnectionString = GetConnectionString("ZeConnectionString"); //#if DEBUG if (string.IsNullOrEmpty(ConnectionString)) { //if (request.Host.ToString().ToUpper().Contains("DEV") || request.Host.ToString().ToUpper().Contains("LOCALHOST")) //{ // string Server = "sql6005.site4now.net"; // string DBase = "DB_A44F11_StockAPPro2dev"; // string User = "******"; // string Password = ""; // ConnectionString = $"Data Source={Server};Initial Catalog={DBase};Persist Security Info=True;User ID={User};Password={Password};MultipleActiveResultSets=True"; //} //else { string Server = "sql6007.site4now.net"; string DBase = "DB_A44F11_HorsDA"; string User = "******"; string Password = "******"; ConnectionString = $"Data Source={Server};Initial Catalog={DBase};Persist Security Info=True;User ID={User};Password={Password};MultipleActiveResultSets=True"; }; } ; //#endif if (string.IsNullOrEmpty(ConnectionString)) { MainViewModel.Current.Connection.LastError = "No ConnectionString ..."; return; } ; Connection = new DBSQLViewModel(new SQLServerEngine()); DB_SQL._ViewModel = Connection; Log.Write("", $"{ConnectionString} {(Connection.Open(ConnectionString, true) ? "OK" : "KO")}"); //CleanAuditTrail(); //ToDo: UpdateSessions(); //if (!MainViewModel.Current.CheckDB()) //{ // Log.Write(new AuditTrail() // { // Application = "wsStockAPPro", // Message = "Version de base de données incompatible!", // Level = ErrorLevel.Critical, // }); //}; } ; }
public void Init_AT_SQLServer2() { string server = "SQL6005.site4now.net"; string db = "DB_A44F11_StockAPPro2dev"; string user = "******"; string password = "******"; DBSQLViewModel AuditTrailConnection = null; AuditTrailConnection = new DBSQLViewModel(new SQLServerEngine()); string AT_ConnectionString = DB_SQL.GenConnectionString(DBType.SQLServer, server, db, user, password); AuditTrailConnection.Open(AT_ConnectionString, true); AuditTrailViewModel.Current.Init(new DBAndFileAuditTrailWriter(AuditTrailConnection, string.Format(@"{0}", AuditTrailFileName))); // AuditTrailViewModel.Current.MaxLines = 5; //AuditTrailViewModel.Current.Clean(); // prend en compte uniquement nombre ligne Assert.AreEqual(true, AuditTrailConnection.CheckConnection()); }
public void Init_AT_PG() { string server = "postgresql-zpf.alwaysdata.net"; string db = "zpf_postgresql"; string user = "******"; string password = "******"; DBSQLViewModel AuditTrailConnection = null; AuditTrailConnection = new DBSQLViewModel(new PostgreSQLEngine()); string AT_ConnectionString = DB_SQL.GenConnectionString(DBType.PostgreSQL, server, db, user, password); AuditTrailConnection.Open(AT_ConnectionString, true); AuditTrailViewModel.Current.Init(new DBAndFileAuditTrailWriter(AuditTrailConnection, string.Format(@"{0}", AuditTrailFileName))); AuditTrailViewModel.Current.MaxLines = 5; AuditTrailViewModel.Current.Clean(); // prend en compte uniquement nombre ligne Assert.AreEqual(true, AuditTrailConnection.CheckConnection()); }