public PnBeneficiarioCollection FetchByQuery(Query qry)
{
PnBeneficiarioCollection coll = new PnBeneficiarioCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
private void VerificarPlanNacer(SysPaciente p)
{
PnBeneficiarioCollection benef = DB.Select().From(Schemas.PnBeneficiario)
.Where(PnBeneficiario.Columns.IdPaciente).IsEqualTo(p.IdPaciente)
.ExecuteAsCollection <PnBeneficiarioCollection>();
if (benef.Count > 0)
{
hlPlanNacer.Text = "Ver beneficiario";
hlPlanNacer.NavigateUrl = string.Format("~/PlanNacer/Inscripcion/View.aspx?id={0}", benef[0].IdBeneficiarios);
}
else
{
if (CumpleCondicionesPlanNacer(p))
{
hlPlanNacer.Text = "Inscribir como beneficiario";
hlPlanNacer.NavigateUrl = string.Format("~/PlanNacer/Inscripcion/Edit.aspx?idPac={0}", p.IdPaciente);
hlPlanNacer.Enabled = true;
}
else
{
hlPlanNacer.Text = "No cumple las condiciones de Plan Nacer";
hlPlanNacer.NavigateUrl = "#";
hlPlanNacer.Enabled = false;
}
}
}
public PnBeneficiarioCollection FetchAll()
{
PnBeneficiarioCollection coll = new PnBeneficiarioCollection();
Query qry = new Query(PnBeneficiario.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public PnBeneficiarioCollection FetchByID(object IdBeneficiarios)
{
PnBeneficiarioCollection coll = new PnBeneficiarioCollection().Where("id_beneficiarios", IdBeneficiarios).Load();
return(coll);
}
