public DashboardModel() { User = new UserModel(); Book = new BookModel(); GoogleAPIBook = new googleAPIBook(); UserBook = new UserBookModel(); }
public DashboardModel(IHttpContextAccessor httpContextAccessor) { HttpContextAccessor = httpContextAccessor; User = new UserModel(); Book = new BookModel(); GoogleAPIBook = new googleAPIBook(); UserBook = new UserBookModel(); }
public DashboardModel(IHttpContextAccessor httpContextAccessor, ITempDataDictionaryFactory tempData) { HttpContextAccessor = httpContextAccessor; MyTempData = tempData; User = new UserModel(); Book = new BookModel(); GoogleAPIBook = new googleAPIBook(); UserBook = new UserBookModel(); }
public bool insertUserBook(UserBookModel userBook, int idBook) { if (userBook.Review != null) { userBook.Review = MySqlHelper.EscapeString(userBook.Review); } string sql = $"insert into UserBook (idUser, idBook, idReading, DateRead, Rating, Review, CanPublishIt)values " + $"('{userBook.IdUser}', '{idBook}', {userBook.IsReading}, '{userBook.DateRead.ToString("yyyy-MM-dd")}', '{userBook.Rating}', '{userBook.Review}', {userBook.CanPublishIt})"; ConnectionDB connection = new ConnectionDB(); try { connection.executeComandSQL(sql); return(true); } catch { return(false); } }
public bool updateUserBook(UserBookModel userBook, int bookId) { if (userBook.Review != null) { userBook.Review = MySqlHelper.EscapeString(userBook.Review); } string sql = "UPDATE userbook SET " + $"idReading = {userBook.IsReading}, DateRead = '{userBook.DateRead.ToString("yyyy-MM-dd")}', " + $"Rating = {userBook.Rating}, Review = '{userBook.Review}', CanPublishIt = {userBook.CanPublishIt} " + $"where idUser = {userBook.IdUser} and idBook = {bookId}"; try { ConnectionDB connection = new ConnectionDB(); connection.executeComandSQL(sql); return(true); } catch { return(false); } }