public IHttpActionResult GetBookcaseRate(string id)
{
try
{
conn.Open();
id = "'" + id + "'";
String url = "select AVG(Rate) as rate, count(bookId) as countNum from BookCase where bookId = " + id;
SqlCommand cmd = new SqlCommand(url, conn);
reader = cmd.ExecuteReader();
if (reader.Read())
{
bookcase = new Bookcase();
if (!reader.IsDBNull(0))
{
bookcase.rate = reader.GetInt32(0);
}
if (!reader.IsDBNull(1))
{
bookcase.countDownload = reader.GetInt32(1);
}
return(Ok(bookcase));
}
}
catch (Exception e)
{
return(NotFound());
}
finally
{
closeConnect();
}
return(NotFound());
}
public IHttpActionResult GetMark(int accId, int bookId)
{
try
{
conn.Open();
String url = "select BookMark from BookCase where accId = " + accId + " and bookId = " + bookId;
SqlCommand cmd = new SqlCommand(url, conn);
reader = cmd.ExecuteReader();
if (reader.Read())
{
bookcase = new Bookcase();
if (!reader.IsDBNull(0))
{
bookcase.bookMark = reader.GetInt32(0);
}
return(Ok(bookcase));
}
}
catch (Exception e)
{
return(NotFound());
}
finally
{
closeConnect();
}
return(NotFound());
}
public async Task <IActionResult> add(int bookcase_id, int star, string review)
{
try {
Bookcase bookcase = await _bookcaseRepository.Get(bookcase_id);
if (bookcase == null)
{
return(NotFound(new Respone(404, "Not Found", null)));
}
var username = User.FindFirst(ClaimTypes.NameIdentifier).Value;
User user = await _userRepository.FindByUsername(username);
if (user == null)
{
return(NotFound(new Respone(404, "Not Found", null)));
}
RateBookcase rateBookcase = new RateBookcase
{
bookcase_id = bookcase.bookcase_id,
star = star,
review = review,
user_id = user.user_id
};
await _rateBookcaseRepository.Add(rateBookcase);
return(Ok(new Respone(200, "ok", null)));
} catch (Exception e) {
return(BadRequest(new Respone(400, "Failed", null)));
}
}
public async Task <IActionResult> getReturnCode(int bookcase_id)
{
try {
var username = User.FindFirst(ClaimTypes.NameIdentifier).Value;
User user = await _userRepository.FindByUsername(username);
if (user == null)
{
return(NotFound(new Respone(404, "Not Found", null)));
}
Bookcase bookcase = await _bookcaseRepository.Get(bookcase_id);
if (bookcase.user_id != user.user_id)
{
return(BadRequest(new Respone(400, "Failed", null)));
}
Borrow borrow = await _borrowRepository.FindByBookcase(bookcase_id);
if (borrow == null || borrow.return_date != null)
{
return(BadRequest(new Respone(400, "Chưa mượn", null)));
}
var resultCode = System.Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes("Return " + borrow.borrow_id));
return(Ok(new Respone(200, "ok", new {
code = resultCode
})));
} catch (Exception e) {
return(BadRequest(new Respone(400, "Failed", null)));
}
}
private static IFurniture EnterBookcase()
{
Bookcase b = null;
while (b == null)
{
try
{
Console.WriteLine("Выберете матреиал 1 - дерево, в остальных случаях сталь");
Material mat = SelectMaterial();
Console.WriteLine("Введите количество полок");
int shelfCount = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Введите стартовую цену");
float startPrice = Convert.ToSingle(Console.ReadLine());
Console.WriteLine("Введите год выпуска");
int year = Convert.ToInt32(Console.ReadLine());
Location location = SelectLocation();
Console.WriteLine("Введите количество книжек на полке");
int count = Convert.ToInt32(Console.ReadLine());
b = new Bookcase(mat, shelfCount, startPrice, year, location, count);
}
catch (FormatException e)
{
Console.WriteLine("что-то неправильно!");
}
}
return(b);
}
public async Task <IActionResult> delete(int bookcase_id)
{
try {
Bookcase bookcase = await _bookcaseRepository.Get(bookcase_id);
if (bookcase == null)
{
return(NotFound(new Respone(404, "Bookcase not found", null)));
}
var username = User.FindFirst(ClaimTypes.NameIdentifier).Value;
User user = await _userRepository.FindByUsername(username);
if (user == null)
{
return(NotFound(new Respone(404, "NotFound", null)));
}
if (bookcase.user_id == user.user_id)
{
await _bookcaseRepository.Delete(bookcase_id);
}
return(Ok(new Respone(200, "ok", null)));
} catch (Exception e) {
return(BadRequest(new Respone(400, "Failed", null)));
}
}
public async Task <IActionResult> add(string sku)
{
try {
Book book = await _bookRepository.FindBySKU(sku);
if (book == null)
{
return(NotFound(new Respone(404, "Book not found", null)));
}
var username = User.FindFirst(ClaimTypes.NameIdentifier).Value;
User user = await _userRepository.FindByUsername(username);
if (user == null)
{
return(NotFound(new Respone(404, "Not Found", null)));
}
Bookcase bookcase = new Bookcase
{
book_id = book.book_id,
user_id = user.user_id
};
await _bookcaseRepository.Add(bookcase);
return(Ok(new Respone(200, "ok", null)));
} catch (Exception e) {
return(BadRequest(new Respone(400, "Failed", null)));
}
}
public async Task <IActionResult> get(int bookcase_id)
{
try {
Bookcase bookcase = await _bookcaseRepository.Get(bookcase_id);
if (bookcase == null)
{
return(NotFound(new Respone(404, "Bookcase not found", null)));
}
var username = User.FindFirst(ClaimTypes.NameIdentifier).Value;
User user = await _userRepository.FindByUsername(username);
if (user == null)
{
return(NotFound(new Respone(404, "Not Found", null)));
}
if (bookcase.user_id != user.user_id)
{
return(BadRequest(new Respone(400, "Failed", null)));
}
Book book = await _bookRepository.Get(bookcase.book_id);
var dict = new Dictionary <String, object>();
dict.Add("bookcase_id", bookcase.bookcase_id);
dict.Add("book", book);
return(Ok(new Respone(200, "ok", dict)));
} catch (Exception e) {
return(BadRequest(new Respone(400, "Failed", null)));
}
}
public void bindCase()
{
string sql = "select * from tb_bookcase";
Bookcase.DataSource = dataOperate.getDataset(sql, "tb_bookcase");
Bookcase.DataKeyNames = new string[] { "bookcaseID" };
Bookcase.DataBind();
}
public Bookcase Get()
{
Bookcase bookcase = new Bookcase {
};
if ((bookcase.Name == null) && (bookcase.Size == 0) && (bookcase.ShelvesCount == 0))
{
Log.Info("до 200см высотой шкафы");
}
return(bookcase);
}
public IHttpActionResult GetBookCaseByUserId(string id)
{
try
{
conn.Open();
id = "'" + id + "'";
String url = "select b.bookId as bookId, b.bookName as bookName, b.bookImage as bookImage," +
" b.bookLink as bookLink, au.autName as autName," +
" bc.BookMark as bookMard, bc.Rate as rate, b.bookDescription as bookDescription " +
"from BookCase bc, Book b, Account a, Author au " +
"where bc.accId = a.accId and bc.bookId = b.bookId and b.AuthorautId = au.autId " +
"and a.accId = " + id + " order by b.bookName";
SqlCommand cmd = new SqlCommand(url, conn);
reader = cmd.ExecuteReader();
List <Bookcase> lst = new List <Bookcase>();
while (reader.Read())
{
bookcase = new Bookcase();
bookcase.bookId = reader.GetInt32(0);
bookcase.name = reader.GetString(1);
if (!reader.IsDBNull(2))
{
bookcase.bookImage = reader.GetString(2);
}
bookcase.bookLink = reader.GetString(3);
bookcase.autName = reader.GetString(4);
bookcase.bookMark = reader.GetInt32(5);
if (!reader.IsDBNull(6))
{
bookcase.rate = (double)reader.GetInt32(6);
}
if (!reader.IsDBNull(7))
{
bookcase.bookDescription = reader.GetString(7);
}
lst.Add(bookcase);
}
return(Ok(lst));
}
catch (Exception e)
{
return(NotFound());
}
finally
{
closeConnect();
}
return(NotFound());
}
static void Main(string[] args)
{
// Класс шкаф - содержит полки, содержит фиксированное
// количество полок. Позволяет брать и класть книгу.
Bookcase bookcase = new Bookcase(2, 5);
Book book1 = new Book("author1", "name1", "text1", 1900, 100);
Book book2 = new Book("author2", "name2", "text2", 2000, 200);
bookcase.AddBook(book1, 2);
bookcase.AddBook(book2, 1);
Book book3 = bookcase.GetBook("name1");
}
public async Task <IActionResult> borrow(String code)
{
try {
code = Encoding.UTF8.GetString(Convert.FromBase64String(code));
int bookcase_id = Convert.ToInt32(code.Substring(6));
Borrow borrowed = await _borrowRepository.FindByBookcase(bookcase_id);
if (borrowed != null && borrowed.return_date == null)
{
return(BadRequest(new Respone(400, "Borrowed", null)));
}
Bookcase bookcase = await _bookcaseRepository.Get(bookcase_id);
if (bookcase == null)
{
return(NotFound(new Respone(404, "Not Found", null)));
}
var username = User.FindFirst(ClaimTypes.NameIdentifier).Value;
User user = await _userRepository.FindByUsername(username);
if (user == null)
{
return(NotFound(new Respone(404, "Not Found", null)));
}
if (bookcase.user_id == user.user_id)
{
return(BadRequest(new Respone(400, "Failed", null)));
}
Borrow borrow = new Borrow {
user_id_borrow = user.user_id,
bookcase_id = bookcase_id
};
await _borrowRepository.Add(borrow);
return(Ok(new Respone(200, "ok", null)));
} catch (Exception e) {
return(BadRequest(new Respone(400, "Failed", null)));
}
}
protected void Bookcase_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
Bookcase.PageIndex = e.NewPageIndex; //设置当前页的索引
Bookcase.DataBind();
}
