/// <summary>
/// Test source connection and return bool based on validation
/// </summary>
/// <param name="Exception">will return the exception if any</param>
/// <returns>bool, true is connection validated successfully</returns>
private bool TestSourceConnection(out string Exception)
{
if (string.IsNullOrEmpty(txtSeverName.Text) || string.IsNullOrEmpty(txtSQLUserID.Text) || string.IsNullOrEmpty(txtSQLPwd.Text))
{
Exception = "";
JobSettingsStatus.Text = "Few field(s) value are missing in Source details!";
MessageBox.Show("Few field(s) value are missing in Source details!", "Job Settings", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(false);
}
string sConnectionString = Helper.ConnectionString(txtSeverName.Text, txtDbName.Text, txtSQLUserID.Text, txtSQLPwd.Text);
ConnectionString = sConnectionString;
if (PollPush.ValidateSQLConnection(sConnectionString, out Exception))
{
Exception = "";
JobSettingsStatus.Text = "Source Connection validated!";
return(true);
}
else
{
JobSettingsStatus.Text = "Error - " + "Source Connection is not valid! " + Exception;
JobSettingsStatus.ToolTipText = "Error - " + "Source Connection is not valid! " + Exception;
return(false);
}
}
