public Bill_Payment(DB.DBConnection _DBConnection, DB.DBConnection.Bill Bill) { InitializeComponent(); this._DBConnection = _DBConnection; this.Bill = Bill; MemberPayment = new ObservableCollection <MemberPayment>(); DataContext = this; foreach (DBConnection.Member member in _DBConnection.Members) { MemberPayment.Add(new MemberPayment(_DBConnection, Bill, member)); } TotalAmount = 0; foreach (DBConnection.Bill bill in _DBConnection.DB_GetPaidBills(Bill.DueDateMonth, Bill.DueDateYear)) { TotalAmount += bill.AmountHRK; } TotalAmount += Bill.AmountHRK; switch (Bill.Currency) { case "EUR": TotalAmount /= Properties.Settings.Default.EURRate; break; } }
private List <Bill> DB_GetBills() { List <Bill> results = new List <Bill>(); using (var conection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\BC.accdb")) { DataTable myDataTable = new DataTable(); conection.Open(); String query = "Select * From Bills WHERE Bills.Active = True"; OleDbDataAdapter adapter = new OleDbDataAdapter(query, conection); adapter.Fill(myDataTable); Bill bill; for (int i = 0; i < myDataTable.Rows.Count; i++) { bill = new DBConnection.Bill(myDataTable.Rows[i]); results.Add(bill); } } return(results); }