public static ActionResult CreateXmlSettingsFile(Session session) { sessionObj = session; string sqlservername = string.IsNullOrEmpty(session["SQLSERVERNAME"]) ? string.Empty : session["SQLSERVERNAME"]; string sqlinstancename = string.IsNullOrEmpty(session["SQLINSTANCENAME"]) ? string.Empty : session["SQLINSTANCENAME"]; string databasename = string.IsNullOrEmpty(session["DATABASENAME"]) ? string.Empty : session["DATABASENAME"]; string sapassword = string.IsNullOrEmpty(session["SAPASSWORD"]) ? string.Empty : session["SAPASSWORD"]; string omluseracct = string.IsNullOrEmpty(session["OMLUSERACCT"]) ? string.Empty : session["OMLUSERACCT"]; string omluserpassword = string.IsNullOrEmpty(session["OMLUSERACCT"]) ? string.Empty : session["OMLUSERACCT"]; if (string.IsNullOrEmpty(sqlservername) || string.IsNullOrEmpty(sqlinstancename) || string.IsNullOrEmpty(databasename) || string.IsNullOrEmpty(omluserpassword) || string.IsNullOrEmpty(omluserpassword)) { return(ActionResult.Failure); } if (xmlSettings == null) { xmlSettings = new XMLSettingsManager(); } xmlSettings.SQLServerName = sqlservername; xmlSettings.SQLInstanceName = sqlinstancename; xmlSettings.DatabaseName = databasename; xmlSettings.SAPassword = sapassword; xmlSettings.OMLUserAcct = omluseracct; xmlSettings.OMLUserPassword = omluserpassword; xmlSettings.SaveSettings(); return(ActionResult.Success); }
public static ActionResult CreateXmlSettingsFile(Session session) { sessionObj = session; string sqlservername = string.IsNullOrEmpty(session["SQLSERVERNAME"]) ? string.Empty : session["SQLSERVERNAME"]; string sqlinstancename = string.IsNullOrEmpty(session["SQLINSTANCENAME"]) ? string.Empty : session["SQLINSTANCENAME"]; string databasename = string.IsNullOrEmpty(session["DATABASENAME"]) ? string.Empty : session["DATABASENAME"]; string sapassword = string.IsNullOrEmpty(session["SAPASSWORD"]) ? string.Empty : session["SAPASSWORD"]; string omluseracct = string.IsNullOrEmpty(session["OMLUSERACCT"]) ? string.Empty : session["OMLUSERACCT"]; string omluserpassword = string.IsNullOrEmpty(session["OMLUSERACCT"]) ? string.Empty : session["OMLUSERACCT"]; if (string.IsNullOrEmpty(sqlservername) || string.IsNullOrEmpty(sqlinstancename) || string.IsNullOrEmpty(databasename) || string.IsNullOrEmpty(omluserpassword) || string.IsNullOrEmpty(omluserpassword)) return ActionResult.Failure; if (xmlSettings == null) xmlSettings = new XMLSettingsManager(); xmlSettings.SQLServerName = sqlservername; xmlSettings.SQLInstanceName = sqlinstancename; xmlSettings.DatabaseName = databasename; xmlSettings.SAPassword = sapassword; xmlSettings.OMLUserAcct = omluseracct; xmlSettings.OMLUserPassword = omluserpassword; xmlSettings.SaveSettings(); return ActionResult.Success; }
public static ActionResult ScanNetworkForSqlServers(Session session) { sessionObj = session; if (xmlSettings == null) { xmlSettings = new XMLSettingsManager(); } if ((session["HASSCANNEDFORSQL"].CompareTo("0") == 0) && (session["ISSERVERINSTALL"] != "0")) { if (xmlSettings.SettingsFileExists()) { return(ActionResult.SkipRemainingActions); } else { DataTable dt = SqlDataSourceEnumerator.Instance.GetDataSources(); View sqlComboBox = session.Database.OpenView("SELECT * FROM `ComboBox`"); sqlComboBox.Execute(); int numRows = 0; while (sqlComboBox.Fetch() != null) { numRows++; } if (numRows == 1) { CustomActions.LogToSession(string.Format("found {0} sql servers", dt.Rows.Count)); int itemNumber = 2; foreach (DataRow row in dt.Rows) { Record rec = new Record(3); rec.SetString(1, "OMLProp_SqlServers"); rec.SetInteger(2, itemNumber); string description = string.Format("{0} - {1}", row["ServerName"], row["InstanceName"]); rec.SetString(3, description); CustomActions.LogToSession(string.Format("Adding a new record, its number will be {0} and its value will be {1}", itemNumber, string.Format("{0} ({1})", row["ServerName"], row["InstanceName"]))); sqlComboBox.Modify(ViewModifyMode.InsertTemporary, rec); itemNumber++; } } } session["HASSCANNEDFORSQL"] = "1"; } return(ActionResult.Success); }
public static ActionResult ScanNetworkForSqlServers(Session session) { sessionObj = session; if (xmlSettings == null) xmlSettings = new XMLSettingsManager(); if ((session["HASSCANNEDFORSQL"].CompareTo("0") == 0) && (session["ISSERVERINSTALL"] != "0")) { if (xmlSettings.SettingsFileExists()) { return ActionResult.SkipRemainingActions; } else { DataTable dt = SqlDataSourceEnumerator.Instance.GetDataSources(); View sqlComboBox = session.Database.OpenView("SELECT * FROM `ComboBox`"); sqlComboBox.Execute(); int numRows = 0; while (sqlComboBox.Fetch() != null) { numRows++; } if (numRows == 1) { CustomActions.LogToSession(string.Format("found {0} sql servers", dt.Rows.Count)); int itemNumber = 2; foreach (DataRow row in dt.Rows) { Record rec = new Record(3); rec.SetString(1, "OMLProp_SqlServers"); rec.SetInteger(2, itemNumber); string description = string.Format("{0} - {1}", row["ServerName"], row["InstanceName"]); rec.SetString(3, description); CustomActions.LogToSession(string.Format("Adding a new record, its number will be {0} and its value will be {1}", itemNumber, string.Format("{0} ({1})", row["ServerName"], row["InstanceName"]))); sqlComboBox.Modify(ViewModifyMode.InsertTemporary, rec); itemNumber++; } } } session["HASSCANNEDFORSQL"] = "1"; } return ActionResult.Success; }