public ledger(int userid) { InitializeComponent(); var financeaccountrepo = new data.dapper.financeaccountrepo(); var financetransactionrepo = new data.dapper.financetransactionrepo(); var userrepo = new data.dapper.userrepo(); financeaccounts = financeaccountrepo.get(); user = userrepo.get(userid); var list = financetransactionrepo.getusertransactions(userid); foreach (var item in list) { dg.Items.Add(item); } var totalpending = 0; if (user.role == "customer") { totalpending = financetransactionrepo.getuserreceiveablessum(userid); } else if (user.role == "vendor") { totalpending = financetransactionrepo.getuserpayablesum(userid); } remaining_label.Content = totalpending; var assetaccounts = financeaccountrepo.getmanybytype("asset"); account_combobox.ItemsSource = assetaccounts; account_combobox.DisplayMemberPath = "name"; account_combobox.SelectedValuePath = "id"; }