private void button1_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(textBox1.Text)) { int ID = Int32.Parse(textBox1.Text); using (BlogDbContext mc = new BlogDbContext()) { BookTbl removeBook = mc.BookTbls.Where(c => c.ID == ID).FirstOrDefault(); if (removeBook != null) { mc.BookTbls.Remove((BookTbl)removeBook); MessageBox.Show("The book removed successfully."); mc.SaveChanges(); } else { MessageBox.Show("Book not found.", "NOT FOUND!"); } this.Close(); } } } catch (FormatException) { MessageBox.Show("ID must be a number!", "INCORRECT FORMAT!"); } catch (OverflowException ex) { MessageBox.Show(ex.Message, "OVERFLOW!"); } }
public ActionResult DeleteConfirmed(int id) { BookTbl bookTbl = db.BookTbls.Find(id); db.BookTbls.Remove(bookTbl); db.SaveChanges(); return(RedirectToAction("Index")); }
private void ReturnBook(int BookID, int ID) { using (BlogDbContext mc = new BlogDbContext()) { BookTbl _BTbl = mc.BookTbls.Where(x => x.ID == BookID).FirstOrDefault(); _BTbl.Available = true; BorrowerTbl _BrwTbl = mc.BorrowerTbls.Where(x => x.ID == ID).FirstOrDefault(); _BrwTbl.ReturnDate = DateTime.Now; mc.SaveChanges(); } }
public void TestDetailsViewData() { // Arrange BookController controller = new BookController(); // Act ViewResult result = controller.Details(1) as ViewResult; BookTbl product = (BookTbl)result.ViewData.Model; // Assert Assert.AreEqual(1, product.Id); }
private void dataGridView2_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { try { BookTbl _Book = ((BookTbl)(dataGridView2.SelectedRows[0].DataBoundItem)); Form2 F2 = new Form2(_Book.ID); F2.FormClosed += F2_FormClosed; F2.Show(); } catch (NullReferenceException) { } }
// GET: Book/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BookTbl bookTbl = db.BookTbls.Find(id); if (bookTbl == null) { return(HttpNotFound()); } return(View("Edit", bookTbl)); }
private void setData() { using (BlogDbContext mc = new BlogDbContext()) { BookTbl bookTbl = mc.BookTbls.Where(x => x.ID == pBookId).FirstOrDefault(); if (bookTbl != null) { mTxtTitle.Text = bookTbl.Title; textBox2.Text = bookTbl.Author; textBox3.Text = bookTbl.Publisher; textBox4.Text = bookTbl.translator; mc.SaveChanges(); } } }
public ActionResult Edit([Bind(Include = "Id,Title,Author,Tag,Image,Year_of_publishing")] BookTbl bookTbl) { try { if (ModelState.IsValid) { db.Entry(bookTbl).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } } catch (Exception e) { } return(View("Edit", bookTbl)); }
public ActionResult Create([Bind(Include = "Id,Title,Author,Tag,Image,Year_of_publishing")] BookTbl bookTbl) { try { if (ModelState.IsValid) { db.BookTbls.Add(bookTbl); db.SaveChanges(); return(RedirectToAction("Index")); } } catch (Exception e) { } return(View("Create", bookTbl)); }
public void TestCreateFail() { // Arrange BookController controller = new BookController(); // Act BookTbl newbook = new BookTbl { Id = 0, Title = "Test Book", Author = "Test Author", Tag = "Test Tag", Year_of_publishing = -50 }; var result = controller.Create(newbook) as ViewResult; // Assert Assert.AreEqual("Create", result.ViewName); }
public void TestCreateRedirect() { // Arrange BookController controller = new BookController(); // Act BookTbl newbook = new BookTbl { Id = 0, Title = "Test Book-" + Membership.GeneratePassword(8, 0), Author = "Test Author-" + Membership.GeneratePassword(8, 0), Tag = "Test Tag-" + Membership.GeneratePassword(4, 0), Image = "https://d1e4pidl3fu268.cloudfront.net/66963e4a-ccba-4fdd-ba18-d5862fb4dba7/test.png?" + Membership.GeneratePassword(8, 0), Year_of_publishing = 2000 }; var result = controller.Create(newbook) as RedirectToRouteResult; // Assert Assert.AreEqual("Index", result.RouteValues["action"].ToString()); }
public void TestEditFail() { // Arrange BookController controller = new BookController(); // Act BookTbl dbBook = new BookTbl { Id = 9, Title = "Test Book New", Author = "Test Author New", Tag = "Test Tag New", Image = "https://d1e4pidl3fu268.cloudfront.net/66963e4a-ccba-4fdd-ba18-d5862fb4dba7/test.png", Year_of_publishing = -50 }; var result = controller.Edit(dbBook) as ViewResult; // Assert Assert.AreEqual("Edit", result.ViewName); }
private void _btn_Borrow_Click(object sender, EventArgs e) { if (dataGridView3.SelectedRows.Count == 0) { return; } BookTbl _infBook = (BookTbl)dataGridView3.SelectedRows[0].DataBoundItem; BookID = _infBook.ID; using (BlogDbContext mc = new BlogDbContext()) { var _bookList = mc.BookTbls.Where(x => x.ID == this.BookID).FirstOrDefault(); if (_bookList != null) { if (_bookList.Available == false) { _lbl_s.Text = "کتاب در قفسه موجود نیست"; return; } else { _bookList.Available = false; mc.SaveChanges(); using (BlogDbContext le2 = new BlogDbContext()) { BorrowerTbl _borrowList = new BorrowerTbl() { IDBook = BookID, IDMember = UserID, ReciveDate = DateTime.Now, DueDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day).AddDays(20) }; mc.BorrowerTbls.Add(_borrowList); mc.SaveChanges(); } this.Close(); } } } }
private void btn_save_Click(object sender, EventArgs e) { if (ValidateForm() == false) { return; } { using (BlogDbContext mc = new BlogDbContext()) { if (condition == Condition.Add) { BookTbl bookTbl = new BookTbl() { Title = mTxtTitle.Text, Author = textBox2.Text, Publisher = textBox3.Text, translator = textBox4.Text, Available = true }; mc.BookTbls.Add(bookTbl); mc.SaveChanges(); } else { BookTbl bookTbl = mc.BookTbls.Where(x => x.ID == pBookId).FirstOrDefault(); if (bookTbl != null) { bookTbl.Title = mTxtTitle.Text; bookTbl.Author = textBox2.Text; bookTbl.Publisher = textBox3.Text; bookTbl.translator = textBox4.Text; mc.SaveChanges(); } } } } this.Close(); }