public void Load()
{
DataSet remoteDBUserSettings = new DataSet();
// Get the user settings from the remote DB for the current user's CNO...
remoteDBUserSettings = _webServices.GetData("get_user_settings", ":cooperatorid=" + _cno, 0, 0);
if (remoteDBUserSettings.Tables.Contains("get_user_settings"))
{
_userSettings.Clear();
_userSettings = remoteDBUserSettings.Tables["get_user_settings"].Copy();
}
else if (remoteDBUserSettings.Tables.Contains("ExceptionTable") &&
remoteDBUserSettings.Tables["ExceptionTable"].Rows.Count > 0)
{
//System.Windows.Forms.MessageBox.Show("There were errors retrieving user settings.\n\nFull error message:\n" + remoteDBUserSettings.Tables["ExceptionTable"].Rows[0]["Message"].ToString());
SharedUtils sharedUtils = new SharedUtils(_webServices.Url, _webServices.Username, _webServices.Password_ClearText, true);
GRINGlobal.Client.Common.GGMessageBox ggMessageBox = new GRINGlobal.Client.Common.GGMessageBox("There were errors retrieving user settings.\n\nFull error message:\n{0}", "Load User Settings Error", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxDefaultButton.Button1);
ggMessageBox.Name = "UserSettings_LoadMessage1";
if (sharedUtils != null && sharedUtils.IsConnected)
{
sharedUtils.UpdateControls(ggMessageBox.Controls, ggMessageBox.Name);
}
if (ggMessageBox.MessageText.Contains("{0}"))
{
ggMessageBox.MessageText = string.Format(ggMessageBox.MessageText, remoteDBUserSettings.Tables["ExceptionTable"].Rows[0]["Message"].ToString());
}
ggMessageBox.ShowDialog();
}
// Clean up...
remoteDBUserSettings.Dispose();
}
public void Load()
{
DataSet remoteDBData = new DataSet();
// Get the user resources from the remote DB for the current user's chosen language...
remoteDBData = _webServices.GetData("get_app_resource", ":appname=" + _appName + "; :syslangid=" + _lang.ToString() + ";", 0, 0);
if (remoteDBData.Tables.Contains("get_app_resource"))
{
if (_appResources != null)
{
_appResources.Clear();
}
_appResources = remoteDBData.Tables["get_app_resource"].Copy();
_appResources.DefaultView.RowFilter = "sys_lang_id=" + _lang.ToString();
}
// Get the app settings from the remote DB...
remoteDBData = _webServices.GetData("get_app_setting", "", 0, 0);
if (remoteDBData.Tables.Contains("get_app_setting"))
{
if (_appSettings != null)
{
_appSettings.Clear();
}
_appSettings = remoteDBData.Tables["get_app_setting"].Copy();
// Now load any local app setting stored on the users local drive...
Dictionary <string, string> localAppSettings = LoadLocalAppSettings();
foreach (string name in localAppSettings.Keys)
{
DataRow[] drs = _appSettings.DefaultView.ToTable().Select("name='" + name + "'");
if (drs.Length > 0)
{
foreach (DataRow dr in drs)
{
dr["value"] = localAppSettings[name];
}
}
else
{
DataRow newAppSetting = _appSettings.NewRow();
newAppSetting["name"] = name;
newAppSetting["value"] = localAppSettings[name];
_appSettings.Rows.Add(newAppSetting);
}
}
}
// Clean up...
remoteDBData.Dispose();
}
public DataSet GetWebServiceData(string dataviewName, string delimitedParameterList, int offset, int limit)
{
DataSet results = new DataSet();
DataSet dataViewParams = new DataSet();
if (IsConnected)
{
results = _webServices.GetData(dataviewName.ToLower(), delimitedParameterList, offset, limit);
}
return(results);
}
