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