public HttpResponseMessage GetInstallmentDetails(int beneficiaryId) { var benificiary = _installmentDetailService.Get(w => w.BeneficiaryId == beneficiaryId, o => o.OrderByDescending(p => p.InstallmentNo), "BenificiaryMaster,Comments,GeoTaggingDetails,InstallmentSignings"); if (benificiary != null) { return(Request.CreateResponse(HttpStatusCode.OK, benificiary)); } return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "No Beneficiary found.")); }
public JsonResult MasterReports(int cityId, string DTRno) { var user = Session["UserDetails"] as UserViewModel; List <WorkStatusDetailsViewModel> workstatus = new List <WorkStatusDetailsViewModel>(); var installments = _iInstallmentDetailService.Get(w => w.BenificiaryMaster.CityId == cityId && w.BenificiaryMaster.DTRNo == DTRno, w => w.OrderByDescending(o => o.InstallmentNo), "").ToList(); var installmentslists = installments.GroupBy(o => o.InstallmentNo). Select(g => new { InstallmentKey = g.Key, Installment = g.Select(i => i.InstallmentNo).FirstOrDefault() == 1 ? "First" : g.Select(i => i.InstallmentNo).FirstOrDefault() == 2 ? "Second" : g.Select(i => i.InstallmentNo).FirstOrDefault() == 3 ? "Third" : g.Select(i => i.InstallmentNo).FirstOrDefault() == 4 ? "Fourth" : g.Select(i => i.InstallmentNo).FirstOrDefault() == 5 ? "Fifth" : g.Select(i => i.InstallmentNo).FirstOrDefault() == 6 ? "Sixth-Cum Final" : "", LevelType = g.Select(i => i.InstallmentNo).FirstOrDefault() == 1 ? "At Plinth Level" : g.Select(i => i.InstallmentNo).FirstOrDefault() == 2 ? "At Lintel Level" : g.Select(i => i.InstallmentNo).FirstOrDefault() == 3 ? "At Roof Level" : g.Select(i => i.InstallmentNo).FirstOrDefault() == 4 ? "For Finishing Completion" : g.Select(i => i.InstallmentNo).FirstOrDefault() == 5 ? "Level" : g.Select(i => i.InstallmentNo).FirstOrDefault() == 6 ? "Level" : "", BeneficiaryAmount = g.Sum(i => i.BeneficiaryAmnt), CenterAmount = g.Where(i => i.IsCentreAmnt == true).Sum(l => l.LoanAmnt), StateAmount = g.Where(i => i.IsCentreAmnt == false).Sum(l => l.LoanAmnt), ULBAmount = 0, TotalAmount = g.Sum(b => b.BeneficiaryAmnt) + g.Sum(b => b.LoanAmnt), }).ToList(); ViewBag.GrandTotal = installmentslists.Sum(t => t.TotalAmount); //if (installments != null) //{ // workstatus = installments.Select(s => new WorkStatusDetailsViewModel // { // Installment = s.InstallmentNo == 1 ? "First" : s.InstallmentNo == 2 ? "Second" : s.InstallmentNo == 3 ? "Third" : s.InstallmentNo == 4 ? "Fourth" : s.InstallmentNo == 5 ? "Fifth" : s.InstallmentNo == 6 ? "Sixth-Cum Final" : "", // LevelType = s.InstallmentNo == 1 ? "At Plinth Level" : s.InstallmentNo == 2 ? "At Lintel Level" : s.InstallmentNo == 3 ? "At Roof Level" : s.InstallmentNo == 4 ? "For Finishing Completion" : s.InstallmentNo == 5 ? "Level" : s.InstallmentNo == 6 ? "Level" : "", // BeneficiaryAmount = s.BeneficiaryAmnt == null ? 0 : s.BeneficiaryAmnt, // CenterAmount = s.IsCentreAmnt == null ? 0 : s.IsCentreAmnt == true ? s.LoanAmnt : 0, // StateAmount = s.IsCentreAmnt == null ? 0 : s.IsCentreAmnt == false ? s.LoanAmnt : 0, // ULBAmount = 0, // TotalAmount = s.BeneficiaryAmnt + s.LoanAmnt == null ? 0 : s.BeneficiaryAmnt + s.LoanAmnt, // }).ToList(); // ViewBag.GrandTotal = workstatus.Sum(w => w.TotalAmount); //} return(Json(installmentslists)); }
public ActionResult SurveyDetails(int installmentId) { var installmentNo = _installmentDetailService.Get().Where(i => i.InstallmentId == installmentId).Select(x => x.InstallmentNo).FirstOrDefault(); var BeniId = _icommentService.Get().Where(i => i.InstallementId == installmentId).Select(b => b.BeneficiaryId).FirstOrDefault(); IEnumerable <sp_GetSurveyDetailsByBenID_Result> commentlist = _icommentService.GetSurveyDetailsByBenificiaryID(BeniId, installmentNo.Value); var mappedCommentList = commentlist.Select(s => new SurveyDetailsModel { BeneficiaryId = s.BeneficiaryId, Comments = s.Comments, UserName = s.UserName, CreatedDate = s.CreatedDate, MobileNo = s.MobileNo, Sign = Convert.ToBoolean(s.Sign), Physical_Progress = s.Physical_Progress, Role = s.Role }).ToList(); return(PartialView("_SurveyDetails", mappedCommentList)); }