public JsonResult BeneficiarySummary(int CaseDetailId, String CaseKey, int CaseId)
{
QueriesViewModel model = new QueriesViewModel();
var caseResults = TransactionService.FindCaseBeneficiariesByCase(CaseDetailId, CaseKey, CaseId);
var results = caseResults.Select(r => new
{
FullName = !r.CaseDetail.Entity.FullName.IsNull() ? r.CaseDetail.Entity.FullName : "N/A",
Concept = !r.CaseDetail.Case.Concept.Concept1.IsNull() ? r.CaseDetail.Case.Concept.Concept1 : "N/A",
Suffix = !r.CaseDetail.CaseKey.IsNull() ? r.CaseDetail.CaseKey : "N/A",
BirthDate = !r.CaseDetail.Entity.BirthDate.IsNull() ? ((DateTime)r.CaseDetail.Entity.BirthDate).ToString("yyyy-MM-dd") : "N/A",
SSN = !r.CaseDetail.Entity.SSN.IsNull() ? r.CaseDetail.Entity.SSN.ToSSN() : "N/A",
Relation = !r.CaseDetail.RelationshipType.IsNull() ? r.CaseDetail.RelationshipType.RelationshipType1 : "N/A",
Reserve = !r.CaseDetail.Reserve.IsNull() ? r.CaseDetail.Reserve : 0,
Minstallment = !r.CaseDetail.MonthlyInstallment.IsNull() ? r.CaseDetail.MonthlyInstallment : 0,
Payed = !r.CaseDetail.Payments.IsNull() ? r.CaseDetail.Payments.Where(x => x.Amount > 0.00m).Where(x => x.Status.Effect == "+").Where(x => x.Concept.ConceptType == "Incapacidad").Sum(x => x.Amount) : 0,
Balance = !r.CaseDetail.Payments.IsNull() ? !r.CaseDetail.Transactions.IsNull() ? r.CaseDetail.Transactions.Where(x => (x.TransactionTypeId == 1 || x.TransactionTypeId == 2))
.Sum(x => x.TransactionAmount) - r.CaseDetail.Payments.Where(x => x.Amount > 0.00m)
.Where(x => x.Status.Effect == "+")
.Where(x => x.Concept.ConceptType == "Incapacidad")
.Sum(x => x.Amount)
: r.CaseDetail.Payments.Where(x => x.Amount > 0.00m)
.Where(x => x.Status.Effect == "+")
.Where(x => x.Concept.ConceptType == "Incapacidad")
.Sum(x => x.Amount) : !r.CaseDetail.Transactions.IsNull() ? r.CaseDetail.Transactions.Where(x => (x.TransactionTypeId == 1 || x.TransactionTypeId == 2))
.Sum(x => x.TransactionAmount) : 0.00m
}).Distinct();
return(Json(new BasicDataTablesResult(results), JsonRequestBehavior.AllowGet));
}
public JsonResult ITPSummary(int CaseDetailId, String CaseKey)
{
QueriesViewModel model = new QueriesViewModel();
var caseResult = TransactionService.GetTransactionByConceptCasefolder(CaseDetailId, CaseKey, 5);
var results = caseResult.Select(r => new
{
Date = !r.DecisionDate.IsNull() ? ((DateTime)r.DecisionDate).ToString("yyyy-MM-dd") : "N/A",
Reserve = !r.CaseDetail.Reserve.IsNull() ? r.CaseDetail.Reserve : 0,
Installment = !r.CaseDetail.MonthlyInstallment.IsNull() ? r.CaseDetail.MonthlyInstallment : 0,
Payment = !r.CaseDetail.Payments.IsNull() ? r.CaseDetail.Payments.Where(x => x.Amount > 0.00m).Where(x => x.Status.Effect == "+").Where(x => x.ConceptId != 2).Sum(x => x.Amount): 0.00m,
Balance = !r.CaseDetail.Payments.IsNull() ? !r.CaseDetail.Transactions.IsNull() ? r.CaseDetail.Transactions.Where(x => (x.TransactionTypeId == 1 || x.TransactionTypeId == 2))
.Sum(x => x.TransactionAmount) - r.CaseDetail.Payments.Where(x => x.Amount > 0.00m)
.Where(x => x.Status.Effect == "+")
.Where(x => x.Concept.ConceptType == "Incapacidad")
.Sum(x => x.Amount)
: r.CaseDetail.Payments.Where(x => x.Amount > 0.00m)
.Where(x => x.Status.Effect == "+")
.Where(x => x.Concept.ConceptType == "Incapacidad")
.Sum(x => x.Amount) : !r.CaseDetail.Transactions.IsNull() ? r.CaseDetail.Transactions.Where(x => (x.TransactionTypeId == 1 || x.TransactionTypeId == 2))
.Sum(x => x.TransactionAmount) : 0.00m,
BalanceIPP = !r.CaseDetail.Payments.IsNull() ? !r.CaseDetail.Transactions.IsNull() ? r.CaseDetail.Transactions.Where(x => (x.TransactionTypeId == 1 || x.TransactionTypeId == 2)).Where(x => (x.ConceptId == 3 || x.ConceptId == 7 || x.ConceptId == 9))
.Sum(x => x.TransactionAmount) - r.CaseDetail.Payments.Where(x => (x.ConceptId == 3 || x.ConceptId == 7 || x.ConceptId == 9)).Where(x => x.Status.Effect == "+")
.Sum(x => x.Amount) : r.CaseDetail.Payments.Where(x => (x.ConceptId == 3 || x.ConceptId == 7 || x.ConceptId == 9)).Where(x => x.Status.Effect == "+")
.Sum(x => x.Amount) : !r.CaseDetail.Transactions.IsNull() ? r.CaseDetail.Transactions.Where(x => (x.TransactionTypeId == 1 || x.TransactionTypeId == 2)) //.Where(x => (x.ConceptId == 3 || x.ConceptId == 7 || x.ConceptId == 9))
.Sum(x => x.TransactionAmount) : 0.00m
});
return(Json(new BasicDataTablesResult(results), JsonRequestBehavior.AllowGet));
}
public ActionResult CaseInformation(string CaseNumber)
{
QueriesViewModel model = new QueriesViewModel();
model.CaseModel.Case = CaseService.FindCaseDetailByNumber(CaseNumber);
return(View(model));
}
public JsonResult InversionSummary(int CaseDetailId, String CaseKey)
{
QueriesViewModel model = new QueriesViewModel();
var caseResult = TransactionService.GetTransactionTypeInversionCase(CaseDetailId, CaseKey);
var results = caseResult.Select(r => new
{
Date = !r.DecisionDate.IsNull() ? ((DateTime)r.DecisionDate).ToString("yyyy-MM-dd") : "N/A",
Amount = !r.TransactionAmount.IsNull() ? r.TransactionAmount : 0
});
return(Json(new BasicDataTablesResult(results), JsonRequestBehavior.AllowGet));
}
public JsonResult IPPSummary(int CaseDetailId, String CaseKey)
{
QueriesViewModel model = new QueriesViewModel();
var caseResult = TransactionService.GetTransactionByConceptCasefolder(CaseDetailId, CaseKey, 3);
var results = caseResult.Select(r => new
{
Amount = !r.TransactionAmount.IsNull() ? r.TransactionAmount : 0,
Weeks = r.NumberOfWeeks,
Date = !r.DecisionDate.IsNull() ? ((DateTime)r.DecisionDate).ToString("yyyy-MM-dd") : "N/A"
});
return(Json(new BasicDataTablesResult(results), JsonRequestBehavior.AllowGet));
}
public JsonResult BeneficiaryDetail(int CaseDetailId, String CaseKey, int CaseId)
{
QueriesViewModel model = new QueriesViewModel();
var caseResults = TransactionService.FindBeneficiaryDetail(CaseDetailId, CaseKey, CaseId);
var results = caseResults.Select(r => new
{
FullName = !r.CaseDetail.Entity.FullName.IsNull() ? r.CaseDetail.Entity.FullName : "N/A",
TType = !r.TransactionType.TransactionType1.IsNull() ? r.TransactionType.TransactionType1 : "N/A",
Amount = !r.TransactionAmount.IsNull() ? r.TransactionAmount : 0,
Date = !r.TransactionDate.IsNull() ? ((DateTime)r.TransactionDate).ToString("yyyy-MM-dd") : "N/A",
});
return(Json(new BasicDataTablesResult(results), JsonRequestBehavior.AllowGet));
}
public JsonResult FindNonComplaintPayments()
{
QueriesViewModel model = new QueriesViewModel();
var caseData = PaymentService.PaymentQuery("NonCompliantPayment");
var results = caseData.Select(r => new
{
caseNumber = r.CaseNumber,
caseKey = r.CaseKey,
fromDate = r.FromDate != null ? ((DateTime)r.FromDate).ToString("yyyy-MM-dd") : "N/A",
toDate = r.ToDate != null ? ((DateTime)r.ToDate).ToString("yyyy-MM-dd") : "N/A",
paymentDay = r.PaymentDay,
paymentAmount = r.Amount,
fullName = r.CaseDetail.Entity.FullName,
ssn = r.CaseDetail.Entity.SSN.ToSSN(),
birthdate = r.CaseDetail.Entity.BirthDate,
dailywage = r.Case.DailyWage,
weeklycomp = r.Case.WeeklyComp,
status = r.Status.Status1
});
return(Json(new BasicDataTablesResult(results), JsonRequestBehavior.AllowGet));
}
public ActionResult Index(string CaseNumber)
{
var model = new QueriesViewModel();
return(View(model));
}
public HomePage()
{
InitializeComponent();
BindingContext = new QueriesViewModel(Navigation);
}
public void SetTarget(QueriesViewModel vm)
{
_target = vm;
}
