// CLIENT (E-F) - Get tous les clients
public static List <CLI_FetchTousClients_Result> FetchTousClients()
{
using (AirlinesEntities context = new AirlinesEntities()) {
List <CLI_FetchTousClients_Result> listeClients = new List <CLI_FetchTousClients_Result>();
try {
listeClients = context.CLI_FetchTousClients().ToList();
}
catch (Exception e) {
throw e;
}
return(listeClients);
}
}
// CLIENT (E-F) - Get
public static List <CLI_GetClientMoneyInfo_Result> GetClientMoneyInfo(int idClient, int idReservation)
{
List <CLI_GetClientMoneyInfo_Result> oList = new List <CLI_GetClientMoneyInfo_Result>();
using (AirlinesEntities oContext = new AirlinesEntities()) {
try {
oList = oContext.CLI_GetClientMoneyInfo(idClient, idReservation).ToList();
}
catch (System.Data.Entity.Core.EntityException efEx) {
SqlException sqEx = (SqlException)efEx.InnerException;
int numErreur = 666;
switch (sqEx.Number)
{
case 2601:
numErreur = 3;
break;
case 51000:
numErreur = 4;
break;
case 52000:
numErreur = 7;
break;
case 53000:
numErreur = 3;
break;
default:
numErreur = 666;
break;
}
throw new CustomError(numErreur);
}
catch (Exception Ex) {
throw Ex;
}
return(oList);
}
}
