public ActionResult DeleteConfirmed(int id)
{
PersonBook personRead = db.PersonBooks.Find(id);
db.PersonBooks.Remove(personRead);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private PersonBook ReadItem(SqlDataReader reader)
{
int pBId = reader.IsDBNull(0) ? 0 : reader.GetInt32(0);
int personId = reader.IsDBNull(1) ? 0 : reader.GetInt32(1);
int bookId = reader.IsDBNull(2) ? 0 : reader.GetInt32(2);
PersonBook item = new PersonBook()
{
PBId = pBId,
PersonId = personId,
BookId = bookId
};
return(item);
}
public ActionResult Create([Bind(Include = "BookReadID, Name,Author,Genre, DateEntered")] DisplayBook displayBook)
{
var us = User.Identity.Name;
var user = db.Users.FirstOrDefault(x => x.Email == us);
if (ModelState.IsValid)
{
var addBook = (from a in db.BooksReads
where a.BookReadName == displayBook.Name
select a);
if (addBook.Count() == 0)
{
var newBook = new BooksRead();
newBook.BookReadName = displayBook.Name;
newBook.BookReadGenre = displayBook.Genre;
newBook.BookReadAuthor = displayBook.Author;
db.BooksReads.Add(newBook);
db.SaveChanges();
var newPB = new PersonBook();
newPB.BookDateEntered = displayBook.DateEntered;
newPB.BookReadID = newBook.BookReadID;
newPB.Id = user.Id;
db.PersonBooks.Add(newPB);
db.SaveChanges();
}
else
{
var newPB = new PersonBook();
newPB.BookDateEntered = displayBook.DateEntered;
newPB.BookReadID = addBook.First().BookReadID;
newPB.Id = user.Id;
db.PersonBooks.Add(newPB);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(View(displayBook));
}
public IEnumerable <PersonBook> Get()
{
string selectString = "select * from PERSONBOOK;";
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(selectString, conn))
{
using (SqlDataReader reader = command.ExecuteReader())
{
List <PersonBook> result = new List <PersonBook>();
while (reader.Read())
{
PersonBook item = ReadItem(reader);
result.Add(item);
}
return(result);
}
}
}
}
public int Post([FromBody] PersonBook value)
{
try
{
string inseartString = "INSERT INTO PERSONBOOK (PersonId, BookId) values(@personId, @bookId); ";
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(inseartString, conn))
{
command.Parameters.AddWithValue("@personId", value.PersonId);
command.Parameters.AddWithValue("@bookId", value.BookId);
int rowsAffected = command.ExecuteNonQuery();
return(1);
}
}
}
catch (Exception)
{
return(0);
}
}
