예제 #1
0
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            using (var context = new BookLotEntities())
            {
                try
                {
                    int   bookId        = Int32.Parse(txtBookId.Text);
                    Books booksToUpdate = context.BookCategories.Find(bookId);
                    if (booksToUpdate != null)
                    {
                        booksToUpdate.BookId          = Int32.Parse(txtBookId.Text);
                        booksToUpdate.AuthorId        = Int32.Parse(txtAuthorId.Text);
                        booksToUpdate.PublisherId     = Int32.Parse(txtAuthorId.Text);
                        booksToUpdate.Title           = txtTitle.Text;
                        booksToUpdate.ISBN            = txtISBN.Text;
                        booksToUpdate.Genre           = txtGenre.Text;
                        booksToUpdate.Type            = txtType.Text;
                        booksToUpdate.PublicationYear = txtPubYear.Text;
                        booksToUpdate.Price           = Int32.Parse(txtPrice.Text);

                        booksToUpdate.Condition = txtCondition.Text;
                        context.SaveChanges();
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Empty format, try again");
                }
            }
        }
예제 #2
0
        private void btnDelete_Click(object sender, EventArgs e)
        {
            int bookId = Int32.Parse(txtBookId.Text);

            using (var context = new BookLotEntities())
            {
                Books booksToDelete = new Books()
                {
                    BookId = bookId
                };
                context.Entry(booksToDelete).State = EntityState.Deleted;
                context.SaveChanges();
            }
        }
예제 #3
0
        //private void btnEnter_Click(object sender, EventArgs e)
        //{
        //    try
        //    {
        //        if (txtLogin.Text == "")
        //        {
        //            throw new EmptyLoginException("Введіть логін!");
        //        }
        //        if (txtPassword.Text == "")
        //        {
        //            throw new EmptyPasswordException("Введіть пароль!");
        //        }

        //        AccountClient accountClient = new AccountClient();
        //        User input = accountClient.Login(txtLogin.Text, txtPassword.Text);

        //        if (input != null)
        //        {
        //            MessageBox.Show("Вхід успішний!");

        //            //if (input.PhotoName != null)
        //            //{
        //            //    Form2 form2 = new Form2(accountClient.GetImage(input.PhotoName));
        //            //    form2.ShowDialog();
        //            //}
        //            //else
        //            //{
        //            //    Form2 form2 = new Form2(null);
        //            //    form2.ShowDialog();
        //            //}

        //        }
        //        if (input == null)
        //        {
        //            MessageBox.Show("Ви НЕ ввійшли в особистий кабінет! \n Перевірте логін і пароль!");
        //        }

        //        accountClient.Close();
        //    }
        //    catch (EmptyLoginException emptyLoginException)
        //    {
        //        MessageBox.Show(emptyLoginException.Message);
        //    }
        //    catch (EmptyPasswordException emptyPasswordException)
        //    {
        //        MessageBox.Show(emptyPasswordException.Message);
        //    }
        //    catch (Exception exception)
        //    {
        //        MessageBox.Show(exception.Message);
        //    }
        //}

        private void btnSave_Click(object sender, EventArgs e)
        {
            //Service1Client client = new Service1Client();

            Books books = new Books();

            //client.Add(books);
            //client.Save(books);
            books.AuthorId        = Int32.Parse(txtAuthorId.Text);
            books.PublisherId     = Int32.Parse(txtPublisherId.Text);
            books.Title           = txtTitle.Text;
            books.ISBN            = txtISBN.Text;
            books.Genre           = txtGenre.Text;
            books.Type            = txtType.Text;
            books.PublicationYear = txtPubYear.Text;
            books.Price           = Int32.Parse(txtPrice.Text);

            books.Condition = txtCondition.Text;

            BookLotEntities lotEntities = new BookLotEntities();

            lotEntities.BookCategories.Add(books);
            lotEntities.SaveChanges();
        }