public List <Entry> readFromDB(DateTime datumOd, DateTime datumDo)
{
var context = new DataProxyDbContext();
//Console.WriteLine(datumOd);
var data = context.Entries
.Where(x => (((DbFunctions.TruncateTime(x.Datum) >= DbFunctions.TruncateTime(datumOd)) &&
(DbFunctions.TruncateTime(x.Datum) <= DbFunctions.TruncateTime(datumDo)))))
.ToList();
//var data = context.Entries.Where(x => x.Datum >= datumOd && x.Datum <= datumDo).ToList();
//DbFunctions.TruncateTime(datumDo);
return(data);//.ToList();
}
public void writeToDB()
{
var fr = new FileReader();
var context = new DataProxyDbContext();
var data = fr.readFromFile();
foreach (var entry in data)
{
if (!context.Entries.ToList().Contains(entry))
{
var postoji = context.Regions
.Where(x => x.Id == entry.Area)
.Count();
if (postoji == 0)
{
string path = "../../../Logs/MissingArea.txt";
if (!File.Exists(path))
{
File.WriteAllText(path, $"Missing area in DB: {entry.Area}");
}
else
{
File.AppendAllText(path, $"Missing area in DB: {entry.Area}");
}
}
else
{
context.Entries.Add(entry);
}
}
else
{
string path = "../../../Logs/AlreadyExists.txt";
if (!File.Exists(path))
{
File.WriteAllText(path, entry.ToString());
}
else
{
File.AppendAllText(path, entry.ToString());
}
}
}
context.SaveChanges();
}
