//public SQLManager(string p_ConStr = "", int p_Timeout = 0) //{ // try // { // if (p_ConStr.Trim().Length == 0) { p_ConStr = "keThlJ083f5A0K7QpTaVBoximvs7SA2y8xIvGRciTRbwLDqcuOv+8PNZdrXJyxRpQ52DQYNbZC/5m20ouuoX0lZBg6lQ4MYR9taS16CQvztDeztfYvX0pw=="; } // //Make Sure Connection Info ends properly. // if (g_ConStr.Trim().Length > 0) // { g_ConStr = (g_ConStr + ";").Replace(";;", ";"); } // #region Custom Settings // //Apply Custom Connection Timeout // if (g_ConStr.Length > 0 && p_Timeout > 0) // { // g_Timeout = p_Timeout; // if (g_ConStr.Contains("Connection Timeout=120;") == true) { g_ConStr = g_ConStr.Replace("Connection Timeout=120;", ""); } // if (g_ConStr.Contains("Connection Timeout=60;") == true) { g_ConStr = g_ConStr.Replace("Connection Timeout=60;", ""); } // g_ConStr += "Connection Timeout=" + p_Timeout.ToString() + ";"; // } // //Apply default connection timeout if not exists // if (g_ConStr.Length > 0 && g_ConStr.Contains("Connection Timeout") == false) { g_ConStr += "Connection Timeout=60;"; } // #endregion // //initiate connection // DBCon(); // } // catch (System.Exception ex) { throw new Exception("DBM-DBMGR: " + ex.Message); } // finally { } //}//end of Constructor static Connection() { try { if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + "\\config.txt")) { fcontent = File.ReadAllText(AppDomain.CurrentDomain.BaseDirectory + "\\config.txt"); using (StreamReader sr = new StreamReader(AppDomain.CurrentDomain.BaseDirectory + "\\config.txt")) { string line; int i = 1; while ((line = sr.ReadLine()) != null) { if (i == 1) { dbname = line.ToString().Trim(); } else if (i == 2) { dbhost = line.ToString().Trim(); } else if (i == 3) { dbusername = line.ToString().Trim(); } else if (i == 4) { dbpass = line.ToString().Trim(); } i++; } } } EncryptDecryptEngine _objED = new EncryptDecryptEngine(); g_ConStr = String.Format("server={0};user id={1}; password={2};AllowZeroDateTime=True;AllowUserVariables=True;" + "database=" + _objED.Decrypt(dbname.ToString().Trim(), true) + "; pooling=false", "" + _objED.Decrypt(dbhost.ToString().Trim(), true) + "", "" + _objED.Decrypt(dbusername.ToString().Trim(), true) + "", "" + _objED.Decrypt(dbpass.ToString().Trim(), true) + ""); DBCon(); } catch (Exception pcex) { Library.LogError(pcex); } }
public void RestartConnection() { try { if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + "\\config.txt")) { fcontent = File.ReadAllText(AppDomain.CurrentDomain.BaseDirectory + "\\config.txt"); using (StreamReader sr = new StreamReader(AppDomain.CurrentDomain.BaseDirectory + "\\config.txt")) { string line; int i = 1; while ((line = sr.ReadLine()) != null) { if (i == 1) { dbname = line.ToString().Trim(); } else if (i == 2) { dbhost = line.ToString().Trim(); } else if (i == 3) { dbusername = line.ToString().Trim(); } else if (i == 4) { dbpass = line.ToString().Trim(); } else if (i == 5) { dbport = line.ToString().Trim(); } i++; } } //Library.WriteErrorLog("FRom code --- " + dbname + "====" + dbhost + "=====" + dbusername + "=====" + dbpass + "====" + dbport); } EncryptDecryptEngine _objED = new EncryptDecryptEngine(); if (string.IsNullOrEmpty(dbport)) { dbport = "3306"; dbport = _objED.Encrypt(dbport.ToString().Trim(), true); } conStr = String.Format("server={0};user id={1}; password={2};AllowZeroDateTime=True;AllowUserVariables=True;" + "database=" + _objED.Decrypt(dbname.ToString().Trim(), true) + "; pooling=false ;SslMode=none;port={3}", "" + _objED.Decrypt(dbhost.ToString().Trim(), true) + "", "" + _objED.Decrypt(dbusername.ToString().Trim(), true) + "", "" + _objED.Decrypt(dbpass.ToString().Trim(), true) + "", "" + _objED.Decrypt(dbport.ToString().Trim(), true) + ""); Library.WriteErrorLog("HRDsqAPI conn: " + conStr); } catch (Exception pcex) { Library.WriteErrorLog(pcex.Message); //MessageBox.Show("Database Connection Problem: " + pcex.Message.ToString()); } }
public async Task <User> GetServerDetail(User oUserInfo) { try { //================================================= using (var client = new HttpClient()) { client.BaseAddress = new Uri(baseURL); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); // HTTP POST HttpResponseMessage response = await client.PostAsJsonAsync("api/opendental/IsServerVerify", oUserInfo); if (response.IsSuccessStatusCode) { oUserInfo = await response.Content.ReadAsAsync <User>(); } } return(oUserInfo); } catch (Exception) { User objuserinfo1 = new User(); string UserPrefName = "PX_UserAccountDetails"; string cmd = "select ValueString from preference where prefname = '" + UserPrefName + "' "; string DecryptedAccount = string.Empty; string MachineDetails = Convert.ToString(conn.ExecuteScalar(cmd, CommandType.Text, null)); EncryptDecryptEngine _objED = new EncryptDecryptEngine(); Library.WriteErrorLog("machine details - " + MachineDetails); if (!string.IsNullOrEmpty(MachineDetails)) { DecryptedAccount = _objED.Decrypt(MachineDetails, true); List <User> listUser = new JavaScriptSerializer().Deserialize <List <User> >(DecryptedAccount); if (listUser != null && listUser.Count > 0) { objuserinfo1 = listUser.Where(a => a.UserHDDInfo.Exists(b => b.HDDNumber.Equals(clsHDInfo.MacAddress()))).FirstOrDefault(); if (objuserinfo1 != null) { if (objuserinfo1.Message.ToString().Equals("Approved")) { //use objuserinfo1 object to access authtoken etc. } } else { Library.WriteErrorLog("User Data is null while getting data from HrdsqApiand px_account details"); } } } return(objuserinfo1); } }