public static void InsertReservations(string nomLivre, string UserName) { using (bibliothequeEntities dbcontext = new bibliothequeEntities()) { try { dbcontext.InsertReservations(nomLivre, UserName); } catch (SqlException exSQL) { int IdError = 999; switch (exSQL.Number) { case 18456: IdError = 1; break; } throw new BusinessError.CustomError(IdError); } catch (Exception ex) { int IdError = 999; throw new BusinessError.CustomError(IdError); } } }
public static List <RetardsUsers> LoadAllRetardEF(string userName) { List <RetardsUsers> myList = new List <RetardsUsers>(); using (bibliothequeEntities dbcontext = new bibliothequeEntities()) { List <Exemplaire_SelectAllRetardsUsers_Result> maliste = dbcontext.Exemplaire_SelectAllRetardsUsers(userName).ToList(); foreach (var item in maliste) { RetardsUsers user = new RetardsUsers() { NomLecteur = item.nom, solde = Convert.ToDecimal(item.solde), tarifParJour = item.tarifParJours, date_emprunt = Convert.ToDateTime(item.date_emprunt), date_retour = Convert.ToDateTime(item.dateRetour), NbrMoisAuto = item.NbrMoisAutorisé, Titre = item.code }; myList.Add(user); } } return(myList); }
public static List <int?> NbreEmpruntAnnexePrincipal(string user) { List <int?> mylist = new List <int?>(); using (bibliothequeEntities context = new bibliothequeEntities()) { List <int?> mylistresult = context.Principal_Annexe(user).ToList(); mylist = mylistresult; } return(mylist); }
public static List <int?> LoadCountRetardUserEF(string userName) { List <int?> myList = new List <int?>(); using (bibliothequeEntities dbcontext = new bibliothequeEntities()) { List <int?> maliste = dbcontext.Exemplaire_AllRetardsUser(userName).ToList(); foreach (var item in maliste) { myList.Add(item.Value); } } return(myList); }
public static DataSet LoadReservationEF(string nomBiblio, string userName) { DataTable table = new DataTable(); // Declare DataColumn and DataRow variables. DataColumn column; DataRow row; column = new DataColumn(); column.DataType = System.Type.GetType("System.Int32"); column.ColumnName = "id"; table.Columns.Add(column); // Create second column. column = new DataColumn(); column.DataType = Type.GetType("System.String"); column.ColumnName = "titre"; table.Columns.Add(column); DataSet ds = new DataSet(); ds.Tables.Add(table); using (bibliothequeEntities dbcontext = new bibliothequeEntities()) { List <User_ReservationParBiblio_Select_Result> maliste = dbcontext.User_ReservationParBiblio_Select(nomBiblio, userName).ToList(); var x = from p in maliste select new Reservation { livreTitle = p.nom, }; foreach (var item in x) { row = table.NewRow(); row["id"] = item.idLivre; row["titre"] = item.livreTitle; ds.Tables[0].Rows.Add(row); } } return(ds); }
public static List <int?> LoadCountExemplaireBiblio(string biblio, string livre) { List <int?> mylist = new List <int?>(); using (bibliothequeEntities dbcontext = new bibliothequeEntities()) { List <VerifieSiDispo_Result> maliste = dbcontext.VerifieSiDispo(biblio, livre).ToList(); foreach (var item in maliste) { mylist.Add(item.NbreDispoNow); } } return(mylist); }
public static List <BusinessEntity.Biblio> LoadMAjorLibrary(string user) { List <BusinessEntity.Biblio> myList = new List <BusinessEntity.Biblio>(); using (bibliothequeEntities dbcontext = new bibliothequeEntities()) { foreach (var item in dbcontext.Select_BiblioPrincipale(user).ToList()) { BusinessEntity.Biblio biblio = new BusinessEntity.Biblio() { // code=item.Code, libellé = item, //id=item.id }; myList.Add(biblio); } } return(myList); }
//elle charge les reservations par user et non les retards //testing entity that was the purpose public static List <Reservation> LoadAllReservationEF(string nomBiblio, string userName) { List <Reservation> malisteReservation = new List <Reservation>(); using (bibliothequeEntities dbcontext = new bibliothequeEntities()) { List <User_ReservationParBiblio_Select_Result> maliste = dbcontext.User_ReservationParBiblio_Select(nomBiblio, userName).ToList(); var x = from p in maliste select new Reservation { livreTitle = p.code, }; foreach (var item in x) { malisteReservation.Add(item); } } return(malisteReservation); }
public static string getImageEF(string titre) { using (bibliothequeEntities dbcontext = new bibliothequeEntities()) { try { var url = dbcontext.GetImage(titre).FirstOrDefault();; return(url); } catch (SqlException exSQL) { //roll back avant n'importe quel traitement //après on renvoie l'erreur business,... //oTrans.Rollback(); int IdError = 999; switch (exSQL.Number) { case 18456: IdError = 1; break; case 8152: IdError = 5; break; case 515: IdError = 5; break; case 50000: IdError = 13; break; } throw new BusinessError.CustomError(IdError); } catch (Exception ex) { throw new BusinessError.CustomError(6); } } }
public static void InsertEmpruntEF(string titre, string nom, DateTime?dtRetour, decimal prixEmprunt, string biblio) { using (bibliothequeEntities dbcontext = new bibliothequeEntities()) { try { dbcontext.CustomEmprunt_Create(prixEmprunt, titre, nom, biblio, dtRetour); } catch (SqlException exSQL) { //roll back avant n'importe quel traitement //après on renvoie l'erreur business,... //oTrans.Rollback(); int IdError = 999; switch (exSQL.Number) { case 18456: IdError = 1; break; case 8152: IdError = 5; break; case 515: IdError = 5; break; case 50000: IdError = 13; break; } throw new BusinessError.CustomError(IdError); } catch (Exception ex) { throw ex.InnerException; throw new BusinessError.CustomError(6); } } }
public static List <BusinessEntity.Biblio> LoadAllLibrary() { List <BusinessEntity.Biblio> myList = new List <BusinessEntity.Biblio>(); using (bibliothequeEntities dbcontext = new bibliothequeEntities()) { List <SelectAll_Biblio_Result> maliste = dbcontext.SelectAll_Biblio().ToList(); foreach (var item in maliste) { BusinessEntity.Biblio biblio = new BusinessEntity.Biblio() { // code=item.Code, libellé = item.libellé, //id=item.id }; myList.Add(biblio); } } return(myList); }
public static List <BusinessEntity.ExemplairesLecteurs> LoadAllCopy(string biblio) { List <BusinessEntity.ExemplairesLecteurs> myList = new List <BusinessEntity.ExemplairesLecteurs>(); using (bibliothequeEntities dbcontext = new bibliothequeEntities()) { List <Exemplaire_Biblio_SelectAll_Result> maliste = dbcontext.Exemplaire_Biblio_SelectAll(biblio).ToList(); foreach (var item in maliste) { BusinessEntity.ExemplairesLecteurs exam = new BusinessEntity.ExemplairesLecteurs() { code = item.code, IdExemplaire = item.idExemplaire, auteur = item.auteur, }; myList.Add(exam); } } return(myList); }
public static List <BusinessEntity.Lecteur> loadAllLecteurs(string userName, string pass, string biblio) { List <BusinessEntity.Lecteur> myList = new List <BusinessEntity.Lecteur>(); using (bibliothequeEntities dbcontext = new bibliothequeEntities()) { List <CheckingUser_Result> maliste = dbcontext.CheckingUser(userName, pass, biblio).ToList(); foreach (var item in maliste) { BusinessEntity.Lecteur user = new BusinessEntity.Lecteur() { biblioPrincipale = item.libellé, UserName = item.nom, password = item.motPassword, }; myList.Add(user); } } return(myList); }
public static List <GeneralReservation> LoadAllReservationEF(string userName) { List <GeneralReservation> malisteReservation = new List <GeneralReservation>(); using (bibliothequeEntities dbcontext = new bibliothequeEntities()) { List <NbreExemplaireParBiblio_SelectAll_Result> maliste = dbcontext.NbreExemplaireParBiblio_SelectAll(userName).ToList(); var x = from p in maliste select new GeneralReservation { biblio = p.biblio, NbrExemplaireDispo = p.NbreDispoNow, livreTitle = p.titre }; foreach (var item in x) { malisteReservation.Add(item); } } return(malisteReservation); }