private void delay_Click(object sender, EventArgs e) { DialogBox db = new DialogBox("Voulez-vous vous prolonger l'emprunt d'un mois ?", "Annuler", "Confirmer"); DialogResult dbrs = db.ShowDialog(); if (dbrs == System.Windows.Forms.DialogResult.OK) { empr.Date_Emprunt = empr.Date_Emprunt.Value.AddMonths(1); music.SaveChanges(); updateFutureReturnDate(); } }
public void addSubscriber() { var newSubscriber = new Abonné { Nom_Abonné = userLastName, Prénom_Abonné = userName, Login = userLogin, Password = userPass, Code_Pays = countryCode }; sqlMusic.Abonné.Add(newSubscriber); sqlMusic.SaveChanges(); }
private void viewBox_SelectedIndexChanged(object sender, EventArgs e) { if (viewBox.SelectedItem != null) { if (inLoan) { Album albm = (Album)viewBox.SelectedItem; var newLoan = new Emprunter { Code_Abonné = Form1.currentSubscriber.Code_Abonné, Code_Album = albm.Code_Album, Date_Emprunt = DateTime.Now }; var existingLoan = (from em in music.Emprunter where em.Code_Abonné == newLoan.Code_Abonné where em.Code_Album == newLoan.Code_Album select em).ToList(); if (existingLoan.Count > 0) { music.Emprunter.Remove(existingLoan.First()); music.SaveChanges(); } music.Emprunter.Add(newLoan); music.SaveChanges(); viewBox.Items.Clear(); viewBox.Items.Add("Album emprunté !"); albumDispo_Click(sender, e); label.ForeColor = Color.DarkGreen; label.Text = "Album emprunté !!!"; timer1.Start(); Cursor.Current = Cursors.Default; } else if (inMyAlbums) { AlbumSetting a = new AlbumSetting((Album)viewBox.SelectedItem); a.ShowDialog(); viewBox.Items.Clear(); button1_Click_1(sender, e); } } else { label.ForeColor = Color.DarkRed; label.Text = "Sélectionnez une oeuvre"; } }
private void deleteAllAlbumsAndSubs(Abonné a, List <Emprunter> rows) { foreach (var deleRow in rows) { music.Emprunter.Remove(deleRow); } music.Abonné.Remove(a); music.SaveChanges(); listBox1.Items.Clear(); listBox2.Items.Clear(); listBox3.Items.Clear(); listBox4.Items.Clear(); yearInactivity(); top10(); tenDaysLate(); AlbumBorrowed(); }