Пример #1
0
        private void updateFutureReturnDate()
        {
            string sql = "select Date_Emprunt from Emprunter " +
                         "where Code_Album = " + albm.Code_Album + " AND Code_Abonné = " + Form1.currentSubscriber.Code_Abonné;

            OleDbCommand    cmd       = new OleDbCommand(sql, dbConnection);
            OleDbDataReader reader    = cmd.ExecuteReader();
            List <Abonné>   activeSub = new List <Abonné>();

            reader.Read();
            DateTime Date_Emprunt = reader.GetDateTime(0);

            empr        = new Emprunter(Form1.currentSubscriber.Code_Abonné, albm.Code_Album, Date_Emprunt, null);
            label1.Text = "À Rendre le : " + empr.Date_Emprunt.AddMonths(1).ToShortDateString();
        }
Пример #2
0
        private void viewBox_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (viewBox.SelectedItem != null)
            {
                if (inLoan)
                {
                    Album  albm    = (Album)viewBox.SelectedItem;
                    var    newLoan = new Emprunter(Form1.currentSubscriber.Code_Abonné, albm.Code_Album, DateTime.Now, null);
                    string sql     = "select * from Emprunter " +
                                     "where Code_Abonné = " + newLoan.Code_Abonné + " AND Code_Album = " + newLoan.Code_Album;
                    OleDbCommand    cmd    = new OleDbCommand(sql, dbConnection);
                    OleDbDataReader reader = cmd.ExecuteReader();
                    reader.Read();
                    if (reader.HasRows)
                    {
                        string       delete  = "delete from Emprunter where Code_Abonné=" + reader.GetInt32(0) + " and Code_Album=" + reader.GetInt32(1);
                        OleDbCommand cmdDele = new OleDbCommand(delete, dbConnection);
                        cmdDele.ExecuteNonQuery();
                    }
                    reader.Close();
                    string       addBorrow    = "insert into Emprunter(Code_Abonné,Code_Album,Date_Emprunt) values (" + Form1.currentSubscriber.Code_Abonné + "," + albm.Code_Album + "," + "GETDATE())";
                    OleDbCommand cmdAddBorrow = new OleDbCommand(addBorrow, dbConnection);
                    cmdAddBorrow.ExecuteNonQuery();
                    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)
                {
                    AlbumSettings a = new AlbumSettings((Album)viewBox.SelectedItem);
                    a.ShowDialog();
                    viewBox.Items.Clear();
                    button1_Click_1(sender, e);
                }
            }
            else
            {
                label.ForeColor = Color.DarkRed;
                label.Text      = "Sélectionnez une oeuvre";
            }
        }