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