Exemple #1
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
         });
     }
 }
Exemple #2
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);
         }
     }
 }
 public bool Register(users user)
 {
     using (var context = new vlEntities())
     {
         try
         {
             context.users.Add(user);
             context.SaveChanges();
             return(true);
         }
         catch (Exception)
         {
             return(false);
         }
     }
 }
Exemple #4
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);
     }
 }