public static List <Book> GetBooks(Func <Book, bool> condition = null) { using (var db = new BookWormContext()) { if (condition == null) { return(db.Books.ToList()); } return(db.Books.Where(condition).ToList()); } }
public static void LoadDataFromCSV(string filePath) { using (var db = new BookWormContext()) { using (var reader = new StreamReader(filePath)) { while (!reader.EndOfStream) { try { var values = reader.ReadLine().Split(';'); var book = new Book(); book.ISBN = values[4].Trim(); book.Autor = values[0].Trim(); book.Title = values[1].Trim(); book.Price = double.Parse(values[2]); book.Count = double.Parse(values[3]); var dbBook = db.Books.FirstOrDefault(b => b.ISBN.Equals(book.ISBN)); if (dbBook == null) { db.Books.Add(book); } else { dbBook.Title = book.Title; dbBook.Autor = book.Autor; dbBook.Price = book.Price; dbBook.Count += book.Count; } } catch { continue; } } } db.SaveChanges(); } }