//验证 private void ValidateAddBookModel(BookAddModel addModel) { if (string.IsNullOrEmpty(addModel.BookName)) { throw new ValidateException(401, "请输入书籍名称"); } }
public ActionResult AddBook(BookAddModel addModel) { try { ValidateAddBookModel(addModel); Book model = NewBook(); model.BookName = addModel.BookName; string pdfDir = bookService.GetUploadDir(); //Directory.CreateDirectory(pdfDir); model.BookPath = pdfDir + addModel.File.FileName; string saveDir = bookService.GetSWFDir(); //Directory.CreateDirectory(saveDir); model.SwfPath = saveDir + $"{Guid.NewGuid().ToString().Replace("-", "")}.swf"; model.ConvertStatus = Enum.ConvertStatusEnum.UnStart; model.DeleteFlag = Enum.DeleteFlagEnum.UnDeleted; model.UploadTime = DateTime.Now; var bookId = bookService.AddBook(model); ViewBag.BookId = bookId; SaveFileToDisk(addModel.File, model.BookPath); Task.Run(() => { try { bookService.UpdateBookConvertStatus(bookId, ConvertStatusEnum.Converting); ConvertPdfToSWF(model.BookPath, model.SwfPath); bookService.UpdateBookConvertStatus(bookId, ConvertStatusEnum.Finished); } catch (Exception ex) { Logger.Log($"swf:{model.SwfPath} {ex.Message}"); bookService.UpdateBookConvertStatus(bookId, ConvertStatusEnum.Failed); } }); //return Json(new { code = 1 }); ViewBag.Msg = "上传成功"; return(View()); } catch (ValidateException ex) { ViewBag.Msg = ex.Message; //return Json(new { code = ex.Code, msg = ex.Message }); return(View()); } catch (Exception ex) { ViewBag.Msg = ex.Message; //return Json(new { code = 0, msg = ex.Message }); return(View()); } }
public IActionResult AddBook([FromBody] BookAddModel book) { var created = _bookService.AddBook(book); if (created) { return(Ok()); } return(BadRequest()); }
public ActionResult <Book> AddBook([FromBody] BookAddModel book) { if (book == null) { return(BadRequest()); } var newBook = new Book { Title = book.Title, Author = book.Author }; db.Add(newBook); db.SaveChanges(); return(Created("", newBook)); }
public async Task <ActionResult <BookApiViewModel> > Add(BookAddModel addModel) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Book result = await _mediator.Send(new AddBookCommand(addModel.Name, (double)addModel.Price)); if (result is null) { return(BadRequest()); } BookApiViewModel viewModel = BooksApiMapper.MapToApiModel(result); return(Created(Url.RouteUrl("GetBookById", new { id = viewModel.Id }), viewModel)); }
public bool AddBook(BookAddModel bookAddModel) { var date = Convert.ToDateTime($"{bookAddModel.ReleaseDate}-01-01"); var owner = _booksDealersRepository.GetUserById(bookAddModel.OwnerId); var book = new Book { Owner = owner, Status = bookAddModel.Status, Title = bookAddModel.Title, Author = bookAddModel.Author, Category = bookAddModel.Category, ReleaseDate = date, CreationDate = DateTime.Now, Description = bookAddModel.Description, Isbn = bookAddModel.Isbn }; _booksDealersRepository.AddBook(book); return(_booksDealersRepository.Save()); }
/// <summary> /// search books by book title /// </summary> /// <param name="searchWord"></param> /// <returns></returns> public IList <BookAddModel> SearchBook(string searchWord) { try { DatabaseConnection databaseConnection = new DatabaseConnection(this.configuration); List <StoredProcedureParameterData> paramList = new List <StoredProcedureParameterData>(); paramList.Add(new StoredProcedureParameterData("@SearchTitle", searchWord)); DataTable table = databaseConnection.StoredProcedureExecuteReader("SearchBookByTitle", paramList); var bookData = new BookAddModel(); IList <BookAddModel> bookList = new List <BookAddModel>(); foreach (DataRow dataRow in table.Rows) { bookData = new BookAddModel(); bookData.Id = (int)dataRow["Id"]; bookData.BooKTitle = dataRow["Book_Title"].ToString(); bookData.Author = dataRow["Author"].ToString(); bookData.Language = dataRow["Language"].ToString(); bookData.Category = dataRow["Category"].ToString(); bookData.ISBN = Convert.ToInt32(dataRow["ISBN_No"]); bookData.Price = Convert.ToInt32(dataRow["Price"]); bookData.Pages = Convert.ToInt32(dataRow["Pages"]); bookData.CreatedDate = Convert.ToDateTime(dataRow["CreatedDate"]); bookData.ModifiedDate = Convert.ToDateTime(dataRow["ModifiedDate"]); bookList.Add(bookData); } if (bookList != null) { return(bookList.ToList()); } else { return(null); } } catch (Exception e) { throw new Exception(e.Message); } }
/// <summary> /// add book /// </summary> /// <param name="bookShowModel"></param> /// <returns></returns> public BookAddModel AddBook(BookShowModel bookShowModel) { try { DatabaseConnection databaseConnection = new DatabaseConnection(this.configuration); List <StoredProcedureParameterData> paramList = new List <StoredProcedureParameterData>(); paramList.Add(new StoredProcedureParameterData("@Book_Title", bookShowModel.BooKTitle)); paramList.Add(new StoredProcedureParameterData("@Author", bookShowModel.Author)); paramList.Add(new StoredProcedureParameterData("@Language", bookShowModel.Language)); paramList.Add(new StoredProcedureParameterData("@Category", bookShowModel.Category)); paramList.Add(new StoredProcedureParameterData("@ISBN_No", bookShowModel.ISBN)); paramList.Add(new StoredProcedureParameterData("@Price", bookShowModel.Price)); paramList.Add(new StoredProcedureParameterData("@Pages", bookShowModel.Pages)); paramList.Add(new StoredProcedureParameterData("@CreatedDate", DateTime.Now)); paramList.Add(new StoredProcedureParameterData("@ModifiedDate", DateTime.Now)); DataTable table = databaseConnection.StoredProcedureExecuteReader("AddBook", paramList); var bookData = new BookAddModel(); foreach (DataRow dataRow in table.Rows) { bookData = new BookAddModel(); bookData.Id = (int)dataRow["Id"]; bookData.BooKTitle = dataRow["Book_Title"].ToString(); bookData.Author = dataRow["Author"].ToString(); bookData.Language = dataRow["Language"].ToString(); bookData.Category = dataRow["Category"].ToString(); bookData.ISBN = Convert.ToInt32(dataRow["ISBN_No"]); bookData.Price = Convert.ToInt32(dataRow["Price"]); bookData.Pages = Convert.ToInt32(dataRow["Pages"]); bookData.CreatedDate = Convert.ToDateTime(dataRow["CreatedDate"]); bookData.ModifiedDate = Convert.ToDateTime(dataRow["ModifiedDate"]); } return(bookData); } catch (Exception exception) { throw new Exception(exception.Message); } }
/// <summary> /// update book by book price /// </summary> /// <param name="updateBookModel"></param> /// <returns></returns> public BookAddModel UpdateBookPrice(UpdateBookModel updateBookModel) { try { DatabaseConnection databaseConnection = new DatabaseConnection(this.configuration); SqlConnection sqlConnection = databaseConnection.GetConnection(); SqlCommand sqlCommand = databaseConnection.GetCommand("UpdateBookPrice", sqlConnection); sqlCommand.Parameters.AddWithValue("@BookId", updateBookModel.BookId); sqlCommand.Parameters.AddWithValue("@Price", updateBookModel.Price); sqlConnection.Open(); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); BookAddModel bookAddModel = new BookAddModel(); while (sqlDataReader.Read()) { bookAddModel = new BookAddModel(); bookAddModel.Id = (int)sqlDataReader["Id"]; bookAddModel.BooKTitle = sqlDataReader["Book_Title"].ToString(); bookAddModel.Author = sqlDataReader["Author"].ToString(); bookAddModel.Language = sqlDataReader["Language"].ToString(); bookAddModel.Category = sqlDataReader["Category"].ToString(); bookAddModel.ISBN = (int)sqlDataReader["ISBN_No"]; bookAddModel.Price = (int)sqlDataReader["Price"]; bookAddModel.Pages = (int)sqlDataReader["Pages"]; bookAddModel.CreatedDate = Convert.ToDateTime(sqlDataReader["CreatedDate"]); bookAddModel.ModifiedDate = DateTime.Now; if (bookAddModel.Id == updateBookModel.BookId) { return(bookAddModel); } } sqlConnection.Close(); return(null); } catch (Exception e) { throw new Exception(e.Message); } }
public string AddBook2(BookAddModel book) { try { BookService bookService = new BookService(); Book newBook = new Book(); newBook.Author = book.Author; newBook.Description = book.Description; newBook.Genre = book.Genre; newBook.Quantity = book.Quantity; newBook.Title = book.Title; newBook.CreatedDate = DateTime.Now; bookService.AddBook(newBook); return("Book is added successfully"); } catch (Exception ex) { return($"Failed to add the book. Error: {ex.GetBaseException().Message}"); } }