public static List <usp_Medicos_by_CRegionalID_Result> medicosByCRegional(int id)
{
List <usp_Medicos_by_CRegionalID_Result> lista = null;
using (ColegioMPEntities db = new ColegioMPEntities())
{
db.Configuration.ProxyCreationEnabled = false;
lista = db.usp_Medicos_by_CRegionalID(id).ToList();
}
return(lista);
}
public static List <usp_List_CRegional_Result> getAllCRegional()
{
List <usp_List_CRegional_Result> lista = null;
using (ColegioMPEntities db = new ColegioMPEntities())
{
db.Configuration.ProxyCreationEnabled = false;
lista = db.usp_List_CRegional().ToList();
}
return(lista);
}
public static List <usp_List_MedicosInstEdu_Result> getTopInstEduMedicos()
{
List <usp_List_MedicosInstEdu_Result> lista = null;
using (ColegioMPEntities db = new ColegioMPEntities())
{
db.Configuration.ProxyCreationEnabled = false;
lista = db.usp_List_MedicosInstEdu().ToList();
}
return(lista);
}
public static List <usp_PostGrado_By_MedicoID_Result> postgradosMedico(int id)
{
List <usp_PostGrado_By_MedicoID_Result> lista = null;
using (ColegioMPEntities db = new ColegioMPEntities())
{
db.Configuration.ProxyCreationEnabled = false;
lista = db.usp_PostGrado_By_MedicoID(id).ToList();
}
return(lista);
}
public static List <usp_Medico_By_Paterno_Result> medicosByPaterno(string pat)
{
List <usp_Medico_By_Paterno_Result> lista = null;
using (ColegioMPEntities db = new ColegioMPEntities())
{
db.Configuration.ProxyCreationEnabled = false;
lista = db.usp_Medico_By_Paterno(pat).ToList();
}
return(lista);
}
public static usp_Medico_By_NroCol_Result infoMedicoByNroCol(string nroCol)
{
usp_Medico_By_NroCol_Result medico = null;
using (ColegioMPEntities db = new ColegioMPEntities())
{
db.Configuration.ProxyCreationEnabled = false;
medico = db.usp_Medico_By_NroCol(nroCol).FirstOrDefault();
}
return(medico);
}
