public static ServeurFlux getServeurFlux(int cdSrv, int cdFlux) { OracleTrans o = OracleTrans.getInstance; var data = o.ExecuterSelect <ServeurFlux>("SELECT CD_SERVEUR, CD_FLUX, CHEMIN_LOCAL, CHEMIN_DISTANT FROM trft_serveur_flux WHERE cd_srv = :1 AND cd_flux = :2", -1, cdSrv, cdFlux).Data; return(data.FirstOrDefault()); }
public static Flux getFlux(int cdFlux) { OracleTrans o = OracleTrans.getInstance; var data = o.ExecuterSelect <Flux>("SELECT DESIGNATION FROM trft_flux WHERE cd_flux = :1 ", -1, cdFlux).Data; return(data.FirstOrDefault()); }
public static Serveur getServeur(int cdSrv) { OracleTrans o = OracleTrans.getInstance; var data = o.ExecuterSelect <Serveur>("SELECT CD_SRV, CD_CLIENT_SRV, ADRESSE_IP, FTP_IDENTIFIANT, FTP_MDP, FTP_PORT, TRFT_PORT FROM trft_serveurs WHERE cd_srv = :1 ", -1, cdSrv).Data; return(data.FirstOrDefault()); }
public static Transfert getTransfert(int cdTRFT) { OracleTrans o = OracleTrans.getInstance; var data = o.ExecuterSelect <Transfert>("SELECT CD_TRFT, CD_FLUX, CD_CLIENT, DESIGNATION, TAILLE_FICHIER, ETAT, IP_SOURCE, DATE FROM trft_transfert WHERE cd_trft = :1 ", -1, cdTRFT).Data; return(data.FirstOrDefault()); }
public static Client getClient(int cdClient) { OracleTrans o = OracleTrans.getInstance; var data = o.ExecuterSelect <Client>("SELECT RAISON_SOCIAL, ADRESSE_POSTALE, CODE_POSTAL, VILLE, PAYS FROM TRFT_CLIENT WHERE cd_client = :1 ", -1, cdClient).Data; return(data.FirstOrDefault()); }
public static IList <Flux> getFluxs() { OracleTrans o = OracleTrans.getInstance; return(o.ExecuterSelect <Flux>("SELECT CD_FLUX, DESIGNATION FROM trft_flux").Data); }
public static IList <Serveur> getServeurs() { OracleTrans o = OracleTrans.getInstance; return(o.ExecuterSelect <Serveur>("SELECT CD_SRV, CD_CLIENT_SRV, ADRESSE_IP, FTP_IDENTIFIANT, FTP_MDP, FTP_PORT, TRFT_PORT FROM trft_serveurs").Data); }
public static IList <Transaction> getTransactions(int cdTRFT) { OracleTrans o = OracleTrans.getInstance; return(o.ExecuterSelect <Transaction>("SELECT CD_TRST, CD_TRFT, DETAIL, CODE_ERREUR, ETAT, DATE_TRANSACTION FROM trft_transaction WHERE cd_trft = :1", -1, cdTRFT).Data); }
public static IList <Transfert> getTransfertsEtat(String etat) { OracleTrans o = OracleTrans.getInstance; return(o.ExecuterSelect <Transfert>("SELECT * FROM trft_transfert WHERE Etat = :1", -1, etat).Data); }
public static IList <Transfert> getTransferts() { OracleTrans o = OracleTrans.getInstance; return(o.ExecuterSelect <Transfert>("SELECT * FROM trft_transfert").Data); }
public static IList <ServeurFlux> getLstServeursFlux(int cdFlux) { OracleTrans o = OracleTrans.getInstance; return(o.ExecuterSelect <ServeurFlux>("SELECT TRFT_FLUX.CD_FLUX, TRFT_SERVEUR_FLUX.CD_SRV, TRFT_SERVEURS.ADRESSE_IP, TRFT_FLUX.DESIGNATION, TRFT_SERVEUR_FLUX.CHEMIN_LOCAL FROM TRFT_SERVEUR_FLUX, TRFT_SERVEURS, TRFT_FLUX WHERE TRFT_SERVEUR_FLUX.CD_SRV = TRFT_SERVEURS.CD_SRV AND TRFT_SERVEUR_FLUX.CD_FLUX = TRFT_FLUX.CD_FLUX AND TRFT_FLUX.CD_FLUX = :1", -1, cdFlux).Data); }
public static IList <Client> getClients() { OracleTrans o = OracleTrans.getInstance; return(o.ExecuterSelect <Client>("SELECT CD_CLIENT, RAISON_SOCIAL, ADRESSE_POSTALE, CODE_POSTAL, VILLE, PAYS FROM TRFT_CLIENT").Data); }
public static IList <ClientServeur> getClientServeurs() { OracleTrans o = OracleTrans.getInstance; return(o.ExecuterSelect <ClientServeur>("SELECT CD_SRV, CD_CLIENT FROM trft_client_serveur").Data); }
public static IList <ClientServeur> getClientsServeurs() { OracleTrans o = OracleTrans.getInstance; return(o.ExecuterSelect <ClientServeur>("SELECT TRFT_CLIENT_SERVEUR.CD_CLIENT, TRFT_SERVEURS.CD_SRV, TRFT_SERVEURS.ADRESSE_IP, TRFT_SERVEURS.FTP_IDENTIFIANT, TRFT_SERVEURS.FTP_MDP, TRFT_SERVEURS.FTP_PORT, TRFT_SERVEURS.TRFT_PORT FROM TRFT_CLIENT_SERVEUR, TRFT_SERVEURS WHERE TRFT_CLIENT_SERVEUR.CD_SRV = TRFT_SERVEURS.CD_SRV").Data); }