public JsonResult GetChart()
{
var headlist = db.LedgerHeads.OrderBy(x => x.Name).ToList();
List <Ledger_Head> ledgerheadlist = new List <Ledger_Head>();
foreach (var h_item in headlist)
{
Ledger_Head ledgerhead = new Ledger_Head();
ledgerhead.HeadName = h_item.Name;
ledgerhead.HeadId = h_item.Id;
var grouplist = db.LedgerGroups.Where(x => x.LedgerHeadID == h_item.Id).OrderBy(x => x.Name).ToList();
var _ledgerlist = db.Ledgers.Where(x => x.LedgerHeadId == h_item.Id).OrderBy(x => x.Name).ToList();
ledgerhead.ledgerGroup = new List <Ledger_Group>();
ledgerhead.ledger = new List <_Ledger>();
foreach (var g_item in grouplist)
{
Ledger_Group lg = new Ledger_Group();
lg.GroupId = g_item.Id;
lg.GroupName = g_item.Name;
lg.ledger = new List <_Ledger>();
var ledgerlist = db.Ledgers.Where(x => x.Id == lg.GroupId).OrderBy(x => x.Name).ToList();
foreach (var l_item in ledgerlist)
{
_Ledger l = new _Ledger();
l.LedgerId = l_item.Id;
l.LedgerName = l_item.Name;
lg.ledger.Add(l);
}
ledgerhead.ledgerGroup.Add(lg);
}
foreach (var item in _ledgerlist)
{
_Ledger l = new _Ledger();
l.LedgerId = item.Id;
l.LedgerName = item.Name;
ledgerhead.ledger.Add(l);
}
ledgerheadlist.Add(ledgerhead);
}
return(Json(ledgerheadlist, JsonRequestBehavior.AllowGet));
}
public JsonResult GetSumamryReport()
{
var headlist = db.LedgerHeads.ToList();
List <Ledger_Head> ledgerheadlist = new List <Ledger_Head>();
foreach (var h_item in headlist)
{
Ledger_Head ledgerhead = new Ledger_Head();
ledgerhead.HeadId = h_item.Id;
ledgerhead.HeadName = h_item.Name;
decimal?amount = 0;
var grouplist = db.LedgerGroups.Where(x => x.LedgerHeadID == h_item.Id).ToList();
var _ledgerlist = db.Ledgers.Where(x => x.LedgerHeadId == h_item.Id && x.LedgerGroupId == null).ToList();
ledgerhead.ledgerGroup = new List <Ledger_Group>();
ledgerhead.ledger = new List <_Ledger>();
foreach (var g_item in grouplist)
{
Ledger_Group lg = new Ledger_Group();
lg.GroupId = g_item.Id;
lg.GroupName = g_item.Name;
lg.ledger = new List <_Ledger>();
decimal?groupAmount = 0;
var ledgerlist = db.Ledgers.Where(x => x.LedgerGroupId == lg.GroupId).ToList();
foreach (var l_item in ledgerlist)
{
_Ledger l = new _Ledger();
l.LedgerId = l_item.Id;
l.LedgerName = l_item.Name;
l.LedgerAmount = l_item.CurrentBalance;
if (l_item.CurrentBalance == null)
{
groupAmount = groupAmount + 0;
amount = amount + 0;
}
else
{
groupAmount = groupAmount + l_item.CurrentBalance;
amount = amount + l_item.CurrentBalance;
}
lg.ledger.Add(l);
}
lg.GroupTotal = groupAmount;
ledgerhead.ledgerGroup.Add(lg);
}
foreach (var item in _ledgerlist)
{
_Ledger l = new _Ledger();
l.LedgerId = item.Id;
l.LedgerName = item.Name;
l.LedgerAmount = item.CurrentBalance;
if (item.CurrentBalance == null)
{
amount = amount + 0;
}
else
{
amount = amount + item.CurrentBalance;
}
ledgerhead.ledger.Add(l);
}
ledgerhead.TotalAmount = amount;
ledgerheadlist.Add(ledgerhead);
}
return(Json(ledgerheadlist, JsonRequestBehavior.AllowGet));
}
