/// <summary> /// Select the Vendor /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSelectVendor_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.Vendors>(dataAccess); // Get a new instance of the connection type model. Nequeo.ComponentModel.ConnectionTypeModel connectionModelRef = Nequeo.Wpf.Common.Operation.GetTypeModel <DataAccess.NequeoCompany.Data.VendorDetails>(dataAccess); // Show the selection form Nequeo.Wpf.DataGridTwinWindow selectItem = new DataGridTwinWindow(); selectItem.ConnectionTypeModel = connectionModel; selectItem.ConnectionTypeModelReference = connectionModelRef; selectItem.LoadOnStart = true; selectItem.MaxRecords = 50; selectItem.OrderByClause = "VendorID DESC"; selectItem.OrderByClauseReference = "VendorDetailsID DESC"; selectItem.PrimarySearchPropertyName = "VendorID"; selectItem.ShowDialog(); // Has an item been selected. if (selectItem.SelectedRecord != null && selectItem.SelectedReferenceRecord != null) { // Get the selected item. DataAccess.NequeoCompany.Data.Vendors data = (DataAccess.NequeoCompany.Data.Vendors)selectItem.SelectedRecord; DataAccess.NequeoCompany.Data.VendorDetails dataRef = (DataAccess.NequeoCompany.Data.VendorDetails)selectItem.SelectedReferenceRecord; txtVendorID.Text = data.VendorID.ToString(); txtVendorDetailID.Text = dataRef.VendorDetailsID.ToString(); } }
/// <summary> /// On select new transaction /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSelectTransaction_Click(object sender, RoutedEventArgs e) { // Attempt to find the data member. DataAccess.NequeoCompany.Data.DataMemberTables dataMember = null; try{ dataMember = _dataMemberTables.First(u => u.DataMemberID == _dataMemberTableID); } 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; string tableRefName = dataMember.DataTables; // Find the table key name string tableKeyName = _dataMemberTables.First(u => u.DataMemberID.ToString().ToLower() == dataMember.Reference.ToLower()).DataTableKeyName; string tableKeyRefName = dataMember.DataTableKeyName; // Get a new instance of the connection type model. Nequeo.ComponentModel.ConnectionTypeModel connectionModel = Nequeo.Wpf.Common.Operation.GetTypeModel("Nequeo.DataAccess.NequeoCompany.Data." + tableName + ",Nequeo.NequeoCompany.Model", dataAccess); // Get a new instance of the connection type model. Nequeo.ComponentModel.ConnectionTypeModel connectionModelRef = Nequeo.Wpf.Common.Operation.GetTypeModel("Nequeo.DataAccess.NequeoCompany.Data." + tableRefName + ",Nequeo.NequeoCompany.Model", dataAccess); // Show the selection form Nequeo.Wpf.DataGridTwinWindow selectItem = new DataGridTwinWindow(); selectItem.ConnectionTypeModel = connectionModel; selectItem.ConnectionTypeModelReference = connectionModelRef; selectItem.LoadOnStart = true; selectItem.MaxRecords = 50; selectItem.OrderByClause = tableKeyName + " DESC"; selectItem.OrderByClauseReference = tableKeyRefName + " DESC"; selectItem.PrimarySearchPropertyName = tableKeyName; selectItem.ShowDialog(); // Has an item been selected. if (selectItem.SelectedRecord != null && selectItem.SelectedReferenceRecord != null) { // Get the selected item. object data = selectItem.SelectedRecord; object dataRef = selectItem.SelectedReferenceRecord; txtPaymentDataMemberID.Text = data.GetType().GetProperty(tableKeyName).GetValue(data, null).ToString(); txtPaymentDataMemberRefID.Text = dataRef.GetType().GetProperty(tableKeyRefName).GetValue(dataRef, null).ToString(); // If the current operation is not in // the loading or add new state. if (!_loading && !_addNew) { // If items exist if (txtDataMember.Items.Count > 0) { // If data member changes then set the payment data members to null. dataAccess.IsUpdateEnabled = true; } } } } }