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