Пример #1
0
        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);
                }
            }
        }
Пример #2
0
        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);
                }
            }
        }
Пример #3
0
 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
         });
     }
 }
Пример #4
0
 public List <books> GetAllBooks()
 {
     using (var context = new vlEntities())
     {
         return(context.books.ToList());
     }
 }
Пример #5
0
 public users FaceRecognitionLogin(int id)
 {
     using (var context = new vlEntities())
     {
         return(context.users
                .Where(u => u.Id == id)
                .FirstOrDefault());
     }
 }
Пример #6
0
 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());
     }
 }
Пример #7
0
 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);
         }
     }
 }
Пример #8
0
 public bool Register(users user)
 {
     using (var context = new vlEntities())
     {
         try
         {
             context.users.Add(user);
             context.SaveChanges();
             return(true);
         }
         catch (Exception)
         {
             return(false);
         }
     }
 }
Пример #9
0
 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);
     }
 }