code View

id 7
Title Last status, Last service (at TODAY)
Type snippet
Highlight group
Description last status
Code

Last TARV status

from s in db.d_status.Where(w => w.id_person == p.id_person && w.domain== "TARV" && w.active == true && (w.deleted == null || !(bool)w.deleted))  //.DefaultIfEmpty()

 

Last SERVICE Status

from s in db.d_status.Where(w => w.id_person == p.id_person && w.domain == "SERVICE" && w.active == true && (w.deleted == null || !(bool)w.deleted))  //DefaultIfEmpty


domain = = TBSTA, FOODI, ASSIS, SERVICE, TARV, HIVST, FEED, TER_COT, TBC_PRE_TPI, TER_FLU

SERVICE STATUS
ENDASS
NODREAM
MCPC
MCPC_C
CCHC
VCT
TBCARE
PEP
TRANSIT
 

 

ASSIS STATUS
HOMECARE
DAYHOSP
RICOVEROHC
RICOVERO
CCHC
 

 

TBSTA STATUS
TBC_PRE_COT
TBC_SI
TBC_SI_2
TBC_NO
 

 

FOODI STATUS
FOOD_INT_NO
FOOD_INT_YES

 

TARV STATUS
TARV_NO
TARV_SI

 

HIVST STATUS
STBY --> da correggere!
HIV_INSEC
HIV_NO
HIV_STBY
HIV_YES
HIV_TEST

 

FEED STATUS
TA_ARTIFIC
TA_MISTO
TA_ALSENO
HIV_STBY

 

TER_COT, TBC_PRE_TPI, TER_FLU  STATUS
YES
NO
Ordine 10