public IEnumerable <GivenBook> GetGivenBooks()
{
var result = new List <GivenBook>();
using (SqlConnection connection = new SqlConnection(connectionstring))
{
SqlCommand cmd = new SqlCommand("GetGivenBooks", connection); //SQL-команда
cmd.CommandType = System.Data.CommandType.StoredProcedure;
connection.Open();
SqlDataReader read = cmd.ExecuteReader();
while (read.Read()) // читаем
{
var givenBook = new GivenBook
{
GiveID = (int)read["GiveID"],
BookID = (int)read["BookID"],
VisitorID = (int)read["VisitorID"],
GivenDate = (DateTime)read["GivenDate"],
ReturnDate = (DateTime)read["ReturnDate"],
};
result.Add(givenBook);
}
return(result);
}
}
public void AddGivenBook(GivenBook givenBook)
{
using (SqlConnection connection = new SqlConnection(connectionstring))
{
SqlCommand cmd = new SqlCommand("AddGivenBook", connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BookID", givenBook.BookID);
cmd.Parameters.AddWithValue("@VisitorID", givenBook.VisitorID);
cmd.Parameters.AddWithValue("@GivenDate", givenBook.GivenDate);
cmd.Parameters.AddWithValue("@ReturnDate", givenBook.ReturnDate);
connection.Open();
cmd.ExecuteNonQuery();//выполнить не дожидаясь ответа
}
}
public IActionResult ReturnBook(int id)
{
GivenBook returnableBook = new GivenBook();
IEnumerable <GivenBook> givenBooks = db.GivenBooks;
foreach (var book in givenBooks)
{
if (book.Id == id)
{
returnableBook = book;
}
}
var rBook = from book in db.Books
where book.Number == returnableBook.BookNumber
select book;
var retBook = rBook.ToList();
retBook[0].Availible = true;
db.GivenBooks.Remove(returnableBook);
db.SaveChanges();
return(RedirectToAction("Index", "User"));
}
