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();
}
