public static bool changeToBorrowed(int code, int status)
{
Lendings lending = DalLending.checkLending(code);
return DalBook.changeStatus(lending.IdBook, status);
}
public static bool changeToFree(int code)
{
Lendings lending = DalLending.checkLending(code);
return DalBook.changeStatus(lending.IdBook, 2);
}
// string mailBody = "<div><b>" + user.FirstName + "שלום</b>" +
//"<p>Bookmark תודה שהשתמשת בשרותי </p>" +
//"<p>מקוים שנהנית</p>" +
//"<p>" + book.NameBook + "הספר" +
//"" + library.NameLibrary + "מחכה לך בספריה" +
//"<p>:קוד השאלה</p>" +
//"<h3>" + lending.IdLending + "</h3>" +
//"<p>נשמח לעמוד לשרותכם תמיד</p></div>";
public static Books checkLending(int code)
{
Lendings lending = DalLending.checkLending(code);
BooksInLibrary book = DalLending.lendingBook(lending.IdBook);
return DalBook.getBookObj(book.IdBook);
}
public int Create(DalBook entity)
{
var obj = entity.ToOrmBook();
context.Books.Add(obj);
context.SaveChanges();
return(obj.BookID);
}
public void AddCover(DalBook book, DalCover cover)
{
var dbBook = context.Books.FirstOrDefault(e => e.BookID == book.ID);
if (dbBook != null)
{
context.Covers.Add(cover.ToOrmCover());
}
}
public void AddFile(DalBook book, DalFile file)
{
var dbBook = context.Books.FirstOrDefault(e => e.BookID == book.ID);
if (dbBook != null)
{
context.Files.Add(file.ToOrmFile());
}
}
public void AddScreening(DalBook book, DalScreening screening)
{
var dbBook = context.Books.FirstOrDefault(e => e.BookID == book.ID);
if (dbBook != null)
{
dbBook.Screenings.Add(screening.ToOrmScreening());
}
}
public void Delete(DalBook entity)
{
var book = context.Books.FirstOrDefault(e => e.BookID == entity.ID);
if (book != null)
{
context.Books.Remove(book);
}
}
public static Books ToOrmBook(this DalBook book)
{
return(new Books()
{
BookID = book.ID,
Age_Caegory = book.AgeCategory,
First_Publication = book.FirstPublication,
Name = book.Name
});
}
public IEnumerable <DalFile> GetFiles(DalBook book)
{
var dbBook = context.Books.FirstOrDefault(e => e.BookID == book.ID);
if (dbBook != null)
{
return(context.Files.Where(e => e.BookID == book.ID).ToList().Select(e => e.ToDalFile()));
}
return(new List <DalFile>());
}
public static ServiceBook ToServiceBook(this DalBook book)
{
return(new ServiceBook()
{
ID = book.ID,
AgeCategory = book.AgeCategory,
FirstPublication = book.FirstPublication,
Name = book.Name
});
}
public IEnumerable <DalScreening> GetScreenings(DalBook book)
{
var dbBook = context.Books.FirstOrDefault(e => e.BookID == book.ID);
if (dbBook != null)
{
return(dbBook.Screenings.Select(e => e.ToDalScreening()));
}
return(new List <DalScreening>());
}
public void AddGenre(DalBook book, DalGenre genre)
{
var dbBook = context.Books.FirstOrDefault(e => e.BookID == book.ID);
var dbGenre = context.Genres.FirstOrDefault(e => e.GenreID == genre.ID);
if (dbBook != null && dbGenre != null)
{
dbBook.Genres.Add(dbGenre);
}
}
public void AddTag(DalBook book, DalTag tag)
{
var dbBook = context.Books.FirstOrDefault(e => e.BookID == book.ID);
var dbTag = context.Tags.FirstOrDefault(e => e.TagID == tag.ID);
if (dbBook != null && dbTag != null)
{
dbBook.Tags.Add(dbTag);
}
}
public void AddAuthor(DalBook book, DalAuthor author)
{
var dbBook = context.Books.FirstOrDefault(e => e.BookID == book.ID);
var dbAuthor = context.Authors.FirstOrDefault(e => e.AuthorID == author.ID);
if (dbBook != null && dbAuthor != null)
{
dbBook.Authors.Add(dbAuthor);
}
}
public ServiceBook RandomBook()
{
Random random = new Random();
DalBook book = null;
while (book == null)
{
book = unit.Books.GetById(random.Next());
}
return(book.ToServiceBook());
}
public void Update(DalBook entity)
{
var a = context.Books.FirstOrDefault(e => e.BookID == entity.ID);
if (a != null)
{
a.Age_Caegory = entity.AgeCategory;
a.First_Publication = entity.FirstPublication;
a.Name = entity.Name;
}
}
public void DeleteBook(DalList list, DalBook book)
{
var dbList = context.Lists.FirstOrDefault(e => e.ListID == list.ID);
var dbBook = context.Books.FirstOrDefault(e => e.BookID == book.ID);
if (dbList != null && dbBook != null)
{
dbList.Books.Remove(dbBook);
context.SaveChanges();
}
}
public static bool changeStatus(int code)
{
int status;
Lendings lending = DalLending.checkLending(code);
BooksInLibrary book = DalLending.lendingBook(lending.IdBook);
if (book.IdStatus == 3)
status = 1;
else
status = 2;
return DalBook.changeStatus(lending.IdBook, status);
}
public void AddBook(DalCollection collection, DalBook book)
{
var dbBook = context.Books.FirstOrDefault(e => e.BookID == book.ID);
var dbCl = context.Collections.FirstOrDefault(e => e.CollectionID == collection.ID);
if (dbBook != null && dbCl != null)
{
Collection_Book cb = new Collection_Book
{
IsRead = null,
BookID = dbBook.BookID,
CollectionID = dbCl.CollectionID
};
context.Collection_Book.Add(cb);
}
}
public static bool updateStatusEveryDay()
{
DateTime dateTime = DateTime.Now;
BooksInLibrary[] catchBooksArray = DalBook.getAllCatchBooks();//all catch books
foreach (var catchBook in catchBooksArray)
{
int days = DalLending.getStartLending(catchBook.IdBook);
if (days != -1)
{
if (DateTime.Now.Day - days > 2)
{
if (!DalBook.changeStatus(catchBook.IdBook, 2))//change status to free
return false;
}
}
else
{
return false;
}
}
return true;
}
public static BooksInLibrary[] searchBook(Dal.Model.SearchObj searchObj)
{
return(DalBook.searchBook(searchObj));
}
public IEnumerable <DalAuthor> GetAuthors(DalBook book)
{
return
(context.Books.FirstOrDefault(e => e.BookID == book.ID)?.Authors.ToList().Select(e => e.ToDalAuthor()) ??
new List <DalAuthor>());
}
public static Categories[] allCategories()
{
return(DalBook.allCategories());
}
public static bool addNewBook(Books newBook)
{
return(DalBook.addNewBook(newBook));
}
public static Books getBook(BooksInLibrary[] id)
{
return(DalBook.getBook(id));
}
public IEnumerable <DalList> GetLists(DalBook book)
{
return(context.Books.FirstOrDefault(e => e.BookID == book.ID)?.Lists.Select(e => e.ToDalList()) ??
new List <DalList>());
}
public static StatusLending getStatus(int id)
{
return(DalBook.getStatus(id));
}
public IEnumerable <DalTag> GetTags(DalBook book)
{
return(context.Books.FirstOrDefault(e => e.BookID == book.ID)?.Tags.Select(e => e.ToDalTag()) ??
new List <DalTag>());
}
public IEnumerable <DalGenre> GetGenres(DalBook book)
{
return(context.Books.FirstOrDefault(e => e.BookID == book.ID)?.Genres.Select(e => e.ToDalGenre()) ??
new List <DalGenre>());
}
