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