//MHM _context;
public IEnumerable <FedPovertyLevelMst> GetFedPovertyLevelMaster()
{
using (var _context = new MHM())
{
return(_context.FedPovertyLevelMsts.ToList());
}
}
//MHM _context;
public IEnumerable <MHMBenefitMappingMst> GetMHMBenefitMappingMaster()
{
using (var _context = new MHM())
{
return(_context.MHMBenefitMappingMsts.ToList());
}
}
//MHM _context;
public IEnumerable <IssuerMst> GetIssuerMaster()
{
using (var _context = new MHM())
{
return(_context.IssuerMsts.ToList());
}
}
//MHM _context;
public IEnumerable <PlanBenefitMst> GetPlanBenefitMaster()
{
using (var _context = new MHM())
{
return(_context.PlanBenefitMsts.ToList());
}
}
//MHM _context;
public IEnumerable <MedicaidEligibility> GetMedicaidEligibility()
{
using (var _context = new MHM())
{
return(_context.MedicaidEligibilities.ToList());
}
}
//MHM _context;
public IEnumerable <FPLCapMst> GetFPLCapMaster()
{
using (var _context = new MHM())
{
return(_context.FPLCapMsts.ToList());
}
}
//MHM _context;
public IEnumerable <HSAFunding> GetHSAFunding()
{
using (var _context = new MHM())
{
return(_context.HSAFundings.ToList());
}
}
//MHM _context;
public IEnumerable <ChipEligibility> GetChipEligibility()
{
using (var _context = new MHM())
{
return(_context.ChipEligibilities.ToList());
}
}
//MHM _context;
public IEnumerable <tblRatingAreaMst> GetRatingAreaMaster()
{
using (var _context = new MHM())
{
return(_context.tblRatingAreaMsts.ToList());
}
}
//MHM _context;
public IEnumerable <qryZipCodeToRatingArea> GetqryZipCodeToRatingArea()
{
using (var _context = new MHM())
{
return(_context.qryZipCodeToRatingAreas.ToList());
}
}
//MHM _context;
public IEnumerable <CountyMst> GetCountyMaster()
{
using (var _context = new MHM())
{
return(_context.CountyMsts.ToList());
}
}
public IEnumerable <PlanAttributeMst> GetPlanAttributeMasterExcel()
{
using (var _context = new MHM())
{
var planAttributes = _context.PlanAttributeMsts.Include("InsuranceType1").Include("IssuerMst").Include("JobPlansMsts").Include("JobPlansMsts.JobMaster").Include("tblStateAbrev").Include("PlanMaster").Include("PlanBenefitMsts").ToList();
return(planAttributes);
}
}
//MHM _context;
public IEnumerable <Rule> GetRules()
{
using (var _context = new MHM())
{
var Rules = _context.Rules.ToList();
return(Rules);
}
}
//MHM _context;
public IEnumerable <ZipCodeMst> GetZipCodeMaster()
{
using (var _context = new MHM())
{
var ZipCodeMsts = _context.ZipCodeMsts.ToList();
return(ZipCodeMsts);
}
}
//MHM _context;
public IEnumerable <JobMaster> GetJobMaster()
{
using (var _context = new MHM())
{
var JobMasters = _context.JobMasters.ToList();
JobMasters.ForEach(r => r.JobPlansMsts = r.JobPlansMsts);
return(JobMasters);
}
}
//MHM _context;
public IEnumerable <PlanAttributeMst> GetPlanAttributeMaster()
{
using (var _context = new MHM())
{
//var ActiveIssuers = _context.IssuerMsts.Where(r => r.Status == true).Select(t => t.Id).ToList();
var planAttributes = _context.PlanAttributeMsts.ToList();
//.Include("InsuranceType1").Include("IssuerMst").Include("JobPlansMsts").Include("JobPlansMsts.JobMaster").Include("tblStateAbrev").Include("PlanMaster").Include("PlanBenefitMsts")
//.Include("InsuranceType1").Include("IssuerMst").Include("JobPlansMsts").Include("JobPlansMsts.JobMaster").Include("tblStateAbrev").Include("PlanMaster").Include("PlanBenefitMsts")
return(planAttributes);//.Where(r => ActiveIssuers.Contains((long)r.CarrierId)).ToList();
}
}
//MHM _context;
public IEnumerable <CSR_Rate_Mst> GetCSRRateMaster()
{
using (var _context = new MHM())
{
//var ActiveIssuers = _context.IssuerMsts.Select(t => t.Id).ToList();
//var IndividualPlanAttributes = _context.PlanAttributeMsts.Where(r => ActiveIssuers.Contains((long)r.CarrierId) && r.OpenForEnrollment == true && (r.MrktCover == "Indi" || r.MrktCover == "SHOP")).Select(t => t.StandardComponentId).ToList();
//var GroupPlanAttributes = _context.PlanAttributeMsts.Where(r => ActiveIssuers.Contains((long)r.CarrierId) && r.MrktCover == "Group" && r.OpenForEnrollment == true).Select(t => t.PlanId).ToList();
//var ActiveIssuers = _context.IssuerMsts.Select(t => t.Id).ToList();
//var IndividualPlanAttributes = _context.PlanAttributeMsts.Where(r => (r.MrktCover == "Indi" || r.MrktCover == "SHOP")).Select(t => t.StandardComponentId).ToList();
//var GroupPlanAttributes = _context.PlanAttributeMsts.Where(r => r.MrktCover == "Group").Select(t => t.PlanId).ToList();
//var fullEntries = _context.CSR_Rate_Mst
//.Join(
//_context.PlanAttributeMsts.Where(r => r.MrktCover == "Indi"),
//entryPoint => entryPoint.PlanID,
//entry => entry.StandardComponentId,
//(entryPoint, entry) => new { entryPoint, entry }
//)
//.Join(
//_context.PlanAttributeMsts.Where(r => r.MrktCover == "GRP"),
//entryPoint => entryPoint.entryPoint.PlanID,
//entry1 => entry1.PlanId,
//(entryPoint, entry1) => new { entryPoint, entry1 }
//)
//.Join(
//_context.IssuerMsts,
//combinedEntry => combinedEntry.entryPoint.entry.CarrierId,
//Issuer => Issuer.Id,
//(combinedEntry, Issuer) => new
//{
// Issuers = Issuer,
// PlanAttributes = combinedEntry.entryPoint.entry,
// PlanAttributes1 = combinedEntry.entry1,
// CSRRateMst = combinedEntry.entryPoint
//}
//)
//.Where(fullEntry => fullEntry.CSRRateMst).ToList();
//var yey = _context.CSR_Rate_Mst.Where(r => IndividualPlanAttributes.Contains(r.PlanID) || GroupPlanAttributes.Contains(r.PlanID)).ToList();
return(_context.CSR_Rate_Mst.Include("tblRatingAreaMst").Include("tblStateAbrev").ToList());
}
}