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