public static List <User> GetAllUser()
{
using (KutuphaneDBContext db = new KutuphaneDBContext())
{
return(db.User.ToList());
}
}
public static Writer GetWriter(int id)
{
using (KutuphaneDBContext db = new KutuphaneDBContext())
{
return(db.Writer.Find(id));
}
}
public static Book GetBook(int id)
{
using (KutuphaneDBContext db = new KutuphaneDBContext())
{
return(db.Book.Find(id));
}
}
public static void UserAdd(User user)
{
using (KutuphaneDBContext db = new KutuphaneDBContext())
{
db.User.Add(user);
db.SaveChanges();
}
}
public static void UpdateWriter(int id, string name)
{
using (KutuphaneDBContext db = new KutuphaneDBContext())
{
var result = db.Writer.Find(id);
result.WriterName = name;
db.SaveChanges();
}
}
public static void DeleteWriter(int id)
{
using (KutuphaneDBContext db = new KutuphaneDBContext())
{
var result = db.Writer.Find(id);
db.Writer.Remove(result);
db.SaveChanges();
}
}
public static void AddWriter(Writer writer)
{
using (KutuphaneDBContext db = new KutuphaneDBContext())
{
db.Writer.Add(writer);
db.SaveChanges();
}
}
public static void AddBook(Book book)
{
using (KutuphaneDBContext db = new KutuphaneDBContext())
{
db.Book.Add(book);
db.SaveChanges();
}
}
public static List <WiewRent> GetALLRent()
{
using (KutuphaneDBContext db = new KutuphaneDBContext())
{
return(db.Rent.Select(p => new WiewRent
{
BookName = p.Book.BookName,
UserName = p.User.UserName,
}).ToList());
}
}
public static List <WiewBook> GetALLBooks()
{
using (KutuphaneDBContext db = new KutuphaneDBContext())
{
return(db.Book.Select(p => new WiewBook
{
BookID = p.BookID,
BookName = p.BookName,
BookSubject = p.BookSubject,
PageCount = p.PageCount,
IsRented = p.IsRented,
ShelfNumber = p.ShelfNumber,
WriterName = p.Writer.WriterName,
}).ToList());
}
}
public static void DeleteBook(Book result)
{
using (KutuphaneDBContext db = new KutuphaneDBContext())
{
}
}
