public int post(PublicherModel publichermoudel) { if ((context.Publishers.FirstOrDefault(ww => ww.Name == publichermoudel.Name) == null)) { publisher publisher = new publisher(); publisher.Name = publichermoudel.Name; context.Publishers.Add(publisher); context.SaveChanges(); return(1); } else { return(0); } }
public int addcategory(PublicherModel cat) { var checkcategory = context.Categories.FirstOrDefault(ww => ww.CategoryName == cat.Name); if (checkcategory == null) { Category c = new Category(); c.CategoryName = cat.Name; context.Categories.Add(c); context.SaveChanges(); return(1); } else { return(0); } }
public int addpublisher(PublicherModel publish) { var checkpublisher = context.Publishers.FirstOrDefault(ww => ww.Name == publish.Name); if (checkpublisher == null) { publisher p = new publisher(); p.Name = publish.Name; context.Publishers.Add(p); context.SaveChanges(); return(1); } else { return(0); } }
public getbookbysearch searchBooks(string book) { PublicherModel book1 = new PublicherModel(); //var searchedbook = context.Books.FirstOrDefault(ww => ww.Title == book); var searchedbook = context.Books.FirstOrDefault(ww => ww.Title == book); var bookauthor = context.Authers.FirstOrDefault(ww => ww.AutherID == searchedbook.AutherID); var bookpublisher = context.Publishers.FirstOrDefault(ww => ww.PublisherID == searchedbook.PublisherID); getbookbysearch bookmodel = new getbookbysearch(); bookmodel.Title = searchedbook.Title; bookmodel.Image = searchedbook.Image; bookmodel.NumberOfPage = searchedbook.NumberOfPage; bookmodel.Price = searchedbook.Price; bookmodel.PublishDate = searchedbook.PublishDate; bookmodel.PublisherName = bookpublisher.Name; bookmodel.AuthorName = bookauthor.Name; bookmodel.CategoryName = (context.Categories.FirstOrDefault(ww => ww.CategoryID == searchedbook.CategoryID).CategoryName); return(bookmodel); }