internal static SearchItem SearchGeneralLedgerAccount()
{
var searchItems = new System.Collections.Generic.List <SearchItem>();
var sql = DatabaseController.GenerateSelectStatement("generic_accounts");
var dataTable = DatabaseController.ExecuteSelectQuery(sql);
foreach (System.Data.DataRow dataRow in dataTable.Rows)
{
var id = Utilities.DataConverter.ToInteger(dataRow["id"]);
var code = Utilities.DataConverter.ToString(dataRow["account_code"]);
var title = Utilities.DataConverter.ToString(dataRow["account_title"]);
var item = new SearchItem(id, title);
item.ItemCode = code;
searchItems.Add(item);
}
var searchByCodeWindow = new SearchByCodeWindow(searchItems);
searchByCodeWindow.ShowDialog();
if (searchByCodeWindow.DialogResult == false)
{
return(null);
}
//var searchItem = new Account();
//searchItem.Find(searchByCodeWindow.SelectedItem.ItemId);
return(searchByCodeWindow.SelectedItem);
}
//internal static void MoveFocusToNextControlOnEnter(object sender, KeyEventArgs e) {
// if (e.Key != Key.Enter) return;
// var tRequest = new TraversalRequest(FocusNavigationDirection.Next);
// var keyboardFocus = Keyboard.FocusedElement as UIElement;
// if (keyboardFocus != null) {
// keyboardFocus.MoveFocus(tRequest);
// }
// e.Handled = true;
//}
internal static Nfmb SearchMember()
{
var members = Nfmb.GetList();
var searchItems =
members.Select(
member =>
new SearchItem(member.ID, member.MemberName)
{
ItemCode = member.MemberCode
}).
ToList();
var searchByCodeWindow = new SearchByCodeWindow(searchItems);
searchByCodeWindow.ShowDialog();
if (searchByCodeWindow.DialogResult == false)
{
return(null);
}
var searchItem = new Nfmb();
searchItem.Find(searchByCodeWindow.SelectedItem.ItemId);
return(searchItem);
}
internal static Account SearchAccount()
{
var accounts = Account.CollectAll();
var searchItems =
accounts.Select(
account =>
new SearchItem(account.ID, account.AccountTitle)
{
ItemCode = account.AccountCode
}).ToList();
var searchByCodeWindow = new SearchByCodeWindow(searchItems);
searchByCodeWindow.ShowDialog();
if (searchByCodeWindow.DialogResult == false)
{
return(null);
}
var searchItem = new Account();
searchItem.Find(searchByCodeWindow.SelectedItem.ItemId);
return(searchItem);
}
private void SelectAccount(object sender, RoutedEventArgs e)
{
List <Account> accounts = Account.GetList();
// create list of search items
List <SearchItem> searchItems =
accounts.Select(
account =>
new SearchItem(account.ID, account.AccountTitle)
{
ItemCode = account.AccountCode
}).ToList();
var searchByCodeWindow = new SearchByCodeWindow(searchItems);
searchByCodeWindow.ShowDialog();
if (searchByCodeWindow.DialogResult != true)
{
return;
}
var accountSelect = new Account();
accountSelect.Find(searchByCodeWindow.SelectedItem.ItemId);
_currentLoanCharges.AccountCode = accountSelect.AccountCode;
_currentLoanCharges.AccountTitle = accountSelect.AccountTitle;
DataContext = new LoanCharge();
DataContext = _currentLoanCharges;
}
private void SearchAccount(object sender, EventArgs e)
{
List <Account> accounts = Account.GetList();
// create list of search items
List <SearchItem> searchItems =
accounts.Select(
account =>
new SearchItem(account.AccountId, account.AccountTitle)
{
ItemCode = account.AccountCode
}).ToList();
var searchByCodeWindow = new SearchByCodeWindow(searchItems);
searchByCodeWindow.ShowDialog();
if (searchByCodeWindow.DialogResult != true)
{
return;
}
_account.Find(searchByCodeWindow.SelectedItem.ItemId);
_transactionDetail.AccountCode = _account.AccountCode;
_transactionDetail.AccountTitle = _account.AccountTitle;
DataContext = new TransactionDetail(); // to trigger a change in datacontext
DataContext = _transactionDetail;
}
private void SearchMember(object sender, EventArgs e)
{
List <Member> members = Member.GetList();
// create list of search items
List <SearchItem> searchItems =
members.Select(
member =>
new SearchItem(member.MemberId, member.MemberName)
{
ItemCode = member.MemberCode
}).
ToList();
var searchByCodeWindow = new SearchByCodeWindow(searchItems);
searchByCodeWindow.ShowDialog();
if (searchByCodeWindow.DialogResult != true)
{
return;
}
_member.Find(searchByCodeWindow.SelectedItem.ItemId);
_transactionDetail.MemberCode = _member.MemberCode;
_transactionDetail.MemberName = _member.MemberName;
DataContext = new TransactionDetail();
DataContext = _transactionDetail;
}
private void SearchProductCode(object sender, RoutedEventArgs e)
{
List <Account> loanAccounts = Account.GetListOfLoanReceivables();
List <SearchItem> searchItems =
loanAccounts.Select(
loan =>
new SearchItem(loan.ID, loan.AccountTitle)
{
ItemCode = loan.AccountCode
}).ToList();
var searchByCodeWindow = new SearchByCodeWindow(searchItems);
searchByCodeWindow.ShowDialog();
if (searchByCodeWindow.DialogResult != true)
{
return;
}
_loanProduct.ProductCode = searchByCodeWindow.SelectedItem.ItemCode;
}
private void Read(object sender, RoutedEventArgs e)
{
List <Nfmb> members = Nfmb.GetList();
List <SearchItem> searchItems =
members.Select(
member =>
new SearchItem(member.ID, member.MemberName)
{
ItemCode = member.MemberCode
}).ToList();
var searchByCodeWindow = new SearchByCodeWindow(searchItems);
searchByCodeWindow.ShowDialog();
if (searchByCodeWindow.DialogResult != true)
{
return;
}
_member.Find(searchByCodeWindow.SelectedItem.ItemId);
RefreshDisplay();
}
private Account FindAccount()
{
var accounts = Account.GetList();
var searchItems =
accounts.Select(
loan =>
new SearchItem(loan.ID, loan.AccountTitle)
{
ItemCode = loan.AccountCode
}).ToList();
var searchByCodeWindow = new SearchByCodeWindow(searchItems);
searchByCodeWindow.ShowDialog();
if (searchByCodeWindow.DialogResult != true)
{
return(null);
}
var account = accounts.SingleOrDefault(ac => ac.ID == searchByCodeWindow.SelectedItem.ItemId);
return(account);
}
