public static void AddAuthor(Author_tmp a) { DSMyLibraryDataContext ml = new DSMyLibraryDataContext(); ml.Author_tmps.InsertOnSubmit(a); ml.SubmitChanges(); }
public static void AddBook(Book_tmp b) { DSMyLibraryDataContext ml = new DSMyLibraryDataContext(); ml.Book_tmps.InsertOnSubmit(b); ml.SubmitChanges(); }
public static void DelMyBook(int id) { DSMyLibraryDataContext ml = new DSMyLibraryDataContext(); var ub = from b in ml.UsersBook_tmps where b.Id == id select b; ml.UsersBook_tmps.DeleteOnSubmit(ub.First()); ml.SubmitChanges(); }
public static void SetMyBooks(IEnumerable <int> checkedIDs, Guid guid) { DSMyLibraryDataContext ml = new DSMyLibraryDataContext(); foreach (int bookid in checkedIDs) { if (!AlreadyInDB(bookid, guid)) { UsersBook_tmp ub = new UsersBook_tmp(); ub.BookId = bookid; ub.UserId = guid; ml.UsersBook_tmps.InsertOnSubmit(ub); } } ml.SubmitChanges(); }