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 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)); }