public List <IssueBookModel> ShowAllIssuedBook(string Key)
{
SqlCommand com_Show = new SqlCommand("proc_ShowAllIssuedBook", con);
com_Show.Parameters.AddWithValue("@key", Key);
com_Show.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader dr = com_Show.ExecuteReader();
List <IssueBookModel> list = new List <IssueBookModel>();
while (dr.Read())
{
IssueBookModel model = new IssueBookModel();
model.IssueID = dr.GetInt32(0);
model.StudentID = dr.GetInt32(1);
model.IssueDate = dr.GetDateTime(2);
model.IssueStatus = dr.GetString(3);
model.BookID = dr.GetInt32(4);
model.BookTitle = dr.GetString(5);
model.BookImage = dr.GetString(6);
list.Add(model);
}
con.Close();
return(list);
}
public async Task <IActionResult> IssueBook([FromBody] IssueBookModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
await appDbContext.BookTransactions.AddAsync(
new BookTransaction { AdminId = model.AdminId, ISBN = model.ISBN, BookId = model.BookId, IssueDate = model.IssueDate, MemberId = model.MemberId });
var mdToUpdate = await appDbContext.BookMetadatas.SingleOrDefaultAsync(s => s.BookId == model.BookId);
if (mdToUpdate != null)
{
mdToUpdate.Status = false;
}
await appDbContext.SaveChangesAsync();
return(new OkObjectResult("{}"));
}