public ActionResult GetDepositOB(int?id) { int GroupID = Convert.ToInt32(id); DepositOBDto lstDepositOBDto = new DepositOBDto(); DepositOBBll objDepositOBBll = new DepositOBBll(); if (GroupID > 0) { lstDepositOBDto = objDepositOBBll.GetByID(GroupID); } List <SelectListDto> lstClusters = _clusterService.GetClusterSelectList(); SelectList slClusters = new SelectList(lstClusters, "ID", "Text"); ViewBag.clusters = slClusters; List <SelectListDto> lstInterests = _interestService.GetDepositInterestsSelectList(); SelectList slInterests = new SelectList(lstInterests, "ID", "Text"); ViewBag.interests = slInterests; 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"); ViewBag.group = slgroups; return(View(lstDepositOBDto)); }
public ActionResult DepositLookup() { DepositOBBll DepositOBBll = new DepositOBBll(); List <DepositOBLookup> lstDepositOB = DepositOBBll.DepositOBLookUpList(false, 0); return(View(lstDepositOB)); }
public ActionResult DepositLookup() { DepositOBBll DepositOBBll = new DepositOBBll(); DataSet dsDepositOB = DepositOBBll.DepositOBLookUpTable(true, GroupInfo.GroupID); /*List<DepositOBLookup> lstDepositOB = DepositOBBll.DepositOBLookUp(true, GroupInfo.GroupID); * List<DepositOBPPivot> lstDepositOBPPivot = new List<DepositOBPPivot>(); * var lstLoanOBGroup = lstDepositOB.GroupBy(l => l.MemberId).Select(m => m.Key).ToList(); * foreach (var member in lstLoanOBGroup) * { * * var memberLoans = lstDepositOB.FindAll(l => l.MemberId == member); * DepositOBPPivot depositOBPPivot = new DepositOBPPivot(); * depositOBPPivot.MemberName = lstDepositOB.Find(l => l.MemberId == member).MemberName; * depositOBPPivot.MemberId = member; * foreach (var loan in memberLoans) * { * if (memberLoans.IndexOf(loan) == 0) * { * depositOBPPivot.DepositAmount1 = loan.DepositAmount; * } * else if (memberLoans.IndexOf(loan) == 1) * { * depositOBPPivot.DepositAmount2 = loan.DepositAmount; * } * else if (memberLoans.IndexOf(loan) == 2) * { * depositOBPPivot.DepositAmount3 = loan.DepositAmount; * } * else * break; * } * * lstDepositOBPPivot.Add(depositOBPPivot); * } * var amount1 = lstDepositOBPPivot.Sum(l => l.DepositAmount1); * var amount2 = lstDepositOBPPivot.Sum(l => l.DepositAmount2); * var amount3 = lstDepositOBPPivot.Sum(l => l.DepositAmount3); * ViewBag.DepositAmount1 = amount1; * ViewBag.DepositAmount2 = amount2; * ViewBag.DepositAmount3 = amount3; * return View(lstDepositOBPPivot); */ ViewBag.DSDEPOSITOB = dsDepositOB; return(View()); }
public JsonResult SaveDepositOB(DepositOBDto depositOBDto) { DepositOBBll objDepositOBBll = new DepositOBBll(); depositOBDto.UserID = UserInfo.UserID; depositOBDto = objDepositOBBll.InsertLoanOB(depositOBDto); string Message = null; if (depositOBDto.Id1 != 0 || depositOBDto.Id2 != 0 || depositOBDto.Id3 != 0 || depositOBDto.Id4 != 0) { Message = "Successfully Inserted"; } else { Message = "Not Inserted"; } return(Json(new { result = Message })); }
public ActionResult CreateDepositOB(int?id) { int MemberId = Convert.ToInt32(id); DepositOBDto lstDepositOBDto = new DepositOBDto(); DepositOBBll objDepositOBBll = new DepositOBBll(); if (MemberId > 0) { lstDepositOBDto = objDepositOBBll.GetByMemberID(MemberId); } ViewBag.clusters = GroupInfo.Cluster; ViewBag.village = GroupInfo.Village; ViewBag.GroupName = GroupInfo.GroupName; ViewBag.MeetingDay = GroupInfo.MeetingDay; int GroupId = GroupInfo.GroupID; List <MemberLookupDto> lstMembers = _memberService.GetByGroupId(GroupInfo.GroupID); SelectList slMembers = null; if (lstDepositOBDto.MemberId == 0) { DepositOBBll depositOBBll = new DepositOBBll(); List <DepositOBLookup> lstDepositOB = depositOBBll.DepositOBLookUpList(true, GroupInfo.GroupID); foreach (var member in lstDepositOB) { 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 == lstDepositOBDto.MemberId) { lstMembersTemp.Add(lstMembers.Find(l => l.MemberID == member.MemberID)); } } slMembers = new SelectList(lstMembersTemp, "MemberID", "MemberName"); } ViewBag.Members = slMembers; List <SelectListDto> lstInterests = _interestService.GetDepositInterestsSelectList(GroupInfo.GroupID); SelectList slInterests = new SelectList(lstInterests, "ID", "Text"); ViewBag.interests = slInterests; //ViewBag.lastpaidDate = string.Format("{0}/Mar/2016", GroupInfo.MeetingDay); //lstDepositOBDto.LastPaidDate1 =Convert.ToDateTime(ViewBag.lastpaidDate); //lstDepositOBDto.LastPaidDate2 = Convert.ToDateTime(ViewBag.lastpaidDate); //lstDepositOBDto.LastPaidDate3 = Convert.ToDateTime(ViewBag.lastpaidDate); //lstDepositOBDto.LastPaidDate4 = Convert.ToDateTime(ViewBag.lastpaidDate); //var DB1 = (lstDepositOBDto.DepositBalance1) > 0 ?lstDepositOBDto.DepositBalance1 : 0; //var DB2 = (lstDepositOBDto.IneterestDue1) > 0 ? lstDepositOBDto.IneterestDu*e1 : 0; //ViewBag.Total1 = DB1 + DB2; //var DB3 = (lstDepositOBDto.DepositBalance2) > 0 ? lstDepositOBDto.DepositBalance2 : 0; //var DB4 = (lstDepositOBDto.IneterestDue2) > 0 ? lstDepositOBDto.IneterestDue2 : 0; //ViewBag.Total2 = DB3 + DB4; //var DB5 = (lstDepositOBDto.DepositBalance3) > 0 ? lstDepositOBDto.DepositBalance3 : 0; //var DB6 = (lstDepositOBDto.IneterestDue3) > 0 ? lstDepositOBDto.IneterestDue3 : 0; //ViewBag.Total3 = DB5 + DB6; //var DB7 = (lstDepositOBDto.DepositBalance4) > 0 ? lstDepositOBDto.DepositBalance4 : 0; //var DB8 = (lstDepositOBDto.IneterestDue4) > 0 ? lstDepositOBDto.IneterestDue4 : 0; //ViewBag.Total4 = DB7 + DB8; int Id = lstDepositOBDto.MemberId; MemberDto obj = _memberService.GetById(Id); lstDepositOBDto.MemberCode = obj == null ? string.Empty: obj.MemberCode; return(View(lstDepositOBDto)); }