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