public ActionResult DeleteConfirmed(int id)
{
Emprunts emprunts = db.Emprunts.Find(id);
db.Emprunts.Remove(emprunts);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id_emprunt,date_emprunt,statut,Id_membre,Id_Livre,date_retour")] Emprunts emprunts)
{
if (ModelState.IsValid)
{
db.Entry(emprunts).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Id_Livre = new SelectList(db.Livres, "Id_Livre", "titre", emprunts.Id_Livre);
ViewBag.Id_membre = new SelectList(db.Membres, "Id_membre", "IdentiteMembre", emprunts.Id_membre);
return(View(emprunts));
}
public ActionResult Edit([Bind(Include = "idEmprunt,idMembre,idLivre,Date_Emprunt,Date_Retour")] Emprunts emprunts)
{
if (ModelState.IsValid)
{
db.Entry(emprunts).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.idLivre = new SelectList(db.Livres, "idLivre", "ISBN", emprunts.idLivre);
ViewBag.idMembre = new SelectList(db.Membres, "idMembre", "Nom", emprunts.idMembre);
return(View(emprunts));
}
public override void Fill(params System.Object[] references)
{
if (references.Length < 1)
{
return;
}
Guid reference = (Guid)references[0];
if (reference.Equals(Guid.Empty))
{
return;
}
using (new WaitingCursor())
using (IDbCommand cmd = BDDatabase.Database.GetCommand())
{
cmd.CommandText = "SELECT ID_EDITION, ID_Album, e.ID_Editeur, e.ID_Collection, NOMCOLLECTION, ANNEEEDITION, PRIX, VO, COULEUR, ISBN, DEDICACE, PRETE,"
+ "STOCK, Offert, Gratuit, NombreDePages, etat, le.libelle as setat, reliure, lr.libelle as sreliure, orientation, lo.libelle as sorientation,"
+ "FormatEdition, lf.libelle as sFormatEdition, typeedition, lte.libelle as stypeedition, DateAchat, Notes, AnneeCote, PrixCote "
+ "FROM EDITIONS e LEFT JOIN COLLECTIONS c ON e.ID_Collection = c.ID_Collection "
+ "LEFT JOIN LISTES le on (le.ref = e.etat and le.categorie = 1) "
+ "LEFT JOIN LISTES lr on (lr.ref = e.reliure and lr.categorie = 2) "
+ "LEFT JOIN LISTES lte on (lte.ref = e.typeedition and lte.categorie = 3) "
+ "LEFT JOIN LISTES lo on (lo.ref = e.orientation and lo.categorie = 4) "
+ "LEFT JOIN LISTES lf on (lf.ref = e.formatedition and lf.categorie = 5) "
+ "WHERE ID_Edition = ?";
cmd.Parameters.Clear();
cmd.Parameters.Add(BDDatabase.Database.GetParameter("@ID_Edition", StringUtils.GuidToString(reference)));
using (IDataReader result = cmd.ExecuteReader())
using (BaseDataReader <EditionComplet> dataReader = new BaseDataReader <EditionComplet>(result))
if (result != null && result.Read())
{
dataReader.LoadData(this);
Editeur.Fill(dataReader.GetGuid("ID_EDITEUR"));
// Self.Collection.Fill(q);
}
Emprunts.Fill(reference, srcEmprunt.Album);
cmd.CommandText = "SELECT ID_Couverture, FichierCouverture, STOCKAGECOUVERTURE, CategorieImage, l.Libelle as sCategorieImage";
cmd.CommandText += " FROM Couvertures c LEFT JOIN Listes l ON (c.categorieimage = l.ref and l.categorie = 6)";
cmd.CommandText += " WHERE ID_Edition = ? ORDER BY c.categorieimage NULLS FIRST, c.Ordre";
cmd.Parameters.Add(BDDatabase.Database.GetParameter("@ID_Edition", StringUtils.GuidToString(reference)));
using (IDataReader result = cmd.ExecuteReader())
using (BaseDataReader <Couverture> dataReader = new BaseDataReader <Couverture>(result))
if (result != null)
{
dataReader.FillList(fCouvertures);
}
}
}
// GET: /Emprunts/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Emprunts emprunts = db.Emprunts.Find(id);
if (emprunts == null)
{
return(HttpNotFound());
}
return(View(emprunts));
}
// GET: /Emprunts/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Emprunts emprunts = db.Emprunts.Find(id);
if (emprunts == null)
{
return(HttpNotFound());
}
ViewBag.Id_Livre = new SelectList(db.Livres, "Id_Livre", "titre", emprunts.Id_Livre);
ViewBag.Id_membre = new SelectList(db.Membres, "Id_membre", "nom", emprunts.Id_membre);
return(View(emprunts));
}
//....................................................................................
private void Frm_Retour_pret_Load(object sender, EventArgs e)//Démarrage fromulaire
{
listeAdhrents = new Adherents();
listeAdhrents.init();
// Initialisation de le list Emprunt
ListRetourPrêt = new Emprunts();
ListRetourPrêt.init();// Chargement de la list Emprunt
comboBox_Code_Exemplaire.DataSource = ListRetourPrêt;
comboBox_Code_Exemplaire.DisplayMember = "Code Exemplaire";
comboBox_Code_Exemplaire.ValueMember = "NumExemplaire";
comboBox_Code_Exemplaire.Text = "Code Exemplaire";
//dateTimePicker_Date_Prêt = ListRetourPrêt;
button_Lancer_Recherche_Par.Enabled = false;
comboBox_Code_Exemplaire.Focus();
}
//........................................................................................
private void Frm_Gerer_les_prets_Load(object sender, EventArgs e)//Démarrage fromulaire
{
ListEmprunts = new Emprunts();
ListEmprunts.init();
//.................
//ListExemplaire...
//.................
ListExemplaires = new Exemplaires();
ListExemplaires.init();
ListAdherents = new Adherents();
ListAdherents.init();
//...........................
//comboBox_Code_Exemplaire...
//...........................
comboBox_Code_Exemplaire.DataSource = ListExemplaires;
comboBox_Code_Exemplaire.DisplayMember = "Numéro Exemplaire";
comboBox_Code_Exemplaire.ValueMember = "NumeroExemplaire";
comboBox_Code_Exemplaire.Text = "Code exemplaire";
//............................................
//ComboBox Recherhe Avancée Code Exemplaire...
//............................................
comboBox_Recherhe_Avancée_Code_Exemplaire.DataSource = ListExemplaires;
comboBox_Recherhe_Avancée_Code_Exemplaire.DisplayMember = "Numéro Exemplaire";
comboBox_Recherhe_Avancée_Code_Exemplaire.ValueMember = "NumeroExemplaire";
comboBox_Recherhe_Avancée_Code_Exemplaire.Text = "Code exemplaire";
//.................
//ListeAdherents...
//.................
//........................
//comboBox_Num_Adhérent...
//........................
comboBox_Num_Adhérent.DataSource = ListAdherents;
comboBox_Num_Adhérent.DisplayMember = "Num";
comboBox_Num_Adhérent.ValueMember = "NumeroAdherent";
comboBox_Num_Adhérent.Text = "Num";
//........................
//comboBox_Nom_Adhérent...
//........................
comboBox_Nom_Adhérent.DataSource = ListAdherents;
comboBox_Nom_Adhérent.DisplayMember = "nom";
comboBox_Nom_Adhérent.ValueMember = "Nom";
comboBox_Nom_Adhérent.Text = "Nom";
}
