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