public static IList <BO_CashFlow> LoadCashFlowTable(JQueryDataTableParamModel Param) { using (AprosysAccountingEntities db_aa = new AprosysAccountingEntities()) { List <BO_CashFlow> lst_cashFlow = new List <BussinessObject.BO_CashFlow>(); var _Cashflow = db_aa.Report_CashFlow((DateTime.Now.AddMonths(-96)), BL_Common.GetDatetime()).ToList(); foreach (var item in _Cashflow) { BO_CashFlow obj = new BussinessObject.BO_CashFlow(); obj.invoiceNo = item.InvoiceNo; obj.activityTimeStamp = item.ActivityTimestamp ?? BL_Common.GetDatetime(); obj.transType = item.TransType; obj.debit = item.Debit; obj.credit = item.Credit; lst_cashFlow.Add(obj); } return(lst_cashFlow); } }