public DataSourceCommunicator GetDataBaseConnection()
{
try
{
DBServiceConfig objXmlConfig = new DBServiceConfig();
Exception ce = new Exception();
DBServiceConfig.LoadFromFile(ConstantStrings.ConfigXMLPath, out objXmlConfig, out ce);
DataSourceCommunicator dbget = null;
if (objXmlConfig != null)
{
DBName = objXmlConfig.DBName;
dbget = new DataSourceCommunicator(DataSourceCommunicator.ParamType.ServerCredentials, objXmlConfig.DBServer, objXmlConfig.DBUser, objXmlConfig.DBPassword);
ce = null;
}
return(dbget);
}
catch (System.Exception ex)
{
Program.log.Write("Scheduler - Error : " + ex.Message);
return(null);
}
}
private void ReadConfigXML()
{
DBServiceConfig objXmlConfig = new DBServiceConfig();
Exception ce = new Exception();
DBServiceConfig.LoadFromFile(ConstantStrings.ConfigXMLPath, out objXmlConfig, out ce);
if (objXmlConfig != null)
{
txtdbserver.Text = objXmlConfig.DBServer;
txtdbname.Text = objXmlConfig.DBName;
txtdbuser.Text = objXmlConfig.DBUser;
txtdbpassword.Text = objXmlConfig.DBPassword;
txtadminemailadd.Text = objXmlConfig.AdminEmailAddress;
txterroremailadd.Text = objXmlConfig.ErrEmailAddress;
LastAccessed = objXmlConfig.LastAccessed;
txtSMTPServer.Text = objXmlConfig.SMTPServer;
txtSMTPSSL.Text = objXmlConfig.SMTPSSL;
txtSMTPPort.Text = objXmlConfig.SMTPPort;
txtSMTPSenderEmail.Text = objXmlConfig.SMTPSenderEmail;
txtSMTPSenderPwd.Text = objXmlConfig.SMTPSenderPwd;
}
objXmlConfig = null;
ce = null;
}
