public int ImportFile(Stream data)
{
using (var s = _store.OpenSession())
{
var count = s.Query<Drawing>().Count();
var lastDate = count == 0 ?
DateTime.MinValue :
s.Query<Drawing>().OrderByDescending(d => d.DayOfDraw).FirstOrDefault().DayOfDraw;
using (var f = new StreamReader(data))
{
var parsedData = f.Enumerate()
.Select(l => new Drawing(l))
.TakeWhile(d => d.DayOfDraw > lastDate)
.ToList();
foreach (var d in parsedData)
{
try
{
s.Store(d, d.DayOfDraw.ToString("yyyyMMdd"));
}
catch (NonUniqueObjectException)
{
//I don't expect more than 2 drawings on a day in the set.
s.Store(d, d.DayOfDraw.ToString("yyyyMMdd") + "-2");
}
}
s.SaveChanges();
return parsedData.Count;
}
}
}
