/// <summary> /// Before load data. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dataAccess_OnBeforeLoad(object sender, Custom.OperationArgs e) { // Determine if the data has change. if (PropertyChanged) { // Indicate that the data has changed. MessageBox.Show("The data has changed, please update first", "Load", MessageBoxButton.OK); _updateAttempt = true; e.Cancel = true; } else { // If in Add new state if (_addNew) { // Indicate that the data has changed. MessageBoxResult result = MessageBox.Show("Insert the changes before loading. Disregard the changes (all changes will be lost)?", "Load", MessageBoxButton.YesNo); if (result != MessageBoxResult.Yes) { e.Cancel = true; } } // If loading should take place. if (!e.Cancel) { // Show the selection form Nequeo.Wpf.DataGridWindow selectItem = new DataGridWindow(); selectItem.ConnectionTypeModel = dataAccess.ConnectionTypeModel; selectItem.LoadOnStart = true; selectItem.MaxRecords = 50; selectItem.OrderByClause = "AssetID DESC"; selectItem.ShowDialog(); // Has an item been selected. if (selectItem.SelectedRecord != null) { // Get the selected item. DataAccess.NequeoCompany.Data.Assets data = (DataAccess.NequeoCompany.Data.Assets)selectItem.SelectedRecord; // Assign the load item. dataAccess.OrderByClause = selectItem.OrderByClause; dataAccess.WhereClause = "AssetID = " + data.AssetID.ToString(); } else { e.Cancel = true; } } } }
/// <summary> /// Dlect member id /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSelectTransactionPaymentMemberID_Click(object sender, RoutedEventArgs e) { // Attempt to find the data member. DataAccess.NequeoCompany.Data.DataMemberTables dataMember = null; try { dataMember = _dataMemberTables.First(u => u.DataMemberID == _dataMemberTableIDTrans); } catch { } // If a data member has been found if (dataMember != null) { // Find the table name. string tableName = _dataMemberTables.First(u => u.DataMemberID.ToString().ToLower() == dataMember.Reference.ToLower()).DataTables; // Find the table key name string tableKeyName = _dataMemberTables.First(u => u.DataMemberID.ToString().ToLower() == dataMember.Reference.ToLower()).DataTableKeyName; // Get a new instance of the connection type model. Nequeo.ComponentModel.ConnectionTypeModel connectionModel = new ComponentModel.ConnectionTypeModel( "Nequeo.DataAccess.NequeoCompany.Data." + tableName + ",Nequeo.NequeoCompany.Model", _account.Current.Extension.Common.ConfigurationDatabaseConnection, _account.Current.Extension.Common.ConnectionType, _account.Current.Extension.Common.ConnectionDataType, _account.Current.Extension.Common.DataAccessProvider.GetType().AssemblyQualifiedName); // Show the selection form Nequeo.Wpf.DataGridWindow selectItem = new DataGridWindow(); selectItem.ConnectionTypeModel = connectionModel; selectItem.LoadOnStart = true; selectItem.MaxRecords = 50; selectItem.OrderByClause = tableKeyName + " DESC"; selectItem.ShowDialog(); // Has an item been selected. if (selectItem.SelectedRecord != null) { // Get the selected item. object data = selectItem.SelectedRecord; txtTransactionPaymentMemberID.Text = data.GetType().GetProperty(tableKeyName).GetValue(data, null).ToString(); } } }
/// <summary> /// Select employee /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSelectEmployeeReport_Click(object sender, RoutedEventArgs e) { Nequeo.ComponentModel.ConnectionTypeModel connectionModel = Nequeo.Data.Operation.GetTypeModel <DataAccess.NequeoCompany.Data.Employees, DataAccess.NequeoCompany.Data.Employees>(_employee.Current.Extension.Common); // Show the selection form Nequeo.Wpf.DataGridWindow selectItem = new DataGridWindow(); selectItem.ConnectionTypeModel = connectionModel; selectItem.LoadOnStart = true; selectItem.MaxRecords = 50; selectItem.OrderByClause = "EmployeeID DESC"; selectItem.ShowDialog(); // Has an item been selected. if (selectItem.SelectedRecord != null) { // Get the selected item. DataAccess.NequeoCompany.Data.Employees data = (DataAccess.NequeoCompany.Data.Employees)selectItem.SelectedRecord; txtEmployeeReportID.Text = data.EmployeeID.ToString(); } }
/// <summary> /// On select new super fund /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSelectBankAccount_Click(object sender, RoutedEventArgs e) { // Get a new instance of the connection type model. Nequeo.ComponentModel.ConnectionTypeModel connectionModel = Nequeo.Wpf.Common.Operation.GetTypeModel <DataAccess.NequeoCompany.Data.EmployeeBankAccounts>(dataAccess); // Show the selection form Nequeo.Wpf.DataGridWindow selectItem = new DataGridWindow(); selectItem.ConnectionTypeModel = connectionModel; selectItem.LoadOnStart = true; selectItem.MaxRecords = 50; selectItem.OrderByClause = "AccountID DESC"; selectItem.ShowDialog(); // Has an item been selected. if (selectItem.SelectedRecord != null) { // Get the selected item. DataAccess.NequeoCompany.Data.EmployeeBankAccounts data = (DataAccess.NequeoCompany.Data.EmployeeBankAccounts)selectItem.SelectedRecord; txtEmployeeAccountID.Text = data.AccountID.ToString(); } }
private void MyButton_Click7(object sender, RoutedEventArgs e) { //Show DataGrid DataGridWindow windowData2 = new DataGridWindow(); windowData2.Show(); }