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);
}
