/// <summary> /// This method is created for getting all books details. /// </summary> /// <returns></returns> public List <BooksDetail> GetAllBooksDetails() { try { List <BooksDetail> bookstorelist = new List <BooksDetail>(); using (SqlConnection connection = new SqlConnection(configuration.GetConnectionString("UserDbConnection"))) { SqlCommand command = new SqlCommand("spGetAllBookDetails", connection); command.CommandType = CommandType.StoredProcedure; connection.Open(); SqlDataReader sqlreader = command.ExecuteReader(); while (sqlreader.Read()) { BooksDetail book = new BooksDetail(); book.BookId = Convert.ToInt32(sqlreader["BookId"]); book.BookName = sqlreader["BookName"].ToString(); book.AuthorName = sqlreader["AuthorName"].ToString(); book.Price = Convert.ToDouble(sqlreader["Price"]); book.Quantity = Convert.ToInt32(sqlreader["Quantity"]); book.Catagory = sqlreader["Catagory"].ToString(); book.BookImage = sqlreader["BookImage"].ToString(); book.Rating = Convert.ToDouble(sqlreader["Rating"]); bookstorelist.Add(book); } connection.Close(); } return(bookstorelist); } catch (CustomException exception) { throw new CustomException(CustomException.ExceptionType.NULL_EXCEPTION, exception.Message); } }
/// <summary> /// This method is created for adding book details. /// </summary> /// <param name="booksDetail"></param> /// <returns></returns> public object AddBookDetails(BooksDetail booksDetail) { try { using (SqlConnection con = new SqlConnection(configuration.GetConnectionString("UserDbConnection"))) { SqlCommand cmd = new SqlCommand("spAddBooksDetail", con); cmd.CommandType = CommandType.StoredProcedure; // cmd.Parameters.AddWithValue("@BookId", booksDetail.BookId); cmd.Parameters.AddWithValue("@BookName", booksDetail.BookName); cmd.Parameters.AddWithValue("@AuthorName", booksDetail.AuthorName); cmd.Parameters.AddWithValue("@Price", booksDetail.Price); cmd.Parameters.AddWithValue("@Quantity", booksDetail.Quantity); cmd.Parameters.AddWithValue("@Catagory", booksDetail.Catagory); cmd.Parameters.AddWithValue("@BookImage", booksDetail.BookImage); cmd.Parameters.AddWithValue("@Rating", booksDetail.Rating); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); return(true); } } catch (CustomException exception) { throw new CustomException(CustomException.ExceptionType.NULL_EXCEPTION, exception.Message); } }
public async Task <IActionResult> Edit(int id, [Bind("BookID,BookName,Author,Publisher,BookDescription,Extension,CategoryID")] BooksDetail booksDetail) { if (id != booksDetail.BookID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(booksDetail); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!BooksDetailExists(booksDetail.BookID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(booksDetail)); }
public IActionResult AddBookDetails(BooksDetail booksDetail) { string message; var result = this.manager.AddBookDetails(booksDetail); try { if (!result.Equals(null)) { message = "Book details added successfully."; msmq.SendMessage("Books name " + booksDetail.BookName + " added successfully.", result); this._distributedCache.Remove(key); return(this.Ok(new { message, result })); } message = "Please insert correct book details.!!"; return(BadRequest(new { message })); } catch (CustomException) { return(BadRequest(CustomException.ExceptionType.INVALID_INPUT)); } }
public async Task <IActionResult> Create([Bind("BookID,BookName,Author,Publisher,BookDescription,File,CategoryID")] BooksDetail booksDetail) { using (var memoryStream = new MemoryStream()) { await booksDetail.File.FormFile.CopyToAsync(memoryStream); string photoname = booksDetail.File.FormFile.FileName; booksDetail.Extension = Path.GetExtension(photoname); if (!".pdf".Contains(booksDetail.Extension.ToLower())) { ModelState.AddModelError("File.FormFile", "Only PDF Format is Allowed."); } else { ModelState.Remove("Extension"); } } if (ModelState.IsValid) { _context.Add(booksDetail); await _context.SaveChangesAsync(); var uploadsRootFolder = Path.Combine(_environment.WebRootPath, "bookpdfs"); if (!Directory.Exists(uploadsRootFolder)) { Directory.CreateDirectory(uploadsRootFolder); } string filename = booksDetail.BookID + booksDetail.Extension; var filePath = Path.Combine(uploadsRootFolder, filename); using (var fileStream = new FileStream(filePath, FileMode.Create)) { await booksDetail.File.FormFile.CopyToAsync(fileStream).ConfigureAwait(false); } return(RedirectToAction(nameof(Index))); } return(View(booksDetail)); }
public object AddBookDetails(BooksDetail booksDetail) { return(this.detailsRepository.AddBookDetails(booksDetail)); }