/// <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>
/// 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();
}
}
/// <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;
}
}
}
}
}
