/// <summary>
/// Constructor
/// </summary>
public AccountDetailsViewModel()
{
#if USE_SAMPLE_DB
using (var db = new SampleModel())
#else
using (var db = new IdealContext())
#endif
{
try
{
db.Database.Connection.Open();
FillAccounts(db);
selectedItemAccountID = AccountIDs.ElementAt(0);
FillPayments(db, selectedItemAccountID);
FillSchPayments(db, selectedItemAccountID);
FillDetails(selectedItemAccountID);
FillStatusValues(selectedItemAccountID);
FillTotalProgress(selectedItemAccountID);
FillTotalLag(selectedItemAccountID);
FillTotals(selectedItemAccountID);
FillPaymentComparationSeries(selectedItemAccountID);
}
catch (System.Data.SqlClient.SqlException e)
{
MessageBox.Show(e.Message, "Database connection error",
MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
protected override void InitializeCollections()
{
EnsureBaseBalances();
ActiveRequests = new ActiveFundReqsRepo(this);
InactiveRequests = new InactiveFundReqsRepo(this);
ActiveCheques = new ActiveChequesRepo(this);
//InactiveCheques = new InactiveChequesRepo(this);
GLAccounts = new GLAccountsRepo(this);
AccountNames.Clear();
AccountNames.AddRange(GetAccountNames());
if (!AccountNames.Any())
{
GetSoaRepo();
AccountNames.Clear();
AccountNames.AddRange(this.GetAccountNames());
AccountIDs.Clear();
AccountIDs.AddRange(AccountNames.Select((s, i) => i + 1));
}
}
