public bool ChangeBookToHasRead(ReadingListModel model)
{
int rowsAffected = 0;
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("Update readingList Set hasReAD = @hasRead where userID = @userID AND bookID = @bookID;", conn);
cmd.Parameters.AddWithValue("@hasRead", 1);
cmd.Parameters.AddWithValue("@userID", model.UserID);
cmd.Parameters.AddWithValue("@bookID", model.BookID);
rowsAffected = cmd.ExecuteNonQuery();
}
}
catch (SqlException e)
{
Console.WriteLine(e.Message);
}
return(rowsAffected > 0);
}
public bool AddBookToReadingList(ReadingListModel model)
{
int rowsAffected = 0;
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("Insert into readingList Values (@bookID, @userID, @hasRead);", conn);
cmd.Parameters.AddWithValue("@bookID", model.BookID);
cmd.Parameters.AddWithValue("@userID", model.UserID);
cmd.Parameters.AddWithValue("@hasRead", 0);
rowsAffected = cmd.ExecuteNonQuery();
}
}
catch (SqlException e)
{
e.Message.ToString();
throw;
}
return(rowsAffected > 0);
}
public bool BookAlreadyInList(ReadingListModel model)
{
List <ReadingListModel> output = new List <ReadingListModel>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cm = new SqlCommand("select * from readingList where bookID = @bookID and userID = @userID ", conn);
cm.Parameters.AddWithValue("@bookID", model.BookID);
cm.Parameters.AddWithValue("@userID", model.UserID);
SqlDataReader reader = cm.ExecuteReader();
while (reader.Read())
{
output.Add(new ReadingListModel {
BookID = Convert.ToInt32(reader["bookID"]),
UserID = Convert.ToInt32(reader["userID"]),
HasRead = Convert.ToBoolean(reader["hasRead"]),
});
}
}
}
catch (SqlException e)
{
e.Message.ToString();
}
return(output.Count > 0);
}
public void TestBookAlreadyInList()
{
ReadingListSqlDAL dal = new ReadingListSqlDAL();
ReadingListModel readingList = new ReadingListModel();
readingList.BookID = 1;
readingList.UserID = 1;
bool bookAlreadyInList = dal.BookAlreadyInList(readingList);
Assert.IsTrue(bookAlreadyInList);
}
public void TestAddBookToReadingList()
{
ReadingListSqlDAL dal = new ReadingListSqlDAL();
ReadingListModel readingList = new ReadingListModel();
readingList.BookID = 2;
readingList.UserID = 2;
bool addBook = dal.AddBookToReadingList(readingList);
Assert.IsTrue(addBook);
}
public ActionResult ChangeToRead(int bookID)
{
UserModel user = usersDAL.GetUser(base.CurrentUser);
ReadingListModel currentBookInfo = new ReadingListModel();
currentBookInfo.BookID = bookID;
currentBookInfo.UserID = user.UserID;
readingListDAL.ChangeBookToHasRead(currentBookInfo);
List <ReadingListModel> readingList = readingListDAL.GetReadingList(user.UserID);
MyEchoBooksViewModel viewModel = new MyEchoBooksViewModel();
viewModel.ReadingList = readingList;
viewModel.CurrentUser = user;
return(View("ReadingList", viewModel));
}
public void TestChangeBookToHasRead()
{
ReadingListSqlDAL dal = new ReadingListSqlDAL();
ReadingListModel readingList = new ReadingListModel();
readingList.BookID = 1;
readingList.UserID = 1;
readingList.HasRead = false;
bool hasRead = dal.ChangeBookToHasRead(readingList);
Assert.IsTrue(hasRead);
List <ReadingListModel> list = dal.GetReadingList(1);
Assert.AreEqual(true, list[0].HasRead);
}
//GET: Detail of chosen book
public ActionResult BookDetail(int bookID)
{
ReadingListModel list = new ReadingListModel();
BookModel book = new BookModel();
book = booksDAL.GetBooksById(bookID);
UserModel user = usersDAL.GetUser(base.CurrentUser);
ReviewModel review = reviewDAL.GetReview(bookID);
BookDetailViewModel model = new BookDetailViewModel();
model.CurrentBook = book;
model.CurrentReview = review;
model.CurrentUser = user;
if (model.CurrentUser != null)
{
list.UserID = user.UserID;
list.BookID = bookID;
model.IsBookInList = rlDAL.BookAlreadyInList(list);
}
return(View("BookDetail", model));
}
public ActionResult AddToReadingList(int bookID, int userID)
{
ReadingListModel list = new ReadingListModel();
list.BookID = bookID;
list.UserID = userID;
BookModel book = new BookModel();
book = booksDAL.GetBooksById(bookID);
UserModel user = usersDAL.GetUser(base.CurrentUser);
ReviewModel review = reviewDAL.GetReview(bookID);
BookDetailViewModel model = new BookDetailViewModel();
model.CurrentBook = book;
model.CurrentReview = review;
model.CurrentUser = user;
model.CurrentReadingList = list;
rlDAL.AddBookToReadingList(list);
model.IsBookInList = true;
return(View("BookDetail", model));
}
