public ActionResult LoanOBLookup() { LoanOBBll loanOBBll = new LoanOBBll(); List <LoanOBLookup> lstLoanOB = loanOBBll.LoanOBLookUp('G'); List <LoanOBLookupPivot> lstLoanOBPivot = new List <LoanOBLookupPivot>(); var lstLoanOBGroup = lstLoanOB.GroupBy(l => l.GroupID).Select(m => m.Key).ToList(); foreach (var group in lstLoanOBGroup) { var groupLoans = lstLoanOB.FindAll(l => l.GroupID == group); LoanOBLookupPivot loanOBLookupPivot = new LoanOBLookupPivot(); loanOBLookupPivot.GroupName = lstLoanOB.Find(l => l.GroupID == group).GroupName; loanOBLookupPivot.GroupID = group; foreach (var loan in groupLoans) { if (groupLoans.IndexOf(loan) == 0) { loanOBLookupPivot.LoanAmountGiven1 = loan.LoanAmountGiven; loanOBLookupPivot.PrincipalOutstanding1 = loan.PrincipalOutstanding; } else if (groupLoans.IndexOf(loan) == 1) { loanOBLookupPivot.LoanAmountGiven2 = loan.LoanAmountGiven; loanOBLookupPivot.PrincipalOutstanding2 = loan.PrincipalOutstanding; } else if (groupLoans.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)); // return View(lstLoanOB); }
public ActionResult DeleteLoanOBRecord(int id) { int MemberId = Convert.ToInt32(id); LoanOBBll objLoanOBBll = new LoanOBBll(); ResultDto resultDto = objLoanOBBll.DeleteLoanOBByMemberID(MemberId); // TempData["Message"] = resultDto.ObjectCode; var message = resultDto.ObjectCode; return(Content(message)); }
public JsonResult SaveLoanOB(LoanOBDto loanOBDto) { LoanOBBll objLoanOBBll = new LoanOBBll(); loanOBDto.LoanType = 'M'; loanOBDto.GroupId = GroupInfo.GroupID; loanOBDto.MemberID = Convert.ToInt32(Request.Form["MemberID"]); loanOBDto.UserID = UserInfo.UserID; loanOBDto = objLoanOBBll.InsertLoanOB(loanOBDto); string Message = null; string Fail = ""; if (loanOBDto.LoanMasrterID1 != 0 && loanOBDto.IsDisbursed1 == false || loanOBDto.LoanMasrterID2 != 0 && loanOBDto.IsDisbursed2 == false || loanOBDto.LoanMasrterID3 != 0 && loanOBDto.IsDisbursed3 == false || loanOBDto.LoanMasrterID4 != 0 && loanOBDto.IsDisbursed4 == false) { Message = "Successfully Inserted"; } else if (loanOBDto.IsDisbursed1 == true && loanOBDto.LoanMasrterID1 != 0) { Fail += loanOBDto.Total1 + "\n"; } else if (loanOBDto.IsDisbursed2 == true && loanOBDto.LoanMasrterID2 != 0) { Fail += loanOBDto.Total2 + "\n"; } else if (loanOBDto.IsDisbursed3 == true && loanOBDto.LoanMasrterID3 != 0) { Fail += loanOBDto.Total3 + "\n"; } else if (loanOBDto.IsDisbursed4 == true && loanOBDto.LoanMasrterID4 != 0) { Fail += loanOBDto.Total4 + "\n"; } else { Message = "Insert failed"; } if (Fail.Length > 1) { Message = Message + "Failed to insert Principal Amount Outstandings are" + Fail; } else { Message = Message + ""; } return(Json(new { result = Message, LoanMasrterID1 = loanOBDto.LoanMasrterID1, LoanMasrterID2 = loanOBDto.LoanMasrterID2, LoanMasrterID3 = loanOBDto.LoanMasrterID3, LoanMasrterID4 = loanOBDto.LoanMasrterID4 })); }
public ActionResult GetLoanOB(int?id) { ViewBag.clusters = GroupInfo.Cluster; ViewBag.village = GroupInfo.Village; ViewBag.GroupName = GroupInfo.GroupName; ViewBag.MeetingDay = GroupInfo.MeetingDay; ViewBag.LockStatus = GroupInfo.LockStatus; int LoanMasterId = Convert.ToInt32(id); LoanOBByLoanDto lstdtos = new LoanOBByLoanDto(); LoanOBBll objLoanOBBll = new LoanOBBll(); LoanOBDto lstLoanOBDto = new LoanOBDto(); if (LoanMasterId > 0) { lstLoanOBDto = objLoanOBBll.GetByID(LoanMasterId); lstLoanOBDto.Total1 = lstLoanOBDto.PrincipalOutstanding1 + lstLoanOBDto.InterestDue1; lstLoanOBDto.Total2 = lstLoanOBDto.PrincipalOutstanding2 + lstLoanOBDto.InterestDue2; lstLoanOBDto.Total3 = lstLoanOBDto.PrincipalOutstanding3 + lstLoanOBDto.InterestDue3; lstLoanOBDto.Total4 = lstLoanOBDto.PrincipalOutstanding4 + lstLoanOBDto.InterestDue4; } List <LoanPurposeLookupDto> lstLoanpurposeDto = _loanpurposeService.Lookup(); SelectList lstloanpurpose = new SelectList(lstLoanpurposeDto, "LoanPurposeID", "Purpose"); ViewBag.lonapurpose = lstloanpurpose; List <SelectListDto> lstProjects = _projectService.GetProjectSelectList(); SelectList slProjects = new SelectList(lstProjects, "ID", "Text"); ViewBag.projects = slProjects; List <MemberLookupDto> lstMembers = _memberService.GetByGroupId(GroupInfo.GroupID); SelectList slMembers = new SelectList(lstMembers, "MemberID", "MemberName"); if (lstLoanOBDto.MemberID == 0) { LoanOBBll loanOBBll = new LoanOBBll(); List <LoanOBLookup> lstLoanOB = loanOBBll.LoanOBLookUpList('M', GroupInfo.GroupID); foreach (var member in lstLoanOB) { lstMembers.Remove(lstMembers.Find(l => l.MemberID == member.MemberID)); } slMembers = new SelectList(lstMembers, "MemberID", "MemberName"); } else { List <MemberLookupDto> lstMembersTemp = new List <MemberLookupDto>(); foreach (var member in lstMembers) { if (member.MemberID == lstLoanOBDto.MemberID) { lstMembersTemp.Add(lstMembers.Find(l => l.MemberID == member.MemberID)); } } slMembers = new SelectList(lstMembersTemp, "MemberID", "MemberName"); } ViewBag.Members = slMembers; List <SelectListDto> lstFundSources = _fundSourceService.GetFundSourceSelectList(); SelectList slFundsource = new SelectList(lstFundSources, "ID", "Text"); ViewBag.fundsource = slFundsource; List <SelectListDto> lstInterests = _interestService.GetInterestsSelectList(GroupInfo.GroupID); SelectList slInterests = new SelectList(lstInterests, "ID", "Text"); ViewBag.interests = slInterests; if (LoanMasterId == 0) { if (lstInterests != null && lstInterests.Count > 0 && lstInterests.Exists(l => l.Text.ToUpper().Contains("BIG LOANS TO"))) { SelectListDto s = lstInterests.Find(l => l.Text.ToUpper().Contains("BIG LOANS TO")); InterestMasterDto interest = GetInterestDetailsDto(s.ID); lstLoanOBDto.AHCode1 = interest.PrincipalAHCode; lstLoanOBDto.AHName1 = interest.PrincipalAHName; lstLoanOBDto.ROI1 = Convert.ToInt32(interest.InterestRate); //lstLoanOBDto.InterestDue1 = 0; lstLoanOBDto.Interest1 = s.ID; } if (lstInterests != null && lstInterests.Count > 0 && lstInterests.Exists(l => l.Text.ToUpper().Contains("SMALL LOANS TO"))) { SelectListDto s = lstInterests.Find(l => l.Text.ToUpper().Contains("SMALL LOANS TO")); InterestMasterDto interest = GetInterestDetailsDto(s.ID); lstLoanOBDto.AHCode2 = interest.PrincipalAHCode; lstLoanOBDto.AHName2 = interest.PrincipalAHName; lstLoanOBDto.ROI2 = Convert.ToInt32(interest.InterestRate); //lstLoanOBDto.InterestDue2 = 0; lstLoanOBDto.Interest2 = s.ID; } if (lstInterests != null && lstInterests.Count > 0 && lstInterests.Exists(l => l.Text.ToUpper().Contains("HOUSING LOANS TO"))) { SelectListDto s = lstInterests.Find(l => l.Text.ToUpper().Contains("HOUSING LOANS TO")); InterestMasterDto interest = GetInterestDetailsDto(s.ID); lstLoanOBDto.AHCode3 = interest.PrincipalAHCode; lstLoanOBDto.AHName3 = interest.PrincipalAHName; lstLoanOBDto.ROI3 = Convert.ToInt32(interest.InterestRate); //lstLoanOBDto.InterestDue3 = 0; lstLoanOBDto.Interest3 = s.ID; } } else if (LoanMasterId > 0 && lstLoanOBDto.AHCode1 != null && lstLoanOBDto.AHCode2 != null && lstLoanOBDto.AHCode3 != null) { } else if (LoanMasterId > 0 && lstLoanOBDto.AHCode1 != null && lstLoanOBDto.AHCode2 != null) { if (lstInterests != null && lstInterests.Count > 0 && lstInterests.Exists(l => l.Text.ToUpper().Contains("BIG LOANS TO"))) { SelectListDto s = lstInterests.Find(l => l.Text.ToUpper().Contains("BIG LOANS TO")); InterestMasterDto interest = GetInterestDetailsDto(s.ID); lstLoanOBDto.AHCode3 = interest.PrincipalAHCode; lstLoanOBDto.AHName3 = interest.PrincipalAHName; lstLoanOBDto.Interest3 = s.ID; } } else { if (lstInterests != null && lstInterests.Count > 0 && lstInterests.Exists(l => l.Text.ToUpper().Contains("BIG LOANS TO"))) { SelectListDto s = lstInterests.Find(l => l.Text.ToUpper().Contains("BIG LOANS TO")); InterestMasterDto interest = GetInterestDetailsDto(s.ID); lstLoanOBDto.AHCode2 = interest.PrincipalAHCode; lstLoanOBDto.AHName2 = interest.PrincipalAHName; lstLoanOBDto.Interest2 = s.ID; } if (lstInterests != null && lstInterests.Count > 0 && lstInterests.Exists(l => l.Text.ToUpper().Contains("SMALL LOANS TO"))) { SelectListDto s = lstInterests.Find(l => l.Text.ToUpper().Contains("SMALL LOANS TO")); InterestMasterDto interest = GetInterestDetailsDto(s.ID); lstLoanOBDto.AHCode2 = interest.PrincipalAHCode; lstLoanOBDto.AHName2 = interest.PrincipalAHName; lstLoanOBDto.Interest2 = s.ID; } if (lstInterests != null && lstInterests.Count > 0 && lstInterests.Exists(l => l.Text.ToUpper().Contains("HOUSING LOANS TO"))) { SelectListDto s = lstInterests.Find(l => l.Text.ToUpper().Contains("HOUSING LOANS TO")); InterestMasterDto interest = GetInterestDetailsDto(s.ID); lstLoanOBDto.AHCode3 = interest.PrincipalAHCode; lstLoanOBDto.AHName3 = interest.PrincipalAHName; lstLoanOBDto.Interest3 = s.ID; } } ViewBag.lastpaidDate = string.Format("{0}/Mar/2016", GroupInfo.MeetingDay); lstLoanOBDto.LastPaidDate1 = ViewBag.lastpaidDate; lstLoanOBDto.LastPaidDate2 = ViewBag.lastpaidDate; lstLoanOBDto.LastPaidDate3 = ViewBag.lastpaidDate; lstLoanOBDto.LastPaidDate4 = ViewBag.lastpaidDate; ViewBag.meetingDay = GroupInfo.MeetingDay; //List<SelectListDto> lstPrincipalAHIDs=_accountHeadService.loan ViewBag.LoanAccountHeads = slInterests; return(View(lstLoanOBDto)); }
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); * */ }
public ActionResult GetLoanOB(int?id) { int LoanMasterId = Convert.ToInt32(id); LoanOBByLoanDto lstdtos = new LoanOBByLoanDto(); LoanOBBll objLoanOBBll = new LoanOBBll(); LoanOBDto lstLoanOBDto = new LoanOBDto(); char LoanType = 'G'; if (LoanMasterId > 0) { lstLoanOBDto = objLoanOBBll.GetByID(LoanMasterId, LoanType); lstLoanOBDto.Total1 = lstLoanOBDto.PrincipalOutstanding1 + lstLoanOBDto.InterestDue1; lstLoanOBDto.Total2 = lstLoanOBDto.PrincipalOutstanding2 + lstLoanOBDto.InterestDue2; lstLoanOBDto.Total3 = lstLoanOBDto.PrincipalOutstanding3 + lstLoanOBDto.InterestDue3; lstLoanOBDto.Total4 = lstLoanOBDto.PrincipalOutstanding4 + lstLoanOBDto.InterestDue4; } List <SelectListDto> lstClusters = _clusterService.GetClusterSelectList(); SelectList slClusters = new SelectList(lstClusters, "ID", "Text"); ViewBag.clusters = slClusters; List <LoanPurposeLookupDto> lstLoanpurposeDto = _loanpurposeService.Lookup(); SelectList lstloanpurpose = new SelectList(lstLoanpurposeDto, "LoanPurposeID", "Purpose"); ViewBag.lonapurpose = lstloanpurpose; List <SelectListDto> lstProjects = _projectService.GetProjectSelectList(); SelectList slProjects = new SelectList(lstProjects, "ID", "Text"); ViewBag.projects = slProjects; List <SelectListDto> lstFundSources = _fundSourceService.GetFundSourceSelectList(); SelectList slFundsource = new SelectList(lstFundSources, "ID", "Text"); ViewBag.fundsource = slFundsource; List <SelectListDto> lstvilllages = _villageService.GetVillageSelectList(); SelectList slvillages = new SelectList(lstvilllages, "ID", "Text"); ViewBag.village = slvillages; List <SelectListDto> lstgroups = _groupService.GetGroupsSelectList(); SelectList slgroups = new SelectList(lstgroups, "ID", "Text"); if (lstLoanOBDto.GroupId == 0) { LoanOBBll loanOBBll = new LoanOBBll(); List <LoanOBLookup> lstLoanOB = loanOBBll.LoanOBLookUpList('G', 0); foreach (var group in lstLoanOB) { lstgroups.Remove(lstgroups.Find(l => l.ID == group.GroupID)); } slgroups = new SelectList(lstgroups, "ID", "Text"); } else { List <SelectListDto> lstGroupsTemp = new List <SelectListDto>(); foreach (var group in lstgroups) { if (group.ID == lstLoanOBDto.GroupId) { lstGroupsTemp.Add(lstgroups.Find(l => l.ID == group.ID)); } } slgroups = new SelectList(lstGroupsTemp, "ID", "Text"); } ViewBag.group = slgroups; List <SelectListDto> lstInterests = _interestService.GetInterestsSelectList(); SelectList slInterests = new SelectList(lstInterests, "ID", "Text"); ViewBag.interests = slInterests; //List<SelectListDto> lstPrincipalAHIDs=_accountHeadService.loan ViewBag.LoanAccountHeads = slInterests; return(View(lstLoanOBDto)); }