/// <summary> /// Récupère un lecteur par ses prénoms et noms. /// </summary> /// <param name="firstName"></param> /// <param name="lastName"></param> /// <param name="AffToFill"></param> public static void GetAffiliateByName(string firstName, string lastName, ref Affiliate AffToFill) { StringBuilder sLog = new StringBuilder(); using (ExamSGBD2017Entities dbEntity = new ExamSGBD2017Entities()) { try { Affiliate convertedAff = new Affiliate(); var vAff = dbEntity.GetAffiliateByName(firstName, lastName).FirstOrDefault(); convertedAff.CardNum = vAff.CardNum; convertedAff.CardValidity = vAff.Validity; convertedAff.MainLibraryId = vAff.MainLibrary_Id; convertedAff.LastName = vAff.LastName; convertedAff.FirstName = vAff.FirstName; convertedAff.BirthDate = vAff.BirthDate; AffToFill = convertedAff; } catch (Exception ex) { int DefaultError = 7; //"Problème à la récupération des données !" throw new EL.CstmError(DefaultError, ex); } } }
public static void GetAllVolumes(ref List <Volume> listToReturn) { StringBuilder sLog = new StringBuilder(); listToReturn.Clear(); using (ExamSGBD2017Entities dbEntity = new ExamSGBD2017Entities()) { try { foreach (var vvolume in dbEntity.vVolumes) { Volume convertedVol = new Volume(); convertedVol.Id = vvolume.Id; convertedVol.Isbn = vvolume.Isbn; convertedVol.Title = vvolume.Title; convertedVol.Cover = vvolume.Cover; convertedVol.Authors = DalAuthor.GetAllAuthorsNames(vvolume.Isbn); listToReturn.Add((convertedVol)); } } catch (Exception ex) { int DefaultError = 7; //"Problème à la récupération des données !" throw new EL.CstmError(DefaultError, ex); } } }
/// <summary> /// Retourne un volume par son ISBN. /// </summary> /// <param name="VolumeIsbn"></param> /// <param name="VolToFill"></param> public static void GetVolumeByIsbn(string VolumeIsbn, ref Volume VolToFill) { StringBuilder sLog = new StringBuilder(); using (ExamSGBD2017Entities dbEntity = new ExamSGBD2017Entities()) { try { Volume convertedVol = new Volume(); var vvolume = dbEntity.GetVolumeByIsbn(VolumeIsbn).FirstOrDefault(); convertedVol.Id = vvolume.Id; convertedVol.Isbn = vvolume.Isbn; convertedVol.Title = vvolume.Title; convertedVol.Cover = vvolume.Cover; convertedVol.Authors = DalAuthor.GetAllAuthorsNames(vvolume.Isbn); VolToFill = convertedVol; } catch (Exception ex) { int DefaultError = 7; //"Problème à la récupération des données !" throw new EL.CstmError(DefaultError, ex); } } }
/// <summary> /// Retourne la liste des volumes souhaités par le lecteur. /// </summary> /// <param name="cardNum"></param> /// <param name="listToReturn"></param> public static void GetWishListByCardNum(int cardNum, ref List <WishListItem> listToReturn) { StringBuilder sLog = new StringBuilder(); listToReturn.Clear(); using (ExamSGBD2017Entities dbEntity = new ExamSGBD2017Entities()) { try { foreach (GetWishlist_Result vWish in dbEntity.GetWishlist(cardNum)) { WishListItem wishListItem = new WishListItem(); wishListItem.Id = vWish.Id; wishListItem.CardNum = vWish.CardNum; wishListItem.Volume_Id = vWish.Volume_Id; wishListItem.Isbn = vWish.Isbn; // wishListItem.Title = vWish. ; wishListItem.Cover = vWish.Cover; listToReturn.Add((wishListItem)); } } catch (Exception ex) { int DefaultError = 7; //"Problème à la récupération des données !" throw new EL.CstmError(DefaultError, ex); } } }
/// <summary> /// Retourne la liste de toutes les librairies. /// </summary> /// <param name="listToReturn"></param> public static void GetAllLibraries(ref List <Library> listToReturn) { StringBuilder sLog = new StringBuilder(); listToReturn.Clear(); using (ExamSGBD2017Entities dbEntity = new ExamSGBD2017Entities()) { try { foreach (GetLibraries_Result vlib in dbEntity.GetLibraries().ToList()) { Library convertedLib = new Library(); convertedLib.Id = vlib.IdLibrary; convertedLib.Code = vlib.CodeIdLibrary; convertedLib.Name = vlib.NameLibrary; listToReturn.Add((convertedLib)); } } catch (Exception ex) { int DefaultError = 7; //"Problème à la récupération des données !" throw new EL.CstmError(DefaultError, ex); } } }
/// <summary> /// Insère un nouvel emprunt. /// La date de départ est crée dans la base de données. /// Supprime un éventuel wish item correspondant à cet exemplaire. /// (Transaction) /// </summary> /// <param name="CardNum"></param> /// <param name="Item_Id"></param> /// <param name="Tarif_Id"></param> public static void InsertEmprunt(int cardNum, int item_Id, int volume_Id, int tarif_Id) { StringBuilder sLog = new StringBuilder(); try { using (ExamSGBD2017Entities dbEntity = new ExamSGBD2017Entities()) { using (TransactionScope ts = new TransactionScope()) { dbEntity.InsertEmprunt(cardNum, item_Id, tarif_Id); foreach (var wishes in dbEntity.GetWishlist(cardNum).Where(w => w.Volume_Id == volume_Id)) { dbEntity.DeleteWishById(wishes.Id); ts.Complete(); } } } } catch (Exception ex) { int DefaultError = 12; //" Un problème est survenu à l'ajout !" throw new EL.CstmError(DefaultError, ex); } }
public static void GetItemsByVOlume(int volumeId, ref List <Item> listToReturn) { StringBuilder sLog = new StringBuilder(); listToReturn.Clear(); using (ExamSGBD2017Entities dbEntity = new ExamSGBD2017Entities()) { try { foreach (GetItemByVol_Result vItem in dbEntity.GetItemByVol(volumeId)) //vEmpruntDetail { Item itemToReturn = new Item(); itemToReturn.Id = vItem.Id; itemToReturn.LibraryId = vItem.Library_Id; itemToReturn.VolumeId = vItem.Volume_Id; itemToReturn.Code = vItem.Code; itemToReturn.BuyDate = (DateTime)vItem.BuyDate; itemToReturn.Localisation = vItem.Localisation; listToReturn.Add((itemToReturn)); } } catch (Exception ex) { int DefaultError = 7; //"Problème à la récupération des données !" throw new EL.CstmError(DefaultError, ex); } } }
/// <summary> /// retourne les tarifs d'une librairie. /// </summary> /// <param name="libId"></param> /// <param name="listToReturn"></param> public static void GetTarifByLib(int libId, ref List <Tarif> listToReturn) { StringBuilder sLog = new StringBuilder(); listToReturn.Clear(); using (ExamSGBD2017Entities dbEntity = new ExamSGBD2017Entities()) { try { foreach (GetTarifByLibId_Result _vTarif in dbEntity.GetTarifByLibId(libId)) { Tarif _tarif = new Tarif(); _tarif.Id = _vTarif.Id; _tarif.DailyPenalty = _vTarif.DailyPenalty; _tarif.Duration = _vTarif.Duration; _tarif.Fee = _vTarif.Fee; _tarif.LibraryId = _vTarif.Library_Id; _tarif.Name = _vTarif.Name; _tarif.Year = _vTarif.Year; listToReturn.Add((_tarif)); } } catch (Exception ex) { int DefaultError = 7; //"Problème à la récupération des données !" throw new EL.CstmError(DefaultError, ex); } } }
public static List <Author> GetAllAuthorsNames(string isbn) { StringBuilder sLog = new StringBuilder(); List <Author> listToReturn = new List <Author>(); using (ExamSGBD2017Entities dbEntity = new ExamSGBD2017Entities()) { try { foreach (var author in dbEntity.GetAuthorByVolumeIsbn(isbn).ToList()) { Author convertedAuthor = new Author(); convertedAuthor.PersId = author.Pers_Id; convertedAuthor.FirstName = author.FirstName; convertedAuthor.LastName = author.LastName; listToReturn.Add((convertedAuthor)); } return(listToReturn); } catch (Exception ex) { int DefaultError = 7; //"Problème à la récupération des données !" throw new EL.CstmError(DefaultError, ex); } } }
/// <summary> /// Suppresion d'un volume de la wishlist. /// </summary> /// <param name="WishId"></param> public static void DeleteWishListItem(int WishId) { StringBuilder sLog = new StringBuilder(); try { using (ExamSGBD2017Entities dbEntity = new ExamSGBD2017Entities()) { dbEntity.DeleteWishById(WishId); } } catch (Exception ex) { int DefaultError = 10; //" Un problème est survenu à la modification des données !" throw new EL.CstmError(DefaultError, ex); } }
/// <summary> /// Ajout d'une "réservation" dans la wishlist. /// </summary> /// <param name="cardNum"></param> /// <param name="volumeId"></param> public static void AddWishListItem(int cardNum, int volumeId) { StringBuilder sLog = new StringBuilder(); try { using (ExamSGBD2017Entities dbEntity = new ExamSGBD2017Entities()) { dbEntity.InsertWish(cardNum, volumeId); } } catch (Exception ex) { int DefaultError = 12; //" Un problème est survenu à l'ajout !" throw new EL.CstmError(DefaultError, ex); } }
/// <summary> /// retourne les emprunts du lecteur. /// Sous forme de liste d'objets Emprunt. /// </summary> /// <param name="cardNum"></param> /// <param name="listToReturn"></param> public static void GetEmpruntsByCardNum(int cardNum, bool SelectClosed, ref List <Emprunt> listToReturn) { StringBuilder sLog = new StringBuilder(); listToReturn.Clear(); using (ExamSGBD2017Entities dbEntity = new ExamSGBD2017Entities()) { try { foreach (GetEmpruntByAffiliate_Result vEmprunt in dbEntity.GetEmpruntByAffiliate(cardNum, SelectClosed)) //vEmpruntDetail { Emprunt convertedEmprunt = new Emprunt(); convertedEmprunt.Id = vEmprunt.IdEmprunt; convertedEmprunt.CardNum = vEmprunt.CardNum; convertedEmprunt.LibraryId = vEmprunt.Library_Id; convertedEmprunt.LibraryName = vEmprunt.NameLibrary; convertedEmprunt.VolumeTitle = vEmprunt.Title; convertedEmprunt.ItemCode = vEmprunt.Code; convertedEmprunt.ItemId = vEmprunt.Item_Id; convertedEmprunt.TarifName = vEmprunt.NameTarif; convertedEmprunt.Fee = vEmprunt.Fee; convertedEmprunt.DailyPenalty = vEmprunt.DailyPenalty; convertedEmprunt.Duration = vEmprunt.Duration; convertedEmprunt.StartDate = vEmprunt.StartDate; convertedEmprunt.ReturnDte = vEmprunt.ReturnDate ?? DateTime.Now; convertedEmprunt.LastModified = vEmprunt.LastModified ?? DateTime.Now; // convertedEmprunt.Isbn = vEmprunt.; // convertedEmprunt.Cover = vEmprunt.; // convertedEmprunt.Authors = DalAuthor.GetAllAuthorsNames(vEmprunt.); listToReturn.Add((convertedEmprunt)); } } catch (Exception ex) { int DefaultError = 7; //"Problème à la récupération des données !" throw new EL.CstmError(DefaultError, ex); } } }