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