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