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 IQueryable <object> GetBookUsers(string BookName, string AuthorName) { DSMyLibraryDataContext ml = new DSMyLibraryDataContext(); var res = from b in ml.UsersBook_tmps where b.Book_tmp.Name == BookName && b.Book_tmp.Author_tmp.Name == AuthorName select new { Name = b.aspnet_User.UserName }; return(res); }
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 IQueryable <object> GetUserBooks(string name) { DSMyLibraryDataContext ml = new DSMyLibraryDataContext(); var res = from b in ml.UsersBook_tmps where b.aspnet_User.UserName == name select new { Könyv = b.Book_tmp.Name, Író = b.Book_tmp.Author_tmp.Name, }; return(res); }
public static IQueryable GetMyBooks(Guid MyId) { DSMyLibraryDataContext ml = new DSMyLibraryDataContext(); var Mybooks = from b in ml.UsersBook_tmps where b.UserId == MyId select new { Id = b.Id, BookName = b.Book_tmp.Name, AuthorName = b.Book_tmp.Author_tmp.Name }; return(Mybooks); }
private static bool AlreadyInDB(int bookid, Guid guid) { DSMyLibraryDataContext ml = new DSMyLibraryDataContext(); IQueryable <UsersBook_tmp> ub = ml.UsersBook_tmps.Where(c => c.BookId == bookid && c.UserId == guid); if (ub.Count() > 0) { return(true); } else { return(false); } }
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(); }
public static IQueryable <object> GetAllBooks(string search, int pageindex) { DSMyLibraryDataContext ml = new DSMyLibraryDataContext(); var res = from b in ml.Book_tmps where b.Name.Contains(search) orderby b.Name select new { Id = b.Id, Name = b.Name, AuthorName = b.Author_tmp.Name, PageNum = b.PageNum, ReleaseDate = b.ReleaseDate, Already = false }; return(res); }
public static IQueryable <object> GetAllBooks(Guid Uid, string search, int pageindex) { DSMyLibraryDataContext ml = new DSMyLibraryDataContext(); //UsersBook_tmp ub_tmp=new UsersBook_tmp(); var res = from b in ml.Book_tmps where b.Name.Contains(search) orderby b.Name select new { Id = b.Id, Name = b.Name, AuthorName = b.Author_tmp.Name, PageNum = b.PageNum, ReleaseDate = b.ReleaseDate, Already = b.UsersBook_tmps.Where(ub => ub.UserId == Uid).Count() > 0 }; return(res); }
public static int GetAllPageNumFromAuthorById(int p) { DSMyLibraryDataContext dl = new DSMyLibraryDataContext(); return(dl.Book_tmps.Where(c => c.AuthorId == p).Count()); }
public static int GetBookPagenum() { DSMyLibraryDataContext dl = new DSMyLibraryDataContext(); return(dl.Book_tmps.Count() / pagesize); }
public static int GetBooksNum() { DSMyLibraryDataContext dl = new DSMyLibraryDataContext(); return(dl.Book_tmps.Count()); }