public JsonResult FindRequests(SearchViewModel model)
{
var payments = PaymentService.SearchPaymentsAdjustmentEBT(model.CaseNumber, model.EntityName, model.SocialSecurityNumber, model.BirthDate, model.FilingDate, model.RegionId, model.ClinicId, model.EBTNumber).ToList();
var result = new List <AdjusmentEbtViewModel>();
foreach (var payment in payments)
{
var paymentAjusteEbtModel = new AdjusmentEbtViewModel
{
PaymentId = payment.PaymentId,
CaseId = payment.CaseId.Value,
CaseDetailId = payment.CaseDetailId.Value,
CaseNumber = payment.CaseNumber,
CaseKey = payment.CaseKey,
AdjustmentStatusId = payment.AdjustmentStatusId,
AdjustmentStatus = payment.AdjustmentStatusId.HasValue ? payment.AdjustmentStatus.AdjustmentStatus1 : string.Empty,
AdjustmentType = payment.AdjustmentType,
AdjustmentRequestedDate = payment.AdjustmentRequestedDate.ToShortDateString(),
AdjustmentRequestedBy = payment.AdjustmentRequestedBy,
ConceptId = payment.ConceptId,
Concept = payment.ConceptId.HasValue ? payment.Concept.Concept1 : string.Empty,
TransactionNumber = payment.TransactionNum,
IssueDate = payment.IssueDate.ToShortDateString(),
FromDate = payment.FromDate.ToShortDateString(),
ToDate = payment.ToDate.ToShortDateString(),
PaymentDay = payment.PaymentDay.Value,
Amount = payment.Amount.ToCurrency()
};
result.Add(paymentAjusteEbtModel);
}
return(Json(new BasicDataTablesResult(result), JsonRequestBehavior.AllowGet));
}
private AdjusmentEbtViewModel GetTableRowAdjusmentEBT(Payment payment)
{
var itemEmailEbt = new AdjusmentEbtViewModel
{
PaymentId = payment.PaymentId,
CaseId = payment.CaseId.Value,
CaseDetailId = payment.CaseDetailId.Value,
CaseNumber = payment.CaseNumber,
EbtNumber = payment.CaseDetail.EBTAccount,
CaseKey = payment.CaseKey,
AdjustmentStatusId = payment.AdjustmentStatusId,
AdjustmentStatus = payment.AdjustmentStatusId.HasValue && payment.AdjustmentStatus != null && payment.AdjustmentStatus.AdjustmentStatus1 != null ? payment.AdjustmentStatus.AdjustmentStatus1 : string.Empty,
AdjustmentType = payment.AdjustmentType,
AdjustmentRequestedDate = payment.AdjustmentRequestedDate != null?payment.AdjustmentRequestedDate.ToShortDateString() : string.Empty,
AdjustmentRequestedBy = payment.AdjustmentRequestedBy,
ConceptId = payment.ConceptId,
Concept = payment.ConceptId.HasValue && payment.Concept != null && payment.Concept.Concept1 != null ? payment.Concept.Concept1 : string.Empty,
TransactionNumber = payment.TransactionNum,
IssueDate = payment.IssueDate != null?payment.IssueDate.ToShortDateString() : string.Empty,
FromDate = payment.FromDate != null?payment.FromDate.ToShortDateString() : string.Empty,
ToDate = payment.ToDate != null?payment.ToDate.ToShortDateString() : string.Empty,
PaymentDay = payment.PaymentDay != null ? payment.PaymentDay.Value : (short)0,
Amount = payment.Amount != null?payment.Amount.ToCurrency() : string.Empty
};
return(itemEmailEbt);
}
public JsonResult FindRequestsToApprove()
{
var payments = PaymentService.FindAdjustmentsEBTToApprove().Where(p => !p.CaseDetail.EBTStatus.Equals("Expunged", StringComparison.OrdinalIgnoreCase)).ToList();
var result = new List <AdjusmentEbtViewModel>();
foreach (var payment in payments)
{
var paymentAjusteEbtModel = new AdjusmentEbtViewModel
{
PaymentId = payment.PaymentId,
CaseId = payment.CaseId.Value,
CaseDetailId = payment.CaseDetailId.Value,
CaseNumber = payment.CaseNumber,
CaseKey = payment.CaseKey,
AdjustmentStatusId = payment.AdjustmentStatusId,
AdjustmentStatus = payment.AdjustmentStatusId.HasValue ? payment.AdjustmentStatus.AdjustmentStatus1 : string.Empty,
AdjustmentType = payment.AdjustmentType,
AdjustmentRequestedDate = payment.AdjustmentRequestedDate.ToShortDateString(),
AdjustmentRequestedBy = payment.AdjustmentRequestedBy,
ConceptId = payment.ConceptId,
Concept = payment.ConceptId.HasValue ? payment.Concept.Concept1 : string.Empty,
TransactionNumber = payment.TransactionNum,
IssueDate = payment.IssueDate.ToShortDateString(),
FromDate = payment.FromDate.ToShortDateString(),
ToDate = payment.ToDate.ToShortDateString(),
PaymentDay = payment.PaymentDay.Value,
Amount = payment.Amount.ToCurrency()
};
result.Add(paymentAjusteEbtModel);
}
return(Json(new BasicDataTablesResult(result), JsonRequestBehavior.AllowGet));
}
public JsonResult FindRequestsToDocument()
{
var payments = PaymentService.FindAdjustmentEBTToDocument();
var result = new List <AdjusmentEbtViewModel>();
if (payments == null)
{
return(Json(new BasicDataTablesResult(result), JsonRequestBehavior.AllowGet));
}
payments = payments.ToList();
foreach (var payment in payments)
{
var paymentAjusteEbtModel = new AdjusmentEbtViewModel
{
PaymentId = payment.PaymentId,
CaseId = payment.CaseId.Value,
CaseDetailId = payment.CaseDetailId.Value,
CaseNumber = payment.CaseNumber,
CaseKey = payment.CaseKey,
AdjustmentStatusId = payment.AdjustmentStatusId,
AdjustmentStatus = payment.AdjustmentStatusId.HasValue ? payment.AdjustmentStatus.AdjustmentStatus1 : string.Empty,
AdjustmentType = payment.AdjustmentType,
AdjustmentRequestedDate = payment.AdjustmentRequestedDate.ToShortDateString(),
AdjustmentRequestedBy = payment.AdjustmentRequestedBy,
ConceptId = payment.ConceptId,
Concept = payment.ConceptId.HasValue ? payment.Concept.Concept1 : string.Empty,
TransactionNumber = payment.TransactionNum,
IssueDate = payment.IssueDate.ToShortDateString(),
FromDate = payment.FromDate.ToShortDateString(),
ToDate = payment.ToDate.ToShortDateString(),
PaymentDay = payment.PaymentDay.Value,
Amount = payment.Amount.ToCurrency()
};
result.Add(paymentAjusteEbtModel);
}
return(Json(new BasicDataTablesResult(result), JsonRequestBehavior.AllowGet));
}
