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