public async Task <IActionResult> Edit(int id, [Bind("BorrowedId,BookId,MemberId,BookTitle,MemberFname,MemberLname,DateBorrowed,ReturnDate")] BooksBorrowed booksBorrowed)
{
if (id != booksBorrowed.BorrowedId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(booksBorrowed);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!BooksBorrowedExists(booksBorrowed.BorrowedId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(booksBorrowed));
}
private void btn_borrowedB_Click(object sender, EventArgs e)
{
MembersTbl _member = (MembersTbl)dataGridView1.SelectedRows[0].DataBoundItem;
BooksBorrowed Bfrm = new BooksBorrowed(_member.ID);
Bfrm.MdiParent = this.MdiParent;
Bfrm.Show();
}
public async Task <IActionResult> Create([Bind("BorrowedId,BookId,MemberId,BookTitle,MemberFname,MemberLname,DateBorrowed,ReturnDate")] BooksBorrowed booksBorrowed)
{
if (ModelState.IsValid)
{
_context.Add(booksBorrowed);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(booksBorrowed));
}
/// <summary>
/// Get a single booked borrowed based on id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <BooksBorrowed> getbookBorrowed(int id = 0)
{
var response = new BooksBorrowed();
try
{
response = await _repo.getbookBorrowed(id);
}
catch (Exception ex)
{
_logger.LogError("Error Has occured", ex);
}
return(response);
}
/// <summary>
/// Get a single booked borrowed based on id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <BooksBorrowed> getbookBorrowed(int id = 0)
{
var response = new BooksBorrowed();
try
{
var result = (from x in _dbContext.BooksBorrowed where x.id == id select x).FirstOrDefault();
response = result;
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
public async Task <bool> borrowBooks(BooksBorrowed req)
{
var response = false;
try
{
_dbContext.BooksBorrowed.Add(req);
if (await _dbContext.SaveChangesAsync() > 0)
{
response = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
/// <summary>
/// persist book borrowing operation to the database
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public async Task <bool> borrowBooks(BooksBorrowed req)
{
var response = false;
try
{
var result = await _repo.borrowBooks(req);
if (result)
{
result = true;
}
}
catch (Exception ex)
{
_logger.LogError("Error Has occured", ex);
}
return(response);
}
