/*
** Fills or empties the database with cnb Exchange Rates
** Changes are applied to database after ALL Rates are processed
*/
public static void FillDb(List <string> code, List <int> codeAm, List <string> allRows, bool del)
{
using (var db = new CrownContext())
{
int row;
int col;
int i;
int j;
string[] ac;
ExchangeRate er;
CultureInfo ci = new CultureInfo("cs-CZ");
i = 0;
row = allRows.Count - 1;
col = allRows[0].Split('|').Length;
while (++i < row)
{
j = 0;
ac = allRows[i].Split('|');
while (++j < col)
{
er = new ExchangeRate
{
Rate = Convert.ToDecimal(ac[j]) / codeAm[j - 1],
Date = DateTime.ParseExact(ac[0], "dd.MM.yyyy", ci),
Currency = code[j - 1]
};
SearchRate(db, er, del);
}
}
db.SaveChanges();
}
}
/*
** Raise error to incorrect usage
*/
public static void Error(string[] args, bool del)
{
if ((args.Length == 1 && args[0] != "del") || args.Length > 1)
{
Console.WriteLine("usage:\tdotnet run\n\tdotnet run del");
Environment.Exit(-1);
}
CrownContext db = new CrownContext();
if (del && !db.ExchangeRates.Any())
{
Console.WriteLine("No data(");
Environment.Exit(0);
}
}
/*
** Searches for exact Exchange Rate in database
** * adds if Rate do not exist
** * deletes Rate if 'del' flag specified
*/
public static void SearchRate(CrownContext db, ExchangeRate er, bool del)
{
bool q = db.ExchangeRates
.Any(i => i.Date == er.Date && i.Currency == er.Currency);
if (!q && !del)
{
db.ExchangeRates.Add(er);
Console.WriteLine("Adding {0:dd_MM_yyyy} {1:N6}\t{2}", er.Date, er.Rate, er.Currency);
}
else if (q && !del)
{
Console.WriteLine("Exists {0:dd_MM_yyyy} {1:N6}\t{2}", er.Date, er.Rate, er.Currency);
}
else if (q)
{
var r = db.ExchangeRates
.Where(e => e.Date == er.Date && e.Currency == er.Currency)
.First();
db.ExchangeRates.Remove(r);
Console.WriteLine("Deleting {0:dd_MM_yyyy} {1:N6}\t{2}", er.Date, er.Rate, er.Currency);
}
}
