//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);
}
}
