Exemple #1
0
        public IEnumerable <ProfitLossReportModel> GetBalanceSheetReportList(int?productId, DateTime?FromDate, DateTime?ToDate)
        {
            IQueryable <GL_GetBalanceSheetReport_Result> result = ent.GL_GetBalanceSheetReport(productId, FromDate, ToDate).AsQueryable();

            List <ProfitLossReportModel> model = new List <ProfitLossReportModel>();

            foreach (var item in result)
            {
                var obj = new ProfitLossReportModel();
                obj.txtLedgerName  = item.LedgerName;
                obj.txtLiabilities = Convert.ToDecimal(item.Liabilities);
                obj.txtAsset       = Convert.ToDecimal(item.Accet);

                totalLiabilities = totalLiabilities + Convert.ToDecimal(item.Liabilities);
                totalAsset       = totalAsset + Convert.ToDecimal(item.Accet);

                obj.txtSumLiabilities = totalLiabilities;
                obj.txtSumAsset       = totalAsset;

                model.Add(obj);
            }
            return(model.AsEnumerable());
        }