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