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