void StockDB()
{
StockDBApi api = new StockDBApi();
var date = new DateTime(2018, 01, 31);
for (int i = 0; i < 360; i++)
{
if (i >= DateTime.Now.DayOfYear)
{
break;
}
var date1 = date.AddDays(i);
if (!(date1.DayOfWeek == DayOfWeek.Saturday || date1.DayOfWeek == DayOfWeek.Sunday))
{
Globals.Log.Error($"Downloading data for {date1} {i}");
var data = DownloadTodayData(date1);
if (data != null)
{
int count = api.AddOrUpdateEquityInformation(data.Equitys, data.Etfs, data.Indexes);
count += api.AddBhavData(date1, data.BhavData, data.deliveryPosition,
data.IndexBhavData, data.circuitBreaker,
data.highLow52Week);
Globals.Log.Info($"Updated {count} rows");
}
else
{
Globals.Log.Error($"Data does not exists for {date1}");
}
}
}
}
