private void RefreshCodeList() { i9Message responseMsg = i9MessageManager.SendMessage(MobileMessageType.Admin, AdminType.Code_GetCodeList_Admin, ""); if (responseMsg.ErrorStatus.IsError) { LogManager.Instance.LogMessage(responseMsg.ErrorStatus); //AppCommand.SendCommand(AppCommandType.Error, AppSubCommandType.DisplayError, ""); MessageBox.Show("Unable to get codes, please try again.", "Codes", MessageBoxButton.OK, MessageBoxImage.Information); return; } DataSet CodeDataSet = responseMsg.MsgBodyDataSet; //string sql = "Select CodeSetName FROM i9Code group by CodeSetName order by CodeSetName"; //ClientDataAccess cda = new ClientDataAccess(); //DataTable dt = cda.GetDataTable(sql, "i9CodeSet"); if (CodeDataSet != null) { if (CodeDataSet.Tables.Count > 0) { if (AgencyComboBox.Items.Count <= 0) { AgencyComboBox.Items.Clear(); foreach (DataRow dr in CodeDataSet.Tables["i9Agency"].Rows) { ComboBoxItem cbi = new ComboBoxItem(); cbi.Content = dr["AgencyName"].ToString(); cbi.Tag = dr["i9AgencyID"].ToString(); int i = AgencyComboBox.Items.Add(cbi); } } if (AgencyComboBox.Items.Count > 0) { if (AgencyComboBox.SelectedItem == null) { AgencyComboBox.IsEnabled = false; AgencyComboBox.SelectedIndex = 0; AgencyComboBox.IsEnabled = true; } ComboBoxItem SelectCbi = (ComboBoxItem)AgencyComboBox.SelectedItem; string i9AgencyID = SelectCbi.Tag.ToString(); CodeTypesListBox.SelectedValuePath = "CodeSetName"; CodeTypesListBox.DisplayMemberPath = "CodeSetName"; DataView dv = CodeDataSet.Tables["i9Code"].DefaultView; dv.RowFilter = "i9AgencyID = '" + i9AgencyID + "'"; CodeTypesListBox.ItemsSource = dv; CodeTypesListBox.UnselectAll(); } else { CodeTypesListBox.ItemsSource = null; } } } else { AppCommand.SendCommand(AppCommandType.Error, AppSubCommandType.DisplayError, "Unable to retrieve data"); //Need to give an error message. } }
private void RefreshPersonnel() { //*********************************************************************************************** // load Security Groups //*********************************************************************************************** //if (SecurityGroupsListView.Items.Count <= 0) //{ // string sql = "Select * FROM i9SecurityGroup ORDER BY SecurityGroupName ASC"; // ClientDataAccess cda = new ClientDataAccess(); // DataTable i9SecurityGroupDT = cda.GetDataTable(sql, "i9SecurityGroup"); // //Add a new column for the UI List View Check List // if (i9SecurityGroupDT.Columns.Contains("Enabled") == false) // { // i9SecurityGroupDT.Columns.Add("Enabled", typeof(string)); // } // //Clear Check List // foreach (DataRow drv in i9SecurityGroupDT.Rows) // { // drv["Enabled"] = "False"; // } // SecurityGroupsListView.ItemsSource = i9SecurityGroupDT.DefaultView; //} //*********************************************************************************************** // Get codes from server dataset //*********************************************************************************************** string i9SysPersonnelID = SettingManager.Instance.LoginDataSet.Tables["i9SysPersonnel"].Rows[0]["i9SysPersonnelID"].ToString(); i9Message responseMsg = i9MessageManager.SendMessage(MobileMessageType.Admin, AdminType.SysPer_GetList, "", typeof(string), i9SysPersonnelID); if (responseMsg.ErrorStatus.IsError) { LogManager.Instance.LogMessage(responseMsg.ErrorStatus); //AppCommand.SendCommand(AppCommandType.Error, AppSubCommandType.DisplayError, ""); MessageBox.Show("Unable to get personnel, please try again.", "Personnel", MessageBoxButton.OK, MessageBoxImage.Information); return; } DataSet SysPerListDataSet = responseMsg.MsgBodyDataSet; if (SysPerListDataSet == null) { AppCommand.SendCommand(AppCommandType.Error, AppSubCommandType.DisplayError, "Unable to retrieve data"); //Error message. MessageBox.Show("Unable to get personnel, please try again.", "Personnel", MessageBoxButton.OK, MessageBoxImage.Information); } else { // Load Security Tasks RefreshSecurityGrid(i9SysPersonnelID); if (SysPerListDataSet.Tables.Count > 0) { if (AgencyComboBox.Items.Count <= 0) { AgencyComboBox.Items.Clear(); foreach (DataRow dr in SysPerListDataSet.Tables["i9Agency"].Rows) { ComboBoxItem cbi = new ComboBoxItem(); cbi.Content = dr["AgencyName"].ToString(); cbi.Tag = dr["i9AgencyID"].ToString(); int i = AgencyComboBox.Items.Add(cbi); } } if (AgencyComboBox.Items.Count > 0) { if (AgencyComboBox.SelectedItem == null) { AgencyComboBox.IsEnabled = false; AgencyComboBox.SelectedIndex = 0; AgencyComboBox.IsEnabled = true; } ComboBoxItem SelectCbi = (ComboBoxItem)AgencyComboBox.SelectedItem; string i9AgencyID = SelectCbi.Tag.ToString(); m_PersonnelListViewDV = SysPerListDataSet.Tables["i9SysPersonnel"].DefaultView; m_PersonnelListViewDV.RowFilter = "i9AgencyID = '" + i9AgencyID + "'"; PersonnelListView.ItemsSource = m_PersonnelListViewDV; PersonnelListView.UnselectAll(); } else { PersonnelListView.ItemsSource = null; } } } }