public List <Category> CategoryList() { using (KiKapEntities db = new KiKapEntities()) { return(db.Categories.ToList()); } }
public List <Author> author() { using (KiKapEntities db = new KiKapEntities()) { return(db.Authors.ToList()); } }
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 Books kitapDetay(int ID) { KiKapEntities db = new KiKapEntities(); Books book = db.Books.FirstOrDefault(c => c.ID == ID); return(book); }
public List <Books> kitapGetir(string deGet) { KiKapEntities db = new KiKapEntities(); List <Books> bookList = db.Books.Where(c => c.bookName.Contains(deGet) || c.author.Contains(deGet)).ToList(); return(bookList); }
public List <Orders> talepGetir(string deGet) { KiKapEntities db = new KiKapEntities(); List <Orders> orderList = db.Orders.Where(c => c.orderDetail.Contains(deGet)).ToList(); return(orderList); }
public List <Customers> musteriGetir(string deGet) { KiKapEntities db = new KiKapEntities(); List <Customers> customerList = db.Customers.Where(c => c.name.Contains(deGet) || c.sirname.Contains(deGet)).ToList(); return(customerList); }
public Customers musteriDetay(int id) { KiKapEntities db = new KiKapEntities(); Customers cust = db.Customers.FirstOrDefault(c => c.id == id); return(cust); }
public List<Book> Product() { using (KiKapEntities db = new KiKapEntities()) { return db.Books.ToList(); } }
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); } }