/// <summary>
/// Insert new Cashflow object into db
/// </summary>
/// <param name="cashflow">Cashflow object (CashflowID = 0)</param>
/// <returns>New Id (also set CashflowID)</returns>
public int InsertCashflow(CommonData.Cashflow cashflow)
{
Cashflow db_cashflow = new Cashflow()
{
CashflowID = cashflow.CashflowID,
Summa = cashflow.Summa,
Time = StorageLib.ToDbTime(cashflow.Time),
TradeID = cashflow.TradeID,
Spend = (byte)cashflow.Spend,
AccountID = cashflow.AccountID
};
_da.DbContext.Insert(db_cashflow);
cashflow.CashflowID = db_cashflow.CashflowID;
return(cashflow.CashflowID);
}
/// <summary>
/// Get Cashflows by account Id
/// </summary>
/// <param name="accountID">Account Id</param>
/// <returns>Cashflows list</returns>
public IEnumerable <CommonData.Cashflow> GetCashflows(int accountID)
{
List <CommonData.Cashflow> cashflows = new List <CommonData.Cashflow>();
var db_cashflows = _da.DbContext.Table <Cashflow>().Where(r => r.AccountID == accountID).ToList();
foreach (var db_cashflow in db_cashflows)
{
var cashflow = new CommonData.Cashflow()
{
CashflowID = db_cashflow.CashflowID,
Summa = db_cashflow.Summa,
Time = StorageLib.ToDateTime(db_cashflow.Time),
TradeID = db_cashflow.TradeID,
Spend = (CashflowSpend)db_cashflow.Spend,
AccountID = db_cashflow.AccountID
};
cashflows.Add(cashflow);
}
return(cashflows);
}
