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