protected void btnTest2_Click(object sender, EventArgs e)
{
SqlProcedures UrpSqlProcedures = new SqlProcedures();
Instruction instruction = UrpSqlProcedures.LoadInstructions(1);
lblTest2.Text = instruction.Body;
}
public static void SetSingleSubscriptionInstalledDB(string DBName, string mainServiceName, string password, string subscriber, string procedureName, SqlParameterCollection testProcedureParameters)
{
SetAdminInstalledDB(DBName, mainServiceName, password);
Subscription subscription = new Subscription(
mainServiceName,
subscriber,
CommonTestsValues.SubscribedProcedureSchema,
procedureName,
testProcedureParameters);
SqlProcedures sqlProcedures = new SqlProcedures(serviceAccessDB);
sqlProcedures.InstallSubscription(subscription);
}
public static void SetTwoSubscriptionInstalledDB(string DBName, string mainServiceName, string password, string firstSubscriber, string firstProcedureName, SqlParameterCollection firstTestProcedureParameters, string secondSubscriber, string secondProcedureName, SqlParameterCollection secondTestProcedureParameters)
{
SetSingleSubscriptionInstalledDB(
DBName,
mainServiceName,
password,
firstSubscriber,
firstProcedureName,
firstTestProcedureParameters);
Subscription subscription = new Subscription(
mainServiceName, secondSubscriber,
CommonTestsValues.SubscribedProcedureSchema,
secondProcedureName,
secondTestProcedureParameters);
SqlProcedures sqlProcedures = new SqlProcedures(serviceAccessDB);
sqlProcedures.InstallSubscription(subscription);
}
protected void btnTest_Click(object sender, EventArgs e)
{
SqlProcedures UrpSqlProcedures = new SqlProcedures();
if (UrpSqlProcedures.TestConnection())
{
lblTest.Text = "urpDB connection established";
DataSet testData = new DataSet();
//testData = UrpSqlProcedures.LoadAdministrator();
StringBuilder sbTest = new StringBuilder();
for (int i = 0; i < testData.Tables[0].Rows.Count; i++)
{
sbTest.Append(testData.Tables[0].Rows[i][1] + "\n");
}
lblTest.Text = sbTest.ToString();
}
else
{
lblTest.Text = "Connection Failed to Open";
}
}
