private void AddApplication(ScriptEngine.environemnt env, string table, string name, string sourceCol, string sourceVal, string otherIDName, string otherIDVal, string action)
{
try
{
DataTable dtInsert = dsDev.Tables["Applications"].Clone();
dtInsert.TableName = "ApplicationInput";
dtInsert.Columns.Add("Operation");
dtInsert.ImportRow(dsDev.Tables["Applications"].Rows[0]);
foreach (DataRow drApp in dsFrom.Tables["Applications"].Rows)
{
if (drApp["ApplicationID"].ToString() == sourceVal)
{
dtInsert.Rows[0]["ApplicationID"] = drApp["ApplicationID"].ToString();
dtInsert.Rows[0]["ShortName"] = drApp["ShortName"].ToString();
dtInsert.Rows[0]["Description"] = drApp["Description"].ToString();
dtInsert.Rows[0]["Operation"] = "I";
DataSet ds = ScriptEngine.script.runScript(env, dtInsert, "GET_SCRIPTS_INFO", "GENERAL");
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error trying to AddApplication: " + Environment.NewLine + ex.ToString());
}
}
private void AddApplicationSchemas(ScriptEngine.environemnt env, string table, string name, string sourceCol, string sourceVal, string otherIDName, string otherIDVal, string action)
{
DataTable dtInsert = dsDev.Tables["ApplicationSchemas"].Clone();
dtInsert.TableName = "ApplicationSchemaInput";
dtInsert.Columns.Add("Operation");
dtInsert.ImportRow(dsDev.Tables["ApplicationSchemas"].Rows[0]);
foreach (DataRow drApp in dsFrom.Tables["ApplicationSchemas"].Rows)
{
if ((drApp[sourceCol].ToString() == sourceVal) && (drApp["SchemaID"].ToString() == name))
{
dtInsert.Rows[0]["ApplicationID"] = drApp["ApplicationID"].ToString();
dtInsert.Rows[0]["SchemaID"] = drApp["SchemaID"].ToString();
dtInsert.Rows[0]["Operation"] = action.Substring(0, 1);
DataSet ds = ScriptEngine.script.runScript(env, dtInsert, "GET_SCRIPTS_INFO", "GENERAL");
}
}
}
private void setupScreen(string direction)
{
if (direction.StartsWith("Dev"))
{
rsseViewFrom.Title = "Dev";
rsseViewFrom.dataFrom = dsDev;
rsseViewFrom.dataTo = dsTest;
rsseViewTo.Title = "Test";
rsseViewTo.dataFrom = dsTest;
rsseViewTo.dataTo = null;
dsFrom = dsDev;
dsTo = dsTest;
fromEnv = ScriptEngine.environemnt.DEV;
toEnv = ScriptEngine.environemnt.TEST;
}
else
{
rsseViewFrom.Title = "Test";
rsseViewFrom.dataFrom = dsTest;
rsseViewFrom.dataTo = dsProd;
rsseViewTo.Title = "Prod";
rsseViewTo.dataFrom = dsProd;
rsseViewTo.dataTo = null;
dsFrom = dsTest;
dsTo = dsProd;
fromEnv = ScriptEngine.environemnt.TEST;
toEnv = ScriptEngine.environemnt.PROD;
}
}
private void LoadRSSEInfo(ScriptEngine.environemnt env, out DataSet ds)
{
ds = ScriptEngine.script.runScript(env, new DataTable(), "GET_SCRIPTS_INFO", "GENERAL");
}
