コード例 #1
0
        public HttpResponseMessage DeleteBook(string key)
        {
            try
            {
                var context = new LibrarySystemContext();
                using(context)
                {
                    var book = context.Books.FirstOrDefault(b => b.Key == key);
                    if(book==null)
                    {
                        throw new ArgumentException("Няма книга с такъв уникален номер!");
                    }
                    context.Books.Remove(book);
                    context.SaveChanges();
                }

                var response = this.Request.CreateResponse(HttpStatusCode.OK);
                return response;
            }
            catch(Exception ex)
            {
                var response = this.Request.CreateResponse(HttpStatusCode.BadRequest,
                                          ex.Message);
                return response;
            }
        }
コード例 #2
0
        public HttpResponseMessage GetUserByUniqueNumber(int uniqueNumber)
        {
            try
            {
                var context = new LibrarySystemContext();
                using (context)
                {
                    var user = context.Users.FirstOrDefault(u => u.UniqueNumber == uniqueNumber);
                    if(user==null)
                    {
                        throw new Exception("Няма такъв потребител!");
                    }

                    var booksToReturn =
                        context.UsersBooks.Where(ub => ub.User.UniqueNumber == uniqueNumber && ub.IsReturned == false);

                    var userInfo = new DetailedUserModel()
                                       {
                                           Id = user.Id,
                                           UniqueNumber = user.UniqueNumber,
                                           Name = user.Name,

                                       };
                    userInfo.BooksToReturn=new Collection<BookToReturnModel>();
                    foreach (var book in booksToReturn)
                    {
                        userInfo.BooksToReturn.Add(new BookToReturnModel()
                                                       {
                                                           Key = book.Book.Key,
                                                           Title = book.Book.Title,
                                                           AuthorName = book.Book.Author.Name,
                                                           DateToreturn = book.DateToReturn,
                                                           Year = book.Book.Year,
                                                           Description = book.Book.Description
                                                       });
                    }

                    var response = this.Request.CreateResponse(HttpStatusCode.OK, userInfo);
                    return response;
                }
            }
            catch (Exception ex)
            {
                var response = this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message);
                return response;
            }
        }
コード例 #3
0
        public HttpResponseMessage AddNote(NoteModel model)
        {
            try
            {
                var context = new LibrarySystemContext();
                using (context)
                {
                    var book = context.Books.FirstOrDefault(b => b.Key == model.BookKey);
                    var user = context.Users.FirstOrDefault(u => u.UniqueNumber == model.UserUniqueNumber);
                    if (book == null)
                    {
                        throw new ArgumentException("Няма такава книга!");
                    }
                    if (user == null)
                    {
                        throw new ArgumentException("Няма такъв потребител!");
                    }

                    book.Notes.Add(new Note()
                                       {
                                           User = user,
                                           Text = model.Text
                                       });

                    context.SaveChanges();

                    var response = this.Request.CreateResponse(HttpStatusCode.OK);
                    return response;
                }
            }
            catch (Exception ex)
            {
                var response = this.Request.CreateResponse(HttpStatusCode.BadRequest,
                                          ex.Message);
                return response;
            }
        }
コード例 #4
0
        public HttpResponseMessage PostCreateUser(UserModel model)
        {
            try
            {
                var dbContext = new LibrarySystemContext();
                using (dbContext)
                {
                    ValidateName(model.Name);
                    var user = new User()
                                   {
                                       Name = model.Name,
                                       AuthCode = model.AuthCode
                                   };

                    dbContext.Users.Add(user);
                    dbContext.SaveChanges();

                    user.SessionKey = this.GenerateSessionKey(user.Id);
                    user.UniqueNumber = user.Id + 1000;
                    dbContext.SaveChanges();

                    var loggedModel = new LoggedUserModel()
                    {
                        UniqueNumber = user.UniqueNumber,
                        SessionKey = user.SessionKey
                    };

                    var response = this.Request.CreateResponse(HttpStatusCode.Created,
                                              loggedModel);
                    return response;
                }

            }
            catch(Exception ex)
            {
                var response = this.Request.CreateResponse(HttpStatusCode.BadRequest,
                                              ex.Message);
                return response;
            }
        }
コード例 #5
0
        public HttpResponseMessage PutLogoutUser(string sessionKey)
        {
            try
            {
                var context = new LibrarySystemContext();
                using (context)
                {
                    var user = context.Users.FirstOrDefault(u => u.SessionKey == sessionKey);
                    if (user == null)
                    {
                        throw new ArgumentException("Невалидна сесия.");
                    }

                    user.SessionKey = null;
                    context.SaveChanges();

                    var response = this.Request.CreateResponse(HttpStatusCode.OK);
                    return response;
                }
            }
            catch (Exception ex)
            {
                var response = this.Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message);
                return response;
            }
        }
コード例 #6
0
        public HttpResponseMessage PostLoginUser(UserModel model)
        {
            try
            {
                ValidateAuthCode(model.AuthCode);

                var context = new LibrarySystemContext();
                using (context)
                {
                    var user = context.Users.FirstOrDefault(u => u.UniqueNumber == model.UniqueNumber
                        && u.AuthCode == model.AuthCode);

                    if (user == null)
                    {
                        throw new InvalidOperationException("Грешна парола или потребителски номер");
                    }
                    if (user.SessionKey == null)
                    {
                        user.SessionKey = this.GenerateSessionKey(user.Id);
                        context.SaveChanges();
                    }

                    var loggedModel = new LoggedUserModel()
                    {
                        UniqueNumber = user.UniqueNumber,
                        SessionKey = user.SessionKey,
                        Name = user.Name
                    };

                    var response = this.Request.CreateResponse(HttpStatusCode.Created,
                                        loggedModel);
                    return response;
                }
            }
            catch (Exception ex)
            {
                var response = this.Request.CreateResponse(HttpStatusCode.BadRequest,
                                         ex.Message);
                return response;
            }
        }
コード例 #7
0
        public HttpResponseMessage SearchForBook(string query, SearchBy searchBy=SearchBy.All)
        {
            try
            {
                var context = new LibrarySystemContext();

                if (query == null || query == "")
                {
                    throw new ArgumentException("Невалидно търсене!");
                }

                IQueryable<Book> booksEntity;
                if (searchBy == SearchBy.Key)
                {
                    booksEntity = context.Books.Where(b => b.Key.Contains(query));
                }
                else if (searchBy == SearchBy.Author)
                {
                    booksEntity = context.Books.Where(b => b.Author.Name.Contains(query));
                }
                else if (searchBy == SearchBy.Title)
                {
                    booksEntity = context.Books.Where(b => b.Title.Contains(query));
                }
                else
                {
                    booksEntity = context.Books.Where(b => b.Key.Contains(query) || b.Author.Name.Contains(query)
                                                           || b.Title.Contains(query));
                }

                var books = from book in booksEntity
                            select new BookModel()
                                       {
                                           Title = book.Title,
                                           AuthorName = book.Author.Name,
                                           Description = book.Description,
                                           Key = book.Key,
                                           Year = book.Year
                                       };

                var response = this.Request.CreateResponse(HttpStatusCode.OK, books);
                return response;

            }
            catch (Exception ex)
            {
                var response = this.Request.CreateResponse(HttpStatusCode.BadRequest,
                                           ex.Message);
                return response;
            }
        }
コード例 #8
0
        public HttpResponseMessage ReturnBook(string bookCode, int userNumber)
        {
            try
            {
                var context = new LibrarySystemContext();
                using (context)
                {
                    var book = context.Books.FirstOrDefault(b => b.Key == bookCode);
                    var user = context.Users.FirstOrDefault(u => u.UniqueNumber == userNumber);
                    if (book == null)
                    {
                        throw new ArgumentException("Няма такава книга!");
                    }
                    if (user == null)
                    {
                        throw new ArgumentException("Няма такъв потребител!");
                    }

                    var userBook=context.UsersBooks.FirstOrDefault(ub => ub.Book.Key == book.Key &&
                        ub.User.UniqueNumber == user.UniqueNumber);
                    if (userBook != null && userBook.IsReturned==false)
                    {
                        userBook.IsReturned = true;
                        context.SaveChanges();
                    }
                    else
                    {
                        throw new Exception("Тази книга не е взета от този потребител!");
                    }

                    var response = this.Request.CreateResponse(HttpStatusCode.OK);
                    return response;
                }
            }
            catch (Exception ex)
            {
                var response = this.Request.CreateResponse(HttpStatusCode.BadRequest,
                                          ex.Message);
                return response;
            }
        }
コード例 #9
0
        public HttpResponseMessage ModifyBook(BookModel model, string key)
        {
            try
            {
                var context = new LibrarySystemContext();
                using (context)
                {
                    var book = context.Books.FirstOrDefault(b => b.Key == key);
                    if (book == null)
                    {
                        throw new ArgumentException("Няма книга с такъв уникален номер!");
                    }

                    var author = context.Authors.FirstOrDefault(a => a.Name == model.AuthorName);
                    if (author == null)
                    {
                        context.Authors.Add(new Author()
                        {
                            Name = model.AuthorName
                        });
                        context.SaveChanges();
                    }

                    book.Title = model.Title;
                    book.Key = model.Key;
                    book.Author = author;
                    book.Year = model.Year;
                    book.Description = model.Description;

                    context.SaveChanges();
                }

                var response = this.Request.CreateResponse(HttpStatusCode.OK);
                return response;
            }
            catch (Exception ex)
            {
                var response = this.Request.CreateResponse(HttpStatusCode.NotModified,
                                          ex.Message);
                return response;
            }
        }
コード例 #10
0
        public HttpResponseMessage ImportBooks(ICollection<BookModel> books)
        {
            try
            {
                int errors = 0;
                var context = new LibrarySystemContext();
                using(context)
                {
                    foreach (var book in books)
                    {
                        var author = context.Authors.FirstOrDefault(a => a.Name == book.AuthorName);
                        if(author==null)
                        {
                            author=context.Authors.Add(new Author()
                                                    {
                                                        Name = book.AuthorName
                                                    });
                            context.SaveChanges();
                        }

                        var existBook = context.Books.FirstOrDefault(b => b.Key == book.Key);
                        if(existBook==null)
                        {
                            context.Books.Add(new Book()
                                                  {
                                                      Title = book.Title,
                                                      Author = author,
                                                      Key = book.Key,
                                                      Year = book.Year,
                                                      Description = book.Description
                                                  });
                        }
                        else
                        {
                            errors++;
                        }

                    }
                    context.SaveChanges();

                }
                if (errors > 0)
                {
                    throw new Exception("Има книга със същото заглавие и тя НЕ е заменена!");
                }
                var response = this.Request.CreateResponse(HttpStatusCode.OK);
                return response;
            }
            catch (Exception ex)
            {
                var response = this.Request.CreateResponse(HttpStatusCode.BadRequest,
                                          ex.Message);
                return response;
            }
        }
コード例 #11
0
        public HttpResponseMessage GetLBooksThatMustBeReturned()
        {
            try
            {
                var context = new LibrarySystemContext();

                var booksEntity = context.UsersBooks.Where(ub => ub.DateToReturn < DateTime.Now);

                var books = from book in booksEntity
                            select new BookToReturnModel()
                                       {
                                           Title = book.Book.Title,
                                           AuthorName = book.Book.Author.Name,
                                           Description = book.Book.Description,
                                           Key = book.Book.Key,
                                           Year = book.Book.Year,
                                           UserUniqueNumber = book.User.UniqueNumber,
                                           UserName = book.User.Name,
                                           DateToreturn = book.DateToReturn
                                       };

                var response = this.Request.CreateResponse(HttpStatusCode.OK, books);
                return response;

            }
            catch (Exception ex)
            {
                var response = this.Request.CreateResponse(HttpStatusCode.BadRequest,
                                                           ex.Message);
                return response;
            }
        }
コード例 #12
0
        public HttpResponseMessage GetLast20Books(int start)
        {
            try
            {
                var context = new LibrarySystemContext();

                var booksEntity = context.Books.OrderByDescending(b => b.Id).Skip(start).Take(20);

                    var books = from book in booksEntity
                                select new BookModel()
                                           {
                                               Title = book.Title,
                                               AuthorName = book.Author.Name,
                                               Description = book.Description,
                                               Key = book.Key,
                                               Year = book.Year,
                                           };

                    var response = this.Request.CreateResponse(HttpStatusCode.OK, books);
                    return response;

            }
            catch(Exception ex)
            {
                var response = this.Request.CreateResponse(HttpStatusCode.BadRequest,
                                          ex.Message);
                return response;
            }
        }
コード例 #13
0
        public HttpResponseMessage GetGotBooksFromUser(int uniqueNumber)
        {
            try
            {
                var context = new LibrarySystemContext();

                    var booksEntity = context.UsersBooks.Where(ub => ub.User.UniqueNumber == uniqueNumber)
                        .OrderByDescending(ub=>ub.DateToReturn);

                    var books = from book in booksEntity
                                select new BookToReturnModel()
                                           {
                                               Title = book.Book.Title,
                                               AuthorName = book.Book.Author.Name,
                                               Description = book.Book.Description,
                                               Key = book.Book.Key,
                                               Year = book.Book.Year,
                                               DateToreturn = book.DateToReturn
                                           };

                    var response = this.Request.CreateResponse(HttpStatusCode.OK, books);
                    return response;

            }
            catch (Exception ex)
            {
                var response = this.Request.CreateResponse(HttpStatusCode.BadRequest,
                                          ex.Message);
                return response;
            }
        }
コード例 #14
0
        public HttpResponseMessage GetBookDetailed(string bookKey)
        {
            try
            {
                var context = new LibrarySystemContext();
                using (context)
                {
                    var book = context.Books.FirstOrDefault(b => b.Key == bookKey);

                    var theBook = new BookDetailsModel()
                                      {
                                          Title = book.Title,
                                          AuthorName = book.Author.Name,
                                          Description = book.Description,
                                          Key = book.Key,
                                          Year = book.Year,
                                      };

                    foreach (var note in book.Notes)
                    {
                        theBook.Notes.Add(new NoteModel()
                                              {
                                                  Text = note.Text
                                              });
                    }

                    var response = this.Request.CreateResponse(HttpStatusCode.OK, theBook);
                    return response;
                }
            }
            catch (Exception ex)
            {
                var response = this.Request.CreateResponse(HttpStatusCode.BadRequest,
                                          ex.Message);
                return response;
            }
        }
コード例 #15
0
        public HttpResponseMessage GetBook(string bookCode, int userNumber)
        {
            try
            {
                var context = new LibrarySystemContext();
                using (context)
                {
                    var book = context.Books.FirstOrDefault(b => b.Key == bookCode);
                    var user = context.Users.FirstOrDefault(u => u.UniqueNumber == userNumber);
                    if(book==null)
                    {
                        throw new ArgumentException("Няма такава книга!");
                    }
                    if(user==null)
                    {
                        throw new ArgumentException("Няма такъв потребител!");
                    }

                    var userBook = context.UsersBooks.FirstOrDefault(ub => ub.Book.Key == book.Key
                        && ub.User.UniqueNumber == user.UniqueNumber);
                    if (userBook == null)
                    {
                        context.UsersBooks.Add(new UserBook()
                                                   {
                                                       Book = book,
                                                       User = user,
                                                       IsReturned = false,
                                                       DateToReturn = DateTime.Now.AddDays(30)
                                                   });
                    }
                    else if(userBook.IsReturned==true)
                    {
                        userBook.IsReturned = false;
                        userBook.DateToReturn = DateTime.Now.AddDays(30);
                    }
                    else
                    {
                        throw new Exception("Тази книга вече е взета!");
                    }
                    context.SaveChanges();

                    var response = this.Request.CreateResponse(HttpStatusCode.OK);
                    return response;
                }
            }
            catch (Exception ex)
            {
                var response = this.Request.CreateResponse(HttpStatusCode.BadRequest,
                                          ex.Message);
                return response;
            }
        }