public int kitapGuncelle(Books book) { KiKapEntities db = new KiKapEntities(); Books yeni = db.Books.FirstOrDefault(c => c.ID == book.ID); yeni.bookName = book.bookName; yeni.author = book.author; yeni.type = book.type; yeni.editor = book.editor; yeni.translator = book.translator; yeni.pageNumbers = book.pageNumbers; yeni.format_ = book.format_; yeni.publisher = book.publisher; yeni.publicationDate = book.publicationDate; yeni.language = book.language; yeni.edition = book.edition; yeni.price = book.price; yeni.size = book.size; yeni.ISBN = book.ISBN; try { db.SaveChanges(); return(1); } catch (Exception) { return(-1); } }
public int kitapSil(Books book) { KiKapEntities db = new KiKapEntities(); try { List <Books> bookList = db.Books.Where(c => c.ID == book.ID).ToList(); foreach (var item in bookList) { db.Books.Remove(item); db.SaveChanges(); } return(1); } catch (Exception) { return(-1); } }
public int kitapEkle(Books book) { KiKapEntities db = new KiKapEntities(); List <Books> kitapVarMi = db.Books.Where(c => c.bookName.Contains(book.bookName) && c.author.Contains(book.author)).ToList(); if (kitapVarMi.Count > 0) { return(0); } try { db.Books.Add(book); db.SaveChanges(); return(1); } catch (Exception) { return(-1); } }