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