private void start(String[] args)
{
DateTime start = DateTime.Now;
try {
processArguments(args);
LogMgr.log("Proceso iniciado");
db = DB.getInstance();
web = Provider.getProvider();
//r = R.getInstance();
CFG.setEuro(web.getEuro());
SrvCierres srv = new SrvCierres();
List <Cierres> monedas = srv.getUltimoCierre();
Q1R r = Q1R.getInstance();
//r.testR();
//if ((CFG.mode & 0x01) != 0) processCotizacion(monedas);
//if ((CFG.mode & 0x02) != 0) processCierre(monedas);
processCierre(monedas);
}
catch (Exception e) {
LogMgr.err(e.Message);
} finally {
db.close();
}
TimeSpan timeDiff = DateTime.Now - start;
LogMgr.log("Proceso finalizado: " + timeDiff.ToString());
}
private void loadDay(String moneda, long fecha, Excel.Worksheet sh)
{
String[] headers = { "Moneda", "Epoch", "Fecha", "Open", "High", "Low", "Close" };
SrvCierres srvCierre = new SrvCierres();
Excel.Range rng = sh.Cells;
rng.ClearContents();
int row = 1;
for (int idx = 0; idx < headers.Length; idx++)
{
sh.Cells[row, idx + 1] = headers[idx];
}
row++;
foreach (Row r in srvCierre.getData(moneda, fecha))
{
int col = 1;
sh.Cells[row, col++] = r.get("Moneda");
sh.Cells[row, col++] = r.get("Epoch");
sh.Cells[row, col++] = r.get("Fecha");
sh.Cells[row, col++] = r.get("FOpen");
sh.Cells[row, col++] = r.get("FHigh");
sh.Cells[row, col++] = r.get("FLow");
sh.Cells[row, col++] = r.get("FClose");
row++;
}
}
private void processCierre(List <Cierres> monedas)
{
LogMgr.log("Recuperando cierres");
try {
List <Cierre> cierres = web.getCierres(monedas);
SrvCierres srv = new SrvCierres();
srv.insert(cierres);
//r.calculate(srv, TABLES.CIERRRES);
}
catch (Exception e) {
LogMgr.err(e.Message);
}
}
