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