コード例 #1
0
        private void borrowButton_Click(object sender, EventArgs e)
        {
            try
            {
                if (mediaLogic.ListBorrow(media.MediaId).Count <= 0)
                {
                    DateTime todayDate  = DateTime.Today;
                    string   todaysDate = todayDate.ToString("dd/MM/yyyy");                                                             //change this according to the computers date layout either dd/MM/yyyy or MM/dd/yyyy
                    DateTime expDate    = todayDate.AddDays(30);
                    string   expiryDate = expDate.ToString("dd/MM/yyyy");                                                               //change this according to the computers date layout either dd/MM/yyyy or MM/dd/yyyy

                    int affectedRows = mediaLogic.InsertBorrow(CurrentUser.UserID, media.MediaId, todaysDate, expiryDate);
                    MessageBox.Show("You have borrowed " + media.MediaName);

                    //NEED  CONDITION TO DELETE RESERVE
                    int affectedRows2 = mediaLogic.DeleteReserveOnReturn(media.MediaId);
                }
                else
                {
                    MessageBox.Show(media.MediaName + " is already borrowed");
                }

                returnComboBox.DataSource    = mediaLogic.ListReturn(CurrentUser.UserID);
                returnComboBox.DisplayMember = "PairName";
                returnComboBox.ValueMember   = "PairId";

                RefreshUserList();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Please select a media");
            }
        }
コード例 #2
0
        //BORROW BUTTON 25-05-2017
        private void borrowButton_Click(object sender, EventArgs e)
        {
            if (mediaLogic.ListBorrow(media.MediaId).Count <= 0)
            {
                DateTime todayDate    = DateTime.Today;
                string   todaysDate   = todayDate.ToString("MM/dd/yyyy");
                DateTime expDate      = todayDate.AddDays(15);
                string   expireDate   = expDate.ToString("MM/dd/yyyy");
                int      affectedRows = mediaLogic.InsertBorrow(CurrentUser.UserID, media.MediaId, todaysDate, expireDate);
                MessageBox.Show(media.MediaName + "has been borrowed for you!");
            }

            else
            {
                MessageBox.Show(media.MediaName + " sorry but you cannot borrow this media, it has already been reserved");
            }

            RefreshUserList();
        }