public IHttpActionResult GetSpecificClaims(int IdHealthCareProvider, DateTime DateFrom, DateTime DateTo)
{
using (var context = new NextCareEntities())
{
var claims = (from c in context.Claims
join ip in context.InsurancePolicies on c.InsuranceCardNumber equals ip.InsuranceCardNumber
join b in context.Beneficiaries on ip.IdBeneficiary equals b.Id
join h in context.HealthCareProviders on c.IdHealthCareProvider equals h.Id
join mc in context.MedicalCases on c.IdMedicalCase equals mc.Id
where c.IdHealthCareProvider == IdHealthCareProvider
& c.AdmissionDate >= DateFrom
& c.AdmissionDate <= DateTo
select new
{
c.AdmissionDate,
c.InsuranceCardNumber,
BeneficiaryName = b.FirstName + " " + b.FatherName + " " + b.LastName,
HealthcareProviderName = h.Name,
MedicalCase = mc.Value,
c.EstimatedCost,
Status = c.Status == 0 ? "Not Covered" : c.Status == 1 ? "Covered" : "Pending"
}).ToList();
if (claims == null)
{
return(NotFound());
}
return(Ok(claims));
}
}
public IHttpActionResult GetByPolicyNumber(string PolicyNumber)
{
Beneficiary beneficiary;
using (var context = new NextCareEntities())
{
var query = from b in context.Beneficiaries
join ip in context.InsurancePolicies on b.Id equals ip.IdBeneficiary
where ip.InsuranceCardNumber == PolicyNumber
select b;
beneficiary = query.FirstOrDefault();
}
if (beneficiary == null)
{
return(NotFound());
}
return(Ok(beneficiary));
}
