예제 #1
0
파일: Books.cs 프로젝트: Ozerich/labs
        public static void AddBook(int catId, string Title, string Genre, string Author, string Publication, int PagesCount, int Year, EnumFileFormat fileFormat, List<string> Tags)
        {
            Book book = new Book();

            book.parentId = catId;
            book.Title = Title;
            book.Author = Author;
            book.parentId = catId;
            book.Publication = Publication;
            book.PagesCount = PagesCount;
            book.Year = Year;
            book.FileFormat = fileFormat;
            book.Genre = Genre;
            book.Tags = Tags;

            Catalog catalog = new Catalog();

            catalog.Books.InsertOnSubmit(book);

            catalog.SubmitChanges();

            int bookId = book.Id;

            foreach (string tag in book.Tags)
            {
                BookTag bookTag = new BookTag();
                bookTag.Name = tag;
                bookTag.Book_Id = bookId;

                catalog.Tags.InsertOnSubmit(bookTag);
            }

            catalog.SubmitChanges();
        }
예제 #2
0
파일: Books.cs 프로젝트: Ozerich/labs
        public static void UpdateBook(int bookId, int catId, string Title, string Genre, string Author, string Publication, int PagesCount, int Year, EnumFileFormat fileFormat, List<string> Tags)
        {
            Catalog catalog = new Catalog();

            var q = from ord in catalog.Books where ord.Id == bookId select ord;

            Book book = q.First();
            book.Title = Title;
            book.Author = Author;
            book.parentId = catId;
            book.Publication = Publication;
            book.PagesCount = PagesCount;
            book.Year = Year;
            book.FileFormat = fileFormat;
            book.Genre = Genre;
            book.Tags = Tags;

            var tagQuery = from tag in catalog.Tags where tag.Book_Id == bookId select tag;
            foreach (BookTag bookTag in tagQuery)
            {

                catalog.Tags.DeleteOnSubmit(bookTag);
            }

            foreach(string tag in book.Tags)
            {
                BookTag bookTag = new BookTag();
                bookTag.Name = tag;
                bookTag.Book_Id = bookId;

                catalog.Tags.InsertOnSubmit(bookTag);
            }

            catalog.SubmitChanges();
        }