public List <LedgersView> GetAllSubs(List <LedgersView> solly, out decimal totalCr, out decimal totalDr)
{
var subsidiaryList = new List <LedgersView>();
decimal TotalCr = 0M;
decimal TotalDr = 0M;
foreach (var j in solly)
{
var k = new LedgersView
{
code = j.code,
desc = j.desc,
dbbal = j.dbbal,
crbal = j.crbal
};
TotalCr += k.crbal;
TotalDr += k.dbbal;
subsidiaryList.Add(k);
}
totalCr = TotalCr;
totalDr = TotalDr;
return(subsidiaryList);
}
public IEnumerable <LedgersView> GetAllNPFHistory(string codedate)
{
List <npf_history> result = new List <npf_history>();
result = context.npf_Histories.Where(x => x.docno.Substring(0, 8) == codedate).ToList();
var result2 = new List <LedgersView>();
foreach (var j in result)
{
var p = new LedgersView
{
code = j.acctcode,
opBal = 0M,
dbbal = (decimal)j.dbamt,
crbal = (decimal)j.cramt,
desc = GetDescription(j.acctcode)
};
result2.Add(p);
}
return(result2);
}
public List <LedgersView> GetMain(List <LedgersView> opo)
{
var y = new List <string>();
var y2 = new List <string>();
var result2 = new List <LedgersView>();
foreach (var j in opo)
{
y.Add(service.RefractCode(j.code));
}
y2 = y.Distinct().ToList();
foreach (var km in y2)
{
var k = new LedgersView
{
code = km,
desc = service.description(km),
crbal = getSumCr(opo, km),
dbbal = getSumDr(opo, km)
};
result2.Add(k);
}
return(result2);
}
public IEnumerable <LedgersView> FilterRecord(List <npf_history> solly)
{
var listApp = new List <LedgersView>();
foreach (var j in solly)
{
string code = RefractCode(j.docno);
if (code != "Mend" && code != "Open")
{
var jk = new LedgersView
{
period = j.period,
doc = j.docno,
date = j.docdate,
remark = j.remarks,
dbbal = (j.dbamt == null) ? 0M : (decimal)j.dbamt,
crbal = (j.cramt == null) ? 0M : (decimal)j.cramt
};
listApp.Add(jk);
}
}
return(listApp);
}
public ReportViewModel2 GetAllSubs(List <LedgersView> solly, LedgersView tolly, string acctCode, string year, string description)
{
var j = new ReportViewModel2
{
AcctCode = acctCode,
solly = solly,
opy = tolly,
year = year,
AcctDesc = description
};
return(j);
}
public IEnumerable <LedgersView> GetAllLoanTypes()
{
var result = context.Pf_loanType.ToList();
var listApp = new List <LedgersView>();
foreach (var j in result)
{
var t = new LedgersView
{
code = RefractCode(j.loanacct),
desc = j.Description
};
listApp.Add(t);
}
return(listApp);
}
public IEnumerable <LedgersView> GetAllMainAct()
{
var result = context.mainacts.ToList();
var listApp = new List <LedgersView>();
foreach (var j in result)
{
var t = new LedgersView
{
code = j.maincode,
desc = j.description
};
listApp.Add(t);
}
return(listApp);
}
public IEnumerable <LedgersView> GetMainLedgersByDate(List <LedgersView> sol)
{
var result = new List <LedgersView>();
foreach (var j in sol)
{
var p = new LedgersView
{
code = RefractCode(j.code),
opBal = 0M,
dbbal = j.dbbal,
crbal = j.crbal,
desc = GetDescription2(j.code)
};
result.Add(p);
}
return(result);
}
public LedgersView GetOpenBal(string acctcode, string wdoc)
{
var op = new LedgersView();
var result = context.npf_Histories.FirstOrDefault(x => x.acctcode == acctcode && x.docno == wdoc);
if (result == null)
{
op.opBal = 0M;
op.period = "0";
}
else
{
op.opBal = (decimal)result.netamt;
op.period = result.period;
}
return(op);
}
public IEnumerable <LedgersView> GetAllLedegers(string indicator, string fundcode)
{
var result2 = new List <LedgersView>();
var TrialBalanceList = (from c in context.npf_Ledgers
join chart in context.npf_Charts on c.acctcode equals chart.acctcode
where c.fundcode == fundcode
select new LedgersView
{
code = c.acctcode,
opBal = c.opbalance,
dbbal = c.adbbalance,
crbal = c.crbalance,
desc = chart.description
}).OrderBy(c => c.code);
if (indicator == "Subsidiary Ledger")
{
foreach (var j in TrialBalanceList)
{
var p = new LedgersView
{
code = j.code,
opBal = j.opBal,
dbbal = j.dbbal,
crbal = j.crbal,
desc = j.desc
};
result2.Add(p);
}
}
else if (indicator == "Main Ledger")
{
foreach (var j in TrialBalanceList)
{
var p = new LedgersView
{
code = RefractCode(j.code),
opBal = j.opBal,
dbbal = j.dbbal,
crbal = j.crbal,
desc = GetDescription2(j.code)
};
result2.Add(p);
}
}
else
{
foreach (var j in TrialBalanceList)
{
var p = new LedgersView
{
code = j.code,
opBal = j.opBal,
dbbal = j.dbbal,
crbal = j.crbal,
desc = j.desc
};
result2.Add(p);
}
}
return(result2);
}
