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