public async Task <IActionResult> Edit(int id, [Bind("ResearchId,BookId")] ResearchBook researchBook) { if (id != researchBook.ResearchId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(researchBook); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ResearchBookExists(researchBook.ResearchId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["BookId"] = new SelectList(_context.Book, "Id", "Name", researchBook.BookId); ViewData["ResearchId"] = new SelectList(_context.Research, "Id", "Name", researchBook.ResearchId); return(View(researchBook)); }
private void AddBorrower() { try { if (!(tb_BFName.Text == "")) { using (var ctx = new RRSContext()) { int tempId = Int32.Parse(dataGridView_Borrow.SelectedRows[0].Cells[0].Value.ToString()); var categoryid = (from cats in ctx.ResearchBooks where cats.ThesisTitleId.Equals(tempId) select cats.NumberOfCopies).SingleOrDefault(); var bookBorrowed = categoryid - 1; var rb = new ResearchBook() { ThesisTitleId = tempId, NumberOfCopies = bookBorrowed }; ctx.ResearchBooks.Attach(rb); ctx.Entry(rb).Property(x => x.NumberOfCopies).IsModified = true; ctx.SaveChanges(); var borrow = new Borrow { BFullName = tb_BFName.Text, BContactNumber = tb_BContactNumber.Text, BookBorrowedDate = DateTime.Now, DateWillRetrun = dateTimePicker_Return.Value.Date, ThesisTitleId = tempId, NoOfBookBorrowed = 1, }; ctx.Borrows.AddOrUpdate(borrow); ctx.SaveChanges(); tb_BFName.Clear(); tb_BContactNumber.Clear(); dateTimePicker_Return.Value = DateTime.Now; LoadBorrower(); ListofBorrowedBooks listofBorrowedBooks = new ListofBorrowedBooks(); listofBorrowedBooks.ShowDialog(); } } else { MessageBox.Show("Add a borrower name"); } } catch (Exception) { throw; } }
public async Task <IActionResult> Create([Bind("ResearchId,BookId")] ResearchBook researchBook) { if (ModelState.IsValid) { _context.Add(researchBook); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["BookId"] = new SelectList(_context.Book, "Id", "Name", researchBook.BookId); ViewData["ResearchId"] = new SelectList(_context.Research, "Id", "Name", researchBook.ResearchId); return(View(researchBook)); }