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()) { } }