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";
        }