public static void Add(Book book) { using (BookStoreDBCon db = new BookStoreDBCon()) { db.Book.Add(book); db.SaveChanges(); } }
public static void Add(User user) { using (BookStoreDBCon db = new BookStoreDBCon()) { db.User.Add(user); db.SaveChanges(); } }
public static void Delete(int id) { using (BookStoreDBCon db = new BookStoreDBCon()) { var result = db.Book.FirstOrDefault(b => b.Id == id); db.Book.Remove(result); db.SaveChanges(); } }
public static int Add(Category cat) { using (BookStoreDBCon db = new BookStoreDBCon()) { cat.Name.Trim().ToUpper(); db.Category.Add(cat); db.SaveChanges(); return(db.Category.FirstOrDefault(w => w.Name == cat.Name).Id); } }
public static int Add(Writer writer) { using (BookStoreDBCon db = new BookStoreDBCon()) { writer.Name.Trim().ToUpper(); db.Writer.Add(writer); db.SaveChanges(); return(db.Writer.FirstOrDefault(w => w.Name == writer.Name).Id); } }