private void SaveData() { String data = ""; foreach (DataGridViewRow row in programsGrid.Rows) { // Ignore last row if (row.Index == programsGrid.Rows.Count - 1) { break; } String name = row.Cells["gridcolname"].Value.ToString(); String server = row.Cells["gridcolserver"].Value.ToString(); String user = row.Cells["gridcoluser"].Value.ToString(); String password = row.Cells["gridcolpassword"].Value.ToString(); String dbname = row.Cells["gridcoldbname"].Value.ToString(); data += String.Format("{0}<limiter>{1}<limiter>{2}<limiter>{3}<limiter>{4}<limiter1>", name, server, user, password, dbname); } RegistrySupport registry = new RegistrySupport(); if (registry.Write(Settings.PROGRAM_GRID_KEY, data)) { MessageBox.Show("Settings Saved"); this.Close(); } }
private void LoadData() { try { if (_isAdminconnection) { RegistrySupport registry = new RegistrySupport(); String data = registry.Read(Settings.PROGRAM_GRID_KEY); String[] programs = data.Split(new String[] { "<limiter1>" }, StringSplitOptions.RemoveEmptyEntries); foreach (String program in programs) { String[] records = program.Split(new String[] { "<limiter>" }, StringSplitOptions.RemoveEmptyEntries); programsGrid.Rows.Add(records); } } else { RegistrySupport registry = new RegistrySupport(); String data = registry.Read(Settings.CLIENT_GRID_KEY); String[] programs = data.Split(new String[] { "<limiter1>" }, StringSplitOptions.RemoveEmptyEntries); foreach (String program in programs) { String[] records = program.Split(new String[] { "<limiter>" }, StringSplitOptions.RemoveEmptyEntries); clientgrid.Rows.Add(records); } } } catch (Exception) { } }
private void SaveData() { String data = ""; if (_isAdminconnection) { foreach (DataGridViewRow row in programsGrid.Rows) { // Ignore last row if (row.Index == programsGrid.Rows.Count - 1) { break; } String name = row.Cells["names"].Value.ToString(); String server = row.Cells["server"].Value.ToString(); String directory = row.Cells["directory"].Value.ToString(); String user = row.Cells["user"].Value.ToString(); String password = row.Cells["password"].Value.ToString(); String local = row.Cells["local"].Value.ToString(); String isAbbot = "false"; if (row.Cells["isAbbot"].Value != null) { isAbbot = row.Cells["isAbbot"].Value.ToString(); } String dbname = row.Cells["dbname"].Value.ToString(); data += String.Format("{0}<limiter>{1}<limiter>{2}<limiter>{3}<limiter>{4}<limiter>{5}<limiter>{6}<limiter>{7}<limiter1>", name, server, directory, user, password, local, isAbbot, dbname);//, exe, dbname); } RegistrySupport registry = new RegistrySupport(); if (registry.Write(Settings.PROGRAM_GRID_KEY, data)) { DevComponents.DotNetBar.MessageBoxEx.Show("Settings Saved"); } } else { foreach (DataGridViewRow row in clientgrid.Rows) { // Ignore last row if (row.Index == clientgrid.Rows.Count - 1) { break; } String name = row.Cells[clientname.Name.ToString()].Value.ToString(); String directory = row.Cells[clientdir.Name.ToString()].Value.ToString(); String dbtype = row.Cells[clientdbtype.Name.ToString()].Value.ToString(); data += String.Format("{0}<limiter>{1}<limiter>{2}<limiter1>", name, directory, dbtype); } RegistrySupport registry = new RegistrySupport(); if (registry.Write(Settings.CLIENT_GRID_KEY, data)) { DevComponents.DotNetBar.MessageBoxEx.Show("Settings Saved"); } } }
public static void SetConnectionDetails() { RegistrySupport registry = new RegistrySupport(); String data = registry.Read(Settings.PROGRAM_GRID_KEY); if (data == null) { return; } String[] programs = data.Split(new String[] { "<limiter1>" }, StringSplitOptions.RemoveEmptyEntries); Dictionary <String, Dictionary <String, String> > conn = new Dictionary <String, Dictionary <String, String> >(); foreach (String program in programs) { String[] records = program.Split(new String[] { "<limiter>" }, StringSplitOptions.RemoveEmptyEntries); Dictionary <String, String> details = new Dictionary <String, String>(); details.Add("NAME", records[0]); details.Add("SERVER", records[1]); details.Add("USERNAME", records[2]); details.Add("PASSWORD", records[3]); details.Add("DBNAME", records[4]); switch (records[0].ToUpper()) { case "DBSETTINGS": conn.Add("SETTINGS", details); break; case "MASTER": conn.Add("MASTER", details); break; case "WMS": conn.Add("WMS", details); break; case "ABBOT": conn.Add("ABBOT", details); break; case "DONGA": conn.Add("DONGA", details); break; case "CAMBERT": conn.Add("CAMBERT", details); break; } } DBConnection = conn; }
public static void SetConnectionDetails() { RegistrySupport registry = new RegistrySupport(); String data = registry.Read(Settings.PROGRAM_GRID_KEY); if (data == null) { return; } String[] programs = data.Split(new String[] { "<limiter1>" }, StringSplitOptions.RemoveEmptyEntries); Dictionary <String, Dictionary <String, String> > conn = new Dictionary <String, Dictionary <String, String> >(); foreach (String program in programs) { String[] records = program.Split(new String[] { "<limiter>" }, StringSplitOptions.RemoveEmptyEntries); Dictionary <String, String> details = new Dictionary <String, String>(); details.Add("SoftwareName", records[0]); details.Add("Server", records[1]); details.Add("Directory", records[2]); details.Add("User", records[3]); details.Add("password", records[4]); details.Add("Local", records[5]); details.Add("isAbbot", records[6]); if (records.Count() == 8) { details.Add("DatabaseName", records[7]); } switch (records[0].ToUpper()) { case "DISPATCH": conn.Add("DISPATCH", details); break; case "WMS": conn.Add("WMS", details); break; case "ABBOT": conn.Add("ABBOT", details); break; case "DONGA": conn.Add("DONGA", details); break; case "OMS": conn.Add("OMS", details); break; } } DBConnection = conn; registry = new RegistrySupport(); data = registry.Read(Settings.CLIENT_GRID_KEY); if (data == null) { return; } programs = data.Split(new String[] { "<limiter1>" }, StringSplitOptions.RemoveEmptyEntries); conn = new Dictionary <String, Dictionary <String, String> >(); foreach (String program in programs) { String[] records = program.Split(new String[] { "<limiter>" }, StringSplitOptions.RemoveEmptyEntries); Dictionary <String, String> details = new Dictionary <String, String>(); details.Add("ClientName", records[0]); details.Add("Directory", records[1]); details.Add("DBTYPE", records[2]); conn.Add(records[0], details); } ClientConnection = conn; }