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