public List <Book> GetUsersBorrowedBooks(int id)
{
using (var context = new vlEntities())
{
var res = new List <Book>();
try
{
var query =
from book in context.books
join copy in context.copies on book.Id equals copy.BookId
where copy.UserId == id
select new Book
{
QRCode = copy.Id,
Author = book.Author,
Title = book.Title
};
foreach (var book in query)
{
res.Add(book);
}
return(res);
}
catch (Exception)
{
return(null);
}
}
}
public List <Book2> GetAllBooks()
{
var res = new List <Book2>();
using (var context = new vlEntities())
{
try
{
using (var context2 = new vlEntities())
{
var allBooks = context.books;
foreach (var book in allBooks)
{
res.Add(new Book2
{
BookInfo = new Book3
{
Id = book.Id,
Author = book.Author,
Title = book.Title,
Category = book.Category,
Popularity = book.Popularity,
},///
Amount = context2.copies.Count(c => c.UserId == null && c.BookId == book.Id),
});
}
}
return(res);
}
catch (Exception)
{
return(null);
}
}
}
public BookResponse Take(int userId, int qrCode)
{
try
{
using (var context = new vlEntities())
{
var res = context.copies.Where(c => c.Id == qrCode).FirstOrDefault();
res.UserId = userId;
using (var context2 = new vlEntities())
{
var res2 = context2.books.Where(c => c.Id == res.BookId).FirstOrDefault();
++res2.Popularity;
context.SaveChanges();
context2.SaveChanges();
return(new BookResponse
{
WasUpdated = true,
BookInfo = new Book
{
Author = res2.Author,
Title = res2.Title,
QRCode = qrCode
}
});
}
}
}
catch (Exception)
{
return(new BookResponse {
WasUpdated = false
});
}
}
public List <books> GetAllBooks()
{
using (var context = new vlEntities())
{
return(context.books.ToList());
}
}
public users FaceRecognitionLogin(int id)
{
using (var context = new vlEntities())
{
return(context.users
.Where(u => u.Id == id)
.FirstOrDefault());
}
}
public users ManualLogin(string email, string password)
{
using (var context = new vlEntities())
{
return(context.users
.Where(u => u.Email == email)
.Where(u => u.Password == password)
.FirstOrDefault());
}
}
public bool DeleteUser(int UserId)
{
using (var context = new vlEntities())
{
try
{
context.users.Remove(context.users.Where(u => u.Id == UserId).FirstOrDefault());
context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool Register(users user)
{
using (var context = new vlEntities())
{
try
{
context.users.Add(user);
context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public bool Return(int qrCode)
{
try
{
using (var context = new vlEntities())
{
var res = context.copies.Where(c => c.Id == qrCode).FirstOrDefault();
res.UserId = null;
context.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}