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 }));
}
}
