public List<LivreBO> SelectByBibliotheque(String token, BibliothequeBO pBibliotheque) { if (!Autorization.Validate(token, Autorization.Role.CLIENT)) { return null; } try { return LivreBL.SelectByBibliotheque(pBibliotheque); } catch (Exception ex) { throw; } }
public static List<AdministrateurBibliothequeBO> ByBibliotheque(BibliothequeBO pObjBibliotheque) { List<AdministrateurBibliothequeBO> administrateurBibliothequeResult; try { using (var proxyAdministrateurBibliotheque = new AdministrateurBibliothequeDAL(Util.GetConnection())) { administrateurBibliothequeResult = proxyAdministrateurBibliotheque.AministrateurBibliothequeDAL_SelectByBiblioId(pObjBibliotheque.BibliothequeId).ToList(); } } catch (Exception ex) { throw; } return administrateurBibliothequeResult; }
public static List<LivreBO> SelectByBibliotheque(BibliothequeBO pBibliotheque) { List<LivreBO> result; try { using (var livreProxy = new LivreDAL(Util.GetConnection())) { result = livreProxy.LivreDAL_SelectByBibliothequeId(pBibliotheque.BibliothequeId).ToList(); if (result.Count > 0) { foreach (var oLivreBo in result) { oLivreBo.RefLivre = RefLivreBL.SelectById(oLivreBo.RefLivreId); oLivreBo.Bibliotheque = BibliothequeBL.SelectById(oLivreBo.BibliothequeId); } } } } catch (Exception ex) { throw; } return result; }
private static string StatDemandeReservation(IEnumerable<BibliothequeBO> lstBibliotheque, BibliothequeBO objActualBibliotheque) { // Demande de réservation var lstReservation = CGlobalCache.LstDemandeReservationSelectAll; String demandeReservationAll = "", demandeReservationManaged = "", demandeReservationBibliotheque = ""; demandeReservationAll += "Toutes les demandes de réservation: " + lstReservation.Count(xx => xx.Valide == 1).ToString(CultureInfo.InvariantCulture); var grpAllBibliotheque = lstReservation.Where(condition => condition.Valide == 1).GroupBy(xx => xx.Client.BibliothequeId).Select(group => new { bibliothequeId = group.Key, Count = group.Count() }).ToList(); var query = lstBibliotheque.Join(grpAllBibliotheque, myBiblio => myBiblio.BibliothequeId, allBiblio => allBiblio.bibliothequeId, (biblio1, biblio2) => new { biblioId = biblio1.BibliothequeId, biblio2.Count }); demandeReservationManaged += string.Format("dans vos bibliothèques: {0}", query.Sum(result => result.Count)); if (objActualBibliotheque != null) { //var lstOldReservation = CGlobalCache.LstOldDemandeReservationByClient; //var grpAllOldBibliotheque = lstOldReservation.Where(condition => condition.Valide == 1).GroupBy(xx => xx.Client.BibliothequeId).Select(group => new { bibliothequeId = group.Key, Count = group.Count() }); var newReservation = grpAllBibliotheque.FirstOrDefault(xx => xx.bibliothequeId == objActualBibliotheque.BibliothequeId); //var oldReservation = grpAllOldBibliotheque.FirstOrDefault(xx => xx.bibliothequeId == objActualBibliotheque.BibliothequeId); demandeReservationBibliotheque += "dans la bibliothèque " + objActualBibliotheque.BibliothequeName + ": " + ((newReservation != null)?newReservation.Count : 0).ToString(CultureInfo.InvariantCulture); //demandeReservationBibliothequeDepasse += "dépassée dans la bibliothèque " + objActualBibliotheque.BibliothequeName + ": " + ((oldReservation != null)?oldReservation.Count : 0).ToString(CultureInfo.InvariantCulture); } else { demandeReservationBibliotheque += "Vous n'avez pas choisi de bibliothèque à gérer"; } return String.Format("{0}\n{1}\n{2}\n", demandeReservationAll, demandeReservationManaged, demandeReservationBibliotheque); }
private static string StatReservation(IEnumerable<BibliothequeBO> lstBibliotheque, BibliothequeBO objActualBibliotheque) { // Réservation String reservationAll = "", reservationManagedValid = "", reservationManagedUnValid = "", reservationBibliothequeValid = "", reservationBibliothequeUnValid = ""; var lstEmprunt = CGlobalCache.LstEmpruntSelectAll; var bibliothequeBos = lstBibliotheque as IList<BibliothequeBO> ?? lstBibliotheque.ToList(); var maxActionId = lstEmprunt.GroupBy(xx => xx.LivreId).Select(dd => new{LivreId = dd.Key, ActionId = dd.Max(qq => qq.ActionId)}); var clientEmpruntEnCours = maxActionId.Select(dataInMaxActionResult => CGlobalCache.LstEmpruntSelectAll.ToList().Find(xx => xx.ActionId == dataInMaxActionResult.ActionId && xx.LivreId == dataInMaxActionResult.LivreId)).Where(result => result != null && result.State == "res").ToList(); reservationAll += "Toutes les réservations: " + clientEmpruntEnCours.Count.ToString(CultureInfo.InvariantCulture); var grpAllBibliothequeValid = clientEmpruntEnCours.FindAll(xx => (DateTime.Now - xx.CreatedAt).Days <= 15).GroupBy(xx => xx.Livre.BibliothequeId).Select(group => new { bibliothequeId = group.Key, Count = group.Count() }).ToList(); var queryValid = bibliothequeBos.Join(grpAllBibliothequeValid, myBiblio => myBiblio.BibliothequeId, allBiblio => allBiblio.bibliothequeId, (biblio1, biblio2) => new { biblioId = biblio1.BibliothequeId, biblio2.Count }); var grpAllBibliothequeUnValid = clientEmpruntEnCours.FindAll(xx => (DateTime.Now - xx.CreatedAt).Days > 15).GroupBy(xx => xx.Livre.BibliothequeId).Select(group => new { bibliothequeId = group.Key, Count = group.Count() }).ToList(); var queryUnValid = bibliothequeBos.Join(grpAllBibliothequeUnValid, myBiblio => myBiblio.BibliothequeId, allBiblio => allBiblio.bibliothequeId, (biblio1, biblio2) => new { biblioId = biblio1.BibliothequeId, biblio2.Count }); reservationManagedValid += string.Format("dans vos bibliothèques: {0}", queryValid.Sum(result => result.Count)); reservationManagedUnValid += string.Format("dans vos bibliothèques: {0}", queryUnValid.Sum(result => result.Count)); if (objActualBibliotheque != null) { var resultValid = grpAllBibliothequeValid.FirstOrDefault(xx =>xx.bibliothequeId == objActualBibliotheque.BibliothequeId); reservationBibliothequeValid += String.Format("dans la bibliothèque {0}: {1}", objActualBibliotheque.BibliothequeName, ((resultValid != null)?resultValid.Count : 0).ToString(CultureInfo.InvariantCulture)); var resultUnValid = grpAllBibliothequeUnValid.FirstOrDefault(xx =>xx.bibliothequeId == objActualBibliotheque.BibliothequeId); reservationBibliothequeUnValid += String.Format("dans la bibliothèque {0}: {1}", objActualBibliotheque.BibliothequeName, ((resultUnValid != null)?resultUnValid.Count : 0).ToString(CultureInfo.InvariantCulture)); } else { reservationBibliothequeValid += "Vous n'avez pas choisi de bibliothèque à gérer"; reservationBibliothequeUnValid += "Vous n'avez pas choisi de bibliothèque à gérer"; } return String.Format("{0}\n\nValide:\n{1}\n{2}\n\nHors délais:\n{3}\n{4}\n",reservationAll, reservationManagedValid, reservationBibliothequeValid, reservationManagedUnValid, reservationBibliothequeUnValid); }
private static string StatRefLivre(IEnumerable<BibliothequeBO> lstBibliotheque, BibliothequeBO objActualBibliotheque) { // Référence de livre var lstLivre = CGlobalCache.LstLivreSelectAll; String refLivreAll = "", refLivreManaged = "", refLivreBibliotheque = ""; var reflivreUniq = lstLivre.GroupBy(xx => xx.RefLivreId).Select(grp => grp.First()).ToList(); refLivreAll += "Toutes les références: " + reflivreUniq.Count().ToString(CultureInfo.InvariantCulture); var grpAllBibliotheque = reflivreUniq.GroupBy(yy => yy.BibliothequeId).Select(grp => new { bibliothequeId = grp.Key, Count = grp.Count() }).ToList(); var query = lstBibliotheque.Join(grpAllBibliotheque, myBiblio => myBiblio.BibliothequeId, allBiblio => allBiblio.bibliothequeId, (biblio1, biblio2) => new { biblioId = biblio1.BibliothequeId, biblio2.Count }); refLivreManaged += string.Format("dans vos bibliothèques: {0}", query.Sum(result => result.Count)); if (objActualBibliotheque != null) { var result = grpAllBibliotheque.FirstOrDefault(xx => xx.bibliothequeId == objActualBibliotheque.BibliothequeId); refLivreBibliotheque += "dans la bibliothèque " + objActualBibliotheque.BibliothequeName + ": " + ((result != null)?result.Count : 0).ToString(CultureInfo.InvariantCulture) ; } else { refLivreBibliotheque += "Vous n'avez pas choisi de bibliothèque à gérer"; } return refLivreAll + "\n" + refLivreManaged + "\n" + refLivreBibliotheque + "\n"; }
private static String StatLivre(IEnumerable<BibliothequeBO> lstBibliotheque, BibliothequeBO objActualBibliotheque) { // Livre var lstLivre = CGlobalCache.LstLivreSelectAll; String livreAll = "", livreManaged = "", livreBibliotheque = ""; livreAll += "Tous les livres disponibles: " + lstLivre.Count.ToString(CultureInfo.InvariantCulture); var grpAllBibliotheque = lstLivre.GroupBy(xx => xx.BibliothequeId).Select(group => new { bibliothequeId = group.Key, Count = group.Count() }).ToList(); var query = lstBibliotheque.Join(grpAllBibliotheque, myBiblio => myBiblio.BibliothequeId, allBiblio => allBiblio.bibliothequeId, (biblio1, biblio2) => new { biblioId = biblio1.BibliothequeId, biblio2.Count }); livreManaged += string.Format("dans vos bibliothèques: {0}", query.Sum(result => result.Count)); if (objActualBibliotheque != null) { var result = grpAllBibliotheque.FirstOrDefault(xx =>xx.bibliothequeId == objActualBibliotheque.BibliothequeId); livreBibliotheque += "dans la bibliothèque " + objActualBibliotheque.BibliothequeName + ": " + ((result != null)?result.Count : 0).ToString(CultureInfo.InvariantCulture) ; } else { livreBibliotheque += "Vous n'avez pas choisi de bibliothèque à gérer"; } return String.Format("{0}\n{1}\n{2}\n", livreAll, livreManaged, livreBibliotheque); }
private static string StatItem(BibliothequeBO objActualBibliotheque) { var lstItem = CGlobalCache.LstItemSelectByAministrateurId; String refItemManaged = "", refItemBibliotheque = ""; var lstItemTotal = lstItem.GroupBy(xx => xx.AdministrateurId).Select(yy => new {yy.Key, Count = yy.Sum(d => d.Montant)}).ToList(); var firstOrDefault = lstItemTotal.FirstOrDefault(xx => true); refItemManaged += string.Format("dans vos bibliothèques: {0:C}", ((null == firstOrDefault) ? 0 : firstOrDefault.Count)); if (objActualBibliotheque != null) { var lstItemByBibliotheque = lstItem.GroupBy(xx => xx.Livre.BibliothequeId).Select(yy => new{yy.Key, Count = yy.Sum(d => d.Montant)}); var result = lstItemByBibliotheque.FirstOrDefault(xx => xx.Key == objActualBibliotheque.BibliothequeId); refItemBibliotheque += String.Format("dans la bibliothèque {0}: {1:C}", objActualBibliotheque.BibliothequeName, ((null == result)? 0 : result.Count)); } else { refItemBibliotheque += "Vous n'avez pas choisi de bibliothèque à gérer"; } return refItemManaged + "\n" + refItemBibliotheque + "\n"; }
private static string StatEmprunt(IEnumerable<BibliothequeBO> lstBibliotheque, BibliothequeBO objActualBibliotheque) { // Réservation var lstEmprunt = CGlobalCache.LstEmpruntSelectAll; var maxActionId = lstEmprunt.GroupBy(xx => xx.LivreId).Select(dd => new{LivreId = dd.Key, ActionId = dd.Max(qq => qq.ActionId)}); var clientEmpruntEnCours = maxActionId.Select(dataInMaxActionResult => CGlobalCache.LstEmpruntSelectAll.ToList().Find(xx => xx.ActionId == dataInMaxActionResult.ActionId && xx.LivreId == dataInMaxActionResult.LivreId)).Where(result => result != null && result.State == "emp").ToList(); String empruntAll = "", empruntManaged = "", empruntBibliotheque = ""; empruntAll += "Tous les emprunts: " + clientEmpruntEnCours.Count.ToString(CultureInfo.InvariantCulture); var grpAllBibliotheque = clientEmpruntEnCours.GroupBy(xx => xx.Livre.BibliothequeId).Select(group => new { bibliothequeId = group.Key, Count = group.Count() }).ToList(); var query = lstBibliotheque.Join(grpAllBibliotheque, myBiblio => myBiblio.BibliothequeId, allBiblio => allBiblio.bibliothequeId, (biblio1, biblio2) => new { biblioId = biblio1.BibliothequeId, biblio2.Count }); empruntManaged += string.Format("dans vos bibliothèques: {0}", query.Sum(result => result.Count)); if (objActualBibliotheque != null) { var result = grpAllBibliotheque.FirstOrDefault(xx =>xx.bibliothequeId == objActualBibliotheque.BibliothequeId); empruntBibliotheque += "dans la bibliothèque " + objActualBibliotheque.BibliothequeName + ": " + ((result != null)?result.Count : 0).ToString(CultureInfo.InvariantCulture) ; } else { empruntBibliotheque += "Vous n'avez pas choisi de bibliothèque à gérer"; } return empruntAll + "\n" + empruntManaged + "\n" + empruntBibliotheque + "\n"; }