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