public BalanceSheetItemViewModel(
ILoggerFactory loggerFactory,
BalanceSheetItem balanceSheetItem)
{
m_logger = loggerFactory.CreateLogger <BalanceSheetItemViewModel>();
Name = balanceSheetItem.Name;
Balance = balanceSheetItem.Balance;
}
private List <BalanceSheetItem> GetBalanceSheetTransactionalData()
{
GlBL BL = new GlBL();
List <BalanceSheetItem> list = new List <BalanceSheetItem>();
DataSet ds = BL.PerformSearch();
for (int i = 0; i < ds.Tables["Detail"].Rows.Count; i++)
{
{
BalanceSheetItem item = new BalanceSheetItem();
item.Amount = Convert.ToString(ds.Tables["Detail"].Rows[i]["Amount"]);
item.GLAccountName = Convert.ToString(ds.Tables["Detail"].Rows[i]["gl_name"]);
item.GlAccountNumber = Convert.ToString(ds.Tables["Detail"].Rows[i]["gl_number"]);
item.Type = Convert.ToString(ds.Tables["Detail"].Rows[i]["Type"]);
item.Category = Convert.ToString(ds.Tables["Detail"].Rows[i]["gl_account_type"]);
list.Add(item);
}
}
Session["GetBalanceSheetTransactionalData"] = list;
return(list);
}
public List <BalanceSheetItem> GetBalanceSheetData()
{
List <BalanceSheetItem> data = new List <BalanceSheetItem>();
BalanceSheetItem monthlyEMI = new BalanceSheetItem();
monthlyEMI.Amount = GetTotalOf("Monthly EMI");
monthlyEMI.BalancesheetItem = "Total from \"Month wise status report\"";
monthlyEMI.Transaction = Enum.Enums.TransactionType.Credit;
data.Add(monthlyEMI);
BalanceSheetItem PastInterest = new BalanceSheetItem();
PastInterest.Amount = GetInvestmentReport("Past Year Interest").Sum(x => x.Amount);
PastInterest.BalancesheetItem = "Total Interest of 2016-2019";
PastInterest.Transaction = Enum.Enums.TransactionType.Credit;
data.Add(PastInterest);
BalanceSheetItem Interest2020 = new BalanceSheetItem();
Interest2020.Amount = GetTotalOf("Interest(Self)") + GetTotalOf("Interest(Third Party)") + GetInvestmentReport("Bank Interest").Sum(x => x.Amount);
Interest2020.BalancesheetItem = "Total Interest of 2020";
Interest2020.Transaction = Enum.Enums.TransactionType.Credit;
data.Add(Interest2020);
BalanceSheetItem otherCredit = new BalanceSheetItem();
otherCredit.Amount = GetInvestmentReport("Other").Where(x => x.TranscationType == Enum.Enums.TransactionType.Credit).Sum(x => x.Amount);
otherCredit.BalancesheetItem = "Other (Credit)";
otherCredit.Transaction = Enum.Enums.TransactionType.Credit;
data.Add(otherCredit);
BalanceSheetItem dueMoney = new BalanceSheetItem();
dueMoney.Amount = GetTotalOf("WithDraw Money(Self)") + GetTotalOf("WithDraw Money(Third Party)") - GetTotalOf("Return Money(Self)") - GetTotalOf("Return Money(Third Party)");
dueMoney.BalancesheetItem = "Due Money";
dueMoney.Transaction = Enum.Enums.TransactionType.Debit;
data.Add(dueMoney);
BalanceSheetItem investment = new BalanceSheetItem();
investment.Amount = GetInvestmentReport("Investment").Sum(x => x.Amount);;
investment.BalancesheetItem = "Investment";
investment.Transaction = Enum.Enums.TransactionType.Debit;
data.Add(investment);
BalanceSheetItem bankBalance = new BalanceSheetItem();
bankBalance.Amount = GetInvestmentReport("Bank Balance").Sum(x => x.Amount);
bankBalance.BalancesheetItem = "Bank Balance";
bankBalance.Transaction = Enum.Enums.TransactionType.Debit;
data.Add(bankBalance);
BalanceSheetItem otherDebit = new BalanceSheetItem();
otherDebit.Amount = GetInvestmentReport("Other").Where(x => x.TranscationType == Enum.Enums.TransactionType.Debit).Sum(x => x.Amount);
otherDebit.BalancesheetItem = "Other (Debit)";
otherDebit.Transaction = Enum.Enums.TransactionType.Debit;
data.Add(otherDebit);
return(data);
}
public IBalanceSheetItemViewModel Create(BalanceSheetItem balanceSheetItem)
{
return(new BalanceSheetItemViewModel(
m_loggerFactory,
balanceSheetItem));
}
