public static List <Category> GetAll()
{
using (BookStoreDBCon db = new BookStoreDBCon())
{
return(db.Category.ToList());
}
}
public static Book Get(int id)
{
using (BookStoreDBCon db = new BookStoreDBCon())
{
return(db.Book.FirstOrDefault(b => b.Id == id));
}
}
public static List <Book> GetAll()
{
using (BookStoreDBCon db = new BookStoreDBCon())
{
return(db.Book.ToList());
}
}
public static List <Book> GetAll(int id)
{
using (BookStoreDBCon db = new BookStoreDBCon())
{
return(db.Book.Where(b => b.CategoryId == id).ToList());
}
}
public static List <Writer> GetAll()
{
using (BookStoreDBCon db = new BookStoreDBCon())
{
return(db.Writer.ToList());
}
}
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);
}
}
public static int GetOrAdd(string categoryName)
{
using (BookStoreDBCon db = new BookStoreDBCon())
{
var cat = db.Category.FirstOrDefault(c => c.Name == categoryName.Trim().ToUpper());
if (cat != null)
{
return(cat.Id);
}
else
{
return(Add(new Category()
{
Name = categoryName
}));
}
}
}
public static int GetOrAdd(string writerName)
{
using (BookStoreDBCon db = new BookStoreDBCon())
{
var writer = db.Writer.FirstOrDefault(w => w.Name == writerName.Trim().ToUpper());
if (writer != null)
{
return(writer.Id);
}
else
{
return(Add(new Writer()
{
Name = writerName
}));
}
}
}
