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