예제 #1
0
        private void bttnAddNew_Click(object sender, System.EventArgs e)
        {
            FORMBooks_Modify.ADD_STATE = true;
            FORMBooks_Modify sForm = new FORMBooks_Modify();

            sForm.ShowDialog();
        }
예제 #2
0
 private void bttnModify_Click(object sender, System.EventArgs e)
 {
     if (lvBooks.Items.Count > 0)
     {
         try
         {
             FORMBooks_Modify.ADD_STATE = false;
             FORMBooks_Modify.sBookID   = lvBooks.Items[lvBooks.FocusedItem.Index].SubItems[0].Text;
             FORMBooks_Modify sForm = new FORMBooks_Modify();
             sForm.ShowDialog();
         }
         catch (ArgumentOutOfRangeException aooreE) { MessageBox.Show("" + aooreE.Message); }
         catch (NullReferenceException nreE) {}
     }
     else
     {
         MessageBox.Show("No record to edit.", clsVariables.sMSGBOX, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
     }
 }
예제 #3
0
        private void FORMBooks_Modify_Load(object sender, System.EventArgs e)
        {
            if (ADD_STATE == true)
            {
                picLOGO.Image            = MDIFORM.i32x32.Images[13];
                bttnModification.Enabled = false;
                bttnBarrowed.Enabled     = false;

                //Set Add OleDbCommand
                cmdAddBook = new OleDbCommand("INSERT INTO tblBooks(BookNo,ISBN,Author,BookTitle,CategoryIndex,YearPublished,DateArrived,Price,Qty,AddedBy,DateAdd) VALUES(@getBookNo,@getISBN,@getAuthor,@getBookTitle,@getCategoryIndex,@getYearPublished,@getDateArrived,@getPrice,@getQty,@getAddedBy,@getDateAdd)", clsConnections.CN);
                this.Text  = "Add New";
            }
            else
            {
                picLOGO.Image = MDIFORM.i32x32.Images[14];

                //Set Edit OleDbCommand
                cmdAddBook = new OleDbCommand("UPDATE tblBooks SET BookNo =@getBookNo, ISBN =@getISBN, Author =@getAuthor, BookTitle =@getBookTitle, CategoryIndex =@getCategoryIndex, YearPublished =@getYearPublished, DateArrived =@getDateArrived, Price =@getPrice, Qty =@getQty, ModifyBy =@getModifyBy, DateModify =@getDateModify WHERE BookNo LIKE '" + sBookID + "' ", clsConnections.CN);
                FillFields();
                txtBookNO.ReadOnly = true;
                this.Text          = "Edit Existing";
            }

            cmdAddBook.Parameters.Add("@getBookNo", OleDbType.VarChar);
            cmdAddBook.Parameters.Add("@getISBN", OleDbType.VarChar);
            cmdAddBook.Parameters.Add("@getAuthor", OleDbType.VarChar);
            cmdAddBook.Parameters.Add("@getBookTitle", OleDbType.VarChar);
            cmdAddBook.Parameters.Add("@getCategoryIndex", OleDbType.Double);
            cmdAddBook.Parameters.Add("@getYearPublished", OleDbType.VarChar);
            cmdAddBook.Parameters.Add("@getDateArrived", OleDbType.Date);
            cmdAddBook.Parameters.Add("@getPrice", OleDbType.Currency);
            cmdAddBook.Parameters.Add("@getQty", OleDbType.Double);
            cmdAddBook.Parameters.Add("@getAddedBy", OleDbType.VarChar);
            cmdAddBook.Parameters.Add("@getDateAdd", OleDbType.Date);
            cmdAddBook.Parameters.Add("@getModifyBy", OleDbType.VarChar);
            cmdAddBook.Parameters.Add("@getDateModify", OleDbType.Date);

            publicBooksList = this;
        }