public RespnseBook UpdateBook(long BookID, RespnseBook book) { try { return(bookManagementRL.UpdateBook(BookID, book)); } catch (Exception) { throw; } }
public RespnseBook UpdateBook(long BookID, RespnseBook book) { try { using (SqlConnection connection = new SqlConnection(connectionString)) { using (connection) { connection.Open(); SqlCommand cmd = new SqlCommand("UpdateBookRecord", connection) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("BookID", BookID); cmd.Parameters.AddWithValue("BookName", book.BookName); cmd.Parameters.AddWithValue("BookDiscription", book.BookDiscription); cmd.Parameters.AddWithValue("BookImage", "book"); cmd.Parameters.AddWithValue("BookPrice", book.BookPrice); cmd.Parameters.AddWithValue("BookQuantity", book.Quantity); cmd.Parameters.AddWithValue("AuthorName", book.AuthorName); var returnParameter = cmd.Parameters.Add("@Result", SqlDbType.Int); returnParameter.Direction = ParameterDirection.ReturnValue; SqlDataReader rd = cmd.ExecuteReader(); var result = returnParameter.Value; if (result != null && result.Equals(2)) { throw new Exception("book don't exist"); } if (rd.Read()) { Book = new RespnseBook { BookID = rd["BookID"] == DBNull.Value ? default : rd.GetInt64("BookID"), BookDiscription = rd["BookDiscription"] == DBNull.Value ? default : rd.GetString("BookDiscription"), BookPrice = rd["BookPrice"] == DBNull.Value ? default : rd.GetInt32("BookPrice"), BookName = rd["BookName"] == DBNull.Value ? default : rd.GetString("BookName"), AuthorName = rd["AuthorName"] == DBNull.Value ? default : rd.GetString("AuthorName"), BookImage = rd["BookImage"] == DBNull.Value ? default : rd.GetString("BookImage"), InStock = rd["InStock"] != DBNull.Value && rd.GetBoolean("InStock") }; } return(Book); } } } catch (Exception) { throw; } }
public ICollection <RespnseBook> GetPriceSortBooks(long CustomerID, bool sort) { try { { using (SqlConnection connection = new SqlConnection(connectionString)) { using (connection) { List <RespnseBook> Books = new List <RespnseBook>(); connection.Open(); SqlCommand cmd = new SqlCommand("GetPriceSortedBooks", connection) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("CustomerID", CustomerID); cmd.Parameters.AddWithValue("order", sort); SqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { RespnseBook Book = new RespnseBook(); Book.BookID = rd["BookID"] == DBNull.Value ? default : rd.GetInt64("BookID"); Book.BookDiscription = rd["BookDiscription"] == DBNull.Value ? default : rd.GetString("BookDiscription"); Book.BookPrice = rd["BookPrice"] == DBNull.Value ? default : rd.GetInt32("BookPrice"); Book.BookName = rd["BookName"] == DBNull.Value ? default : rd.GetString("BookName"); Book.AuthorName = rd["AuthorName"] == DBNull.Value ? default : rd.GetString("AuthorName"); Book.BookImage = rd["BookImage"] == DBNull.Value ? default : rd.GetString("BookImage"); Book.InStock = rd["InStock"] == DBNull.Value ? default : rd.GetBoolean("InStock"); Books.Add(Book); } return(Books); } } } } catch (Exception) { throw; } }
public RespnseBook AddBook(RespnseBook book) { try { using (SqlConnection connection = new SqlConnection(connectionString)) { using (connection) { connection.Open(); SqlCommand cmd = new SqlCommand("InserBookRecord", connection) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("BookName", book.BookName); cmd.Parameters.AddWithValue("BookDiscription", book.BookDiscription); cmd.Parameters.AddWithValue("BookImage", book.BookImage); cmd.Parameters.AddWithValue("BookPrice", book.BookPrice); cmd.Parameters.AddWithValue("BookQuantity", book.Quantity); cmd.Parameters.AddWithValue("AuthorName", book.AuthorName); SqlDataReader rd = cmd.ExecuteReader(); RespnseBook Book = new RespnseBook(); if (rd.Read()) { Book.BookID = rd["BookID"] == DBNull.Value ? default : rd.GetInt64("BookID"); Book.BookDiscription = rd["BookDiscription"] == DBNull.Value ? default : rd.GetString("BookDiscription"); Book.BookPrice = rd["BookPrice"] == DBNull.Value ? default : rd.GetInt32("BookPrice"); Book.Quantity = rd["BookQuantity"] == DBNull.Value ? default : rd.GetInt32("BookQuantity"); Book.BookName = rd["BookName"] == DBNull.Value ? default : rd.GetString("BookName"); Book.AuthorName = rd["AuthorName"] == DBNull.Value ? default : rd.GetString("AuthorName"); Book.BookImage = rd["BookImage"] == DBNull.Value ? default : rd.GetString("BookImage"); Book.InStock = rd["InStock"] != DBNull.Value && rd.GetBoolean("InStock"); } return(Book); } } } catch (Exception) { throw; } }
public IActionResult UpdateBook(long BookID, RespnseBook Book) { try { var identity = User.Identity as ClaimsIdentity; if (identity != null) { RespnseBook book = bookManagementBL.UpdateBook(BookID, Book); if (book != null) { return(Ok(new { success = true, Message = "book updated", book })); } } return(BadRequest(new { success = false, Message = "book update Unsuccessful" })); } catch (Exception exception) { return(BadRequest(new { success = false, exception.Message })); } }
public RespnseBook AddBook(RequestBook book) { try { string ImageUrl = ""; if (book.BookImage != null) { ImageUrl = cloudinary.UploadImage(book.BookName, book.BookImage); } responseBook = new RespnseBook { BookName = book.BookName, BookDiscription = book.BookDiscription == null ? "" : book.BookDiscription, BookPrice = book.BookPrice, BookImage = ImageUrl, AuthorName = book.AuthorName, Quantity = book.Quantity }; var result = bookManagementRL.AddBook(responseBook); responseBook = new RespnseBook { BookID = result.BookID, BookDiscription = result.BookDiscription, BookImage = result.BookImage, BookName = result.BookName, BookPrice = result.BookPrice, AuthorName = result.AuthorName, InCart = result.InCart, InStock = result.InStock, Quantity = result.Quantity }; return(result); } catch (Exception) { throw; } }
public IActionResult AddBook([FromForm] RequestBook Book) { if (Book == null) { return(BadRequest("Book is null.")); } try { var identity = User.Identity as ClaimsIdentity; if (identity != null) { RespnseBook book = bookManagementBL.AddBook(Book); if (book != null) { return(Ok(new { success = true, Message = "book added", book })); } } return(BadRequest(new { success = false, Message = "book adding Unsuccessful" })); } catch (Exception exception) { return(BadRequest(new { success = false, exception.Message })); } }