public static bool SetConnIDs(User user, bool isTest) { if (isTest) { // Use default connections when debugging user.OCConnID = idTestOC; user.NPConnID = idTestNP; user.SHConnID = idTestSH; // Use OC ID user.SLConnID = idTestSL; // Use OC ID return(true); } DBConnect connection = new DBConnect(); if (!connection.Connect(ConnectionsMgr.GetAdminConnInfo())) { return(false); } try { using (var res = connection.Select(new[] { columnOCConnID, columnNPConnID, columnSHConnID, columnSLConnID }, tableConnectionIDInfo, string.Format("WHERE {0}='{1}'", columnCustomer, user.Customer))) { if (!res.Read()) { // No info for customer? ProgramLog.LogError(user.UserName, user.Customer, "EDIO", "ConnectionsMgr", "SetConnIDs", string.Format("Unable to find connection info in {0} for customer {1}", tableConnectionIDInfo, user.Customer)); connection.Close(); return(false); } user.OCConnID = res.Field(0); user.NPConnID = res.Field(1); user.SHConnID = res.Field(2); user.SLConnID = res.Field(3); } connection.Close(); return(true); } catch (Exception e) { ProgramLog.LogError(user, "ConnectionsMgr", "SetConnIDs", e.Message); connection.Close(); return(false); } }
private static DatabaseInfo _GetConnInfo(User user, string connID, string database = "") { DatabaseInfo dbInfo = new DatabaseInfo(); DBConnect connection = new DBConnect(); if (!connection.Connect(ConnectionsMgr.GetAdminConnInfo())) { ProgramLog.LogError(user, "ConnectionInfo", "_GetConnInfo", "Unable to connect to admin database."); return(dbInfo); } using (var res = connection.Select(new[] { columnServer, columnPort, columnIsTest }, tableAllPorts, string.Format("WHERE {0}='{1}'", columnConnectID, connID.SQLEscape()))) { if (!res.Read()) { ProgramLog.LogError(user, "ConnectionInfo", "_GetConnInfo", string.Format("Unable to find info in table \"{0}\" for connection ID \"{1}\".", tableConnectionIDInfo, connID.SQLEscape())); connection.Close(); return(dbInfo); } dbInfo.Server = res.Field(0); dbInfo.Port = (int)res.Field2(1); dbInfo.IsTest = (int)res.Field2(2) != 0; } connection.Close(); dbInfo.Id = connID; dbInfo.Database = string.IsNullOrWhiteSpace(database) ? databaseHome : database; dbInfo.Driver = _DefaultDriver; if (cred.ContainsKey(dbInfo.Id)) { dbInfo.Username = cred[dbInfo.Id].UserName; dbInfo.Password = cred[dbInfo.Id].Password; } else { dbInfo.Username = defaultCred.UserName; dbInfo.Password = defaultCred.Password; } return(dbInfo); }