public static void DeleteReservation(int idReservation)
{
try
{
DataLayerLinq.DeleteReservation(idReservation);
}
catch (SqlException sqlex)
{
switch (sqlex.Number)
{
case 4060:
throw new Exception(sqlex.Number + "Mauvaise DB");
break;
case 18456:
throw new Exception(sqlex.Number + "Mauvais user");
break;
case 515:
throw new Exception(sqlex.Number + " : Le prix ne peut être null");
break;
default:
throw new Exception(sqlex.Number + " : " + sqlex.Message);
break;
}
}
catch (Exception)
{
throw new Exception("Une erreur est survenue !");
}
}
public static int?GetIdMenu(int idDetailReservation)
{
try
{
int?valueToReturn = DataLayerLinq.SelectIdMenu(idDetailReservation);
return(valueToReturn);
}
catch (SqlException sqlex)
{
switch (sqlex.Number)
{
case 4060:
throw new Exception(sqlex.Number + "Mauvaise DB");
break;
case 18456:
throw new Exception(sqlex.Number + "Mauvais user");
break;
case 515:
throw new Exception(sqlex.Number + " : Le prix ne peut être null");
break;
default:
throw new Exception(sqlex.Number + " : " + sqlex.Message);
break;
}
}
catch (Exception)
{
throw new Exception("Une erreur est survenue !");
}
}
public static void ModifierDetailReservationMenu(int idReservation, string prenom, int entree, int plat, int dessert, int prix, int idMenu)
{
try
{
DataLayerLinq.UpdateDetailReservationMenu(idReservation, prenom, entree, plat, dessert, prix, idMenu);
}
catch (SqlException sqlex)
{
switch (sqlex.Number)
{
case 4060:
throw new Exception(sqlex.Number + "Mauvaise DB");
break;
case 18456:
throw new Exception(sqlex.Number + "Mauvais user");
break;
case 515:
throw new Exception(sqlex.Number + " : Le prix ne peut être null");
break;
default:
throw new Exception(sqlex.Number + " : " + sqlex.Message);
break;
}
}
catch (Exception)
{
throw new Exception("Une erreur est survenue !");
}
}
public static void AjouteDetailReservation(int idReservation, string prenom, int entree, int plat, int dessert, int prix)
{
try
{
DataLayerLinq.InsertDetailReservation(idReservation, prenom, entree, plat, dessert, prix);
}
catch (SqlException sqlex)
{
switch (sqlex.Number)
{
case 4060:
throw new Exception(sqlex.Number + "Mauvaise DB");
break;
case 18456:
throw new Exception(sqlex.Number + "Mauvais user");
break;
case 515:
throw new Exception(sqlex.Number + " : Le prix ne peut être null");
break;
default:
throw new Exception(sqlex.Number + " : " + sqlex.Message);
break;
}
}
catch (Exception)
{
throw new Exception("Le nom existe déjà !");
}
}
public static void AjouterReservation(string numero, int idTables, DateTime date, string prenom, string nom,
int nombre)
{
try
{
DataLayerLinq.InsertReservation(numero, idTables, date, prenom, nom, nombre);
}
catch (SqlException sqlex)
{
switch (sqlex.Number)
{
case 4060:
throw new Exception(sqlex.Number + "Mauvaise DB");
break;
case 18456:
throw new Exception(sqlex.Number + "Mauvais user");
break;
case 515:
throw new Exception(sqlex.Number + " : Le prix ne peut être null");
break;
default:
throw new Exception(sqlex.Number + " : " + sqlex.Message);
break;
}
}
catch (Exception)
{
throw new Exception("Une erreur est survenue !");
}
}
public static List <ReservationModel> GetListReservation()
{
try
{
var lstToReturn = new List <ReservationModel>();
foreach (var reservation in DataLayerLinq.SelectListReservation())
{
lstToReturn.Add(new ReservationModel
{
idReservation = reservation.idReservation,
numeroReservation = reservation.numeroReservation,
idTable = reservation.idTable,
date = reservation.date,
prenom = reservation.prenom,
nom = reservation.nom,
nbreDePersonnes = reservation.nbreDePersonnes,
prixTotal = reservation.prixTotal,
definitif = reservation.definitif
});
}
return(lstToReturn);
}
catch (SqlException sqlex)
{
switch (sqlex.Number)
{
case 4060:
throw new Exception(sqlex.Number + "Mauvaise DB");
break;
case 18456:
throw new Exception(sqlex.Number + "Mauvais user");
break;
case 515:
throw new Exception(sqlex.Number + " : Le prix ne peut être null");
break;
default:
throw new Exception(sqlex.Number + " : " + sqlex.Message);
break;
}
}
catch (Exception)
{
throw new Exception("Une erreur est survenue !");
}
}
public static List <DetailReservationModel> GetDetailReservation()
{
try
{
var lstToReturn = new List <DetailReservationModel>();
foreach (var detail in DataLayerLinq.SelectDetailReservation())
{
lstToReturn.Add(new DetailReservationModel
{
idDetailReservation = detail.idDetailReservation,
idReservation = detail.idReservation,
prenom = detail.prenom,
entree = detail.entree,
plat = detail.plat,
dessert = detail.dessert,
prixParPersonne = detail.prixParPersonne,
idMenu = detail.idMenu
});
}
return(lstToReturn);
}
catch (SqlException sqlex)
{
switch (sqlex.Number)
{
case 4060:
throw new Exception(sqlex.Number + "Mauvaise DB");
break;
case 18456:
throw new Exception(sqlex.Number + "Mauvais user");
break;
case 515:
throw new Exception(sqlex.Number + " : Le prix ne peut être null");
break;
default:
throw new Exception(sqlex.Number + " : " + sqlex.Message);
break;
}
}
catch (Exception)
{
throw new Exception("Une erreur est survenue !");
}
}
public static List <CarteRestaurantModel> GetCarteRestaurant()
{
try
{
var lstToReturn = new List <CarteRestaurantModel>();
foreach (var carte in DataLayerLinq.SelectCarteRestaurant())
{
lstToReturn.Add(new CarteRestaurantModel
{
idCarteRestaurant = carte.idCarteRestaurant,
idRestaurant = carte.idRestaurant,
idCarteGroupe = carte.idCarteGroupe,
Prix = carte.Prix
});
}
return(lstToReturn);
}
catch (SqlException sqlex)
{
switch (sqlex.Number)
{
case 4060:
throw new Exception(sqlex.Number + "Mauvaise DB");
break;
case 18456:
throw new Exception(sqlex.Number + "Mauvais user");
break;
case 515:
throw new Exception(sqlex.Number + " : Le prix ne peut être null");
break;
default:
throw new Exception(sqlex.Number + " : " + sqlex.Message);
break;
}
}
catch (Exception)
{
throw new Exception("Une erreur est survenue !");
}
}
public static List <TablesChaiseModel> GetTables()
{
try
{
var lstToReturn = new List <TablesChaiseModel>();
foreach (var table in DataLayerLinq.SelectTablesChaise())
{
lstToReturn.Add(new TablesChaiseModel
{
idTables = table.idTables,
idRestaurant = table.idRestaurant,
nbreDePlaces = table.nbreDePlaces
});
}
return(lstToReturn);
}
catch (SqlException sqlex)
{
switch (sqlex.Number)
{
case 4060:
throw new Exception(sqlex.Number + "Mauvaise DB");
break;
case 18456:
throw new Exception(sqlex.Number + "Mauvais user");
break;
case 515:
throw new Exception(sqlex.Number + " : Le prix ne peut être null");
break;
default:
throw new Exception(sqlex.Number + " : " + sqlex.Message);
break;
}
}
catch (Exception)
{
throw new Exception("Une erreur est survenue !");
}
}
public static List <DetailMenuModel> GetDetailMenu()
{
try
{
var lstToReturn = new List <DetailMenuModel>();
foreach (var detailMenu in DataLayerLinq.SelectDetailMenu())
{
lstToReturn.Add(new DetailMenuModel
{
idDetailMenu = detailMenu.idDetailMenu,
idMenu = detailMenu.idMenu,
idCarteRestaurant = detailMenu.idCarteRestaurant
});
}
return(lstToReturn);
}
catch (SqlException sqlex)
{
switch (sqlex.Number)
{
case 4060:
throw new Exception(sqlex.Number + "Mauvaise DB");
break;
case 18456:
throw new Exception(sqlex.Number + "Mauvais user");
break;
case 515:
throw new Exception(sqlex.Number + " : Le prix ne peut être null");
break;
default:
throw new Exception(sqlex.Number + " : " + sqlex.Message);
break;
}
}
catch (Exception)
{
throw new Exception("Une erreur est survenue !");
}
}
public static List <AllRestaurantModel> GetAllRestaurant()
{
try
{
var lstToReturn = new List <AllRestaurantModel>();
foreach (var restaurant in DataLayerLinq.SelectAllRestaurants())
{
lstToReturn.Add(new AllRestaurantModel
{
idRestaurants = restaurant.idRestaurants,
RESTO = restaurant.RESTO
});
}
return(lstToReturn);
}
catch (SqlException sqlex)
{
switch (sqlex.Number)
{
case 4060:
throw new Exception(sqlex.Number + "Mauvaise DB");
break;
case 18456:
throw new Exception(sqlex.Number + "Mauvais user");
break;
case 515:
throw new Exception(sqlex.Number + " : Le prix ne peut être null");
break;
default:
throw new Exception(sqlex.Number + " : " + sqlex.Message);
break;
}
}
catch (Exception)
{
throw new Exception("Une erreur est survenue !");
}
}
