public ActionResult LoanOBLookup()
{
LoanOBBll loanOBBll = new LoanOBBll();
DataSet dsLoanOB = loanOBBll.LoanOBLookUpTable('M', GroupInfo.GroupID);
ViewBag.DSLOANOB = dsLoanOB;
return(View());
/*List<LoanOBLookup> lstLoanOB = loanOBBll.LoanOBLookUp('M', GroupInfo.GroupID);
*
* List<LoanOBLookupPivot> lstLoanOBPivot = new List<LoanOBLookupPivot>();
*
* var lstLoanOBGroup = lstLoanOB.GroupBy(l => l.MemberID).Select(m => m.Key).ToList();
* foreach (var member in lstLoanOBGroup)
* {
*
* var memberLoans = lstLoanOB.FindAll(l => l.MemberID == member);
* LoanOBLookupPivot loanOBLookupPivot = new LoanOBLookupPivot();
* loanOBLookupPivot.MemberName = lstLoanOB.Find(l => l.MemberID == member).MemberName;
* loanOBLookupPivot.MemberID = member;
* foreach (var loan in memberLoans)
* {
* if (memberLoans.IndexOf(loan) == 0)
* {
* loanOBLookupPivot.LoanAmountGiven1 = loan.LoanAmountGiven;
* loanOBLookupPivot.PrincipalOutstanding1 = loan.PrincipalOutstanding;
* }
* else if (memberLoans.IndexOf(loan) == 1)
* {
* loanOBLookupPivot.LoanAmountGiven2 = loan.LoanAmountGiven;
* loanOBLookupPivot.PrincipalOutstanding2 = loan.PrincipalOutstanding;
* }
* else if (memberLoans.IndexOf(loan) == 2)
* {
* loanOBLookupPivot.LoanAmountGiven3 = loan.LoanAmountGiven;
* loanOBLookupPivot.PrincipalOutstanding3 = loan.PrincipalOutstanding;
* }
* else
* break;
* }
*
* lstLoanOBPivot.Add(loanOBLookupPivot);
* }
* var amount1 = lstLoanOBPivot.Sum(l => l.LoanAmountGiven1);
* var amount2 = lstLoanOBPivot.Sum(l => l.LoanAmountGiven2);
* var amount3 = lstLoanOBPivot.Sum(l => l.LoanAmountGiven3);
* var OSAmount1 = lstLoanOBPivot.Sum(l => l.PrincipalOutstanding1);
* var OSAmount2 = lstLoanOBPivot.Sum(l => l.PrincipalOutstanding2);
* var OSAmount3 = lstLoanOBPivot.Sum(l => l.PrincipalOutstanding3);
* ViewBag.LoanDisbursementTotal1 = amount1;
* ViewBag.LoanDisbursementTotal2 = amount2;
* ViewBag.LoanDisbursementTotal3 = amount3;
* ViewBag.LoanOutStandingAmountTotal1 = OSAmount1;
* ViewBag.LoanOutStandingAmountTotal2 = OSAmount2;
* ViewBag.LoanOutStandingAmountTotal3 = OSAmount3;
*
* return View(lstLoanOBPivot);
* */
}
