private void ShowLastUpdateValue()
{
dLastUSDValue = 0;
// Load latest USD Exchange Rate
string xSQL = "declare @xMaxFecha Date=(select MAX(FECHA) Fecha from FORTALEZA_PRD.dbo.CF_VALOR_DOLAR); \n" +
"select @xMaxFecha dMaxFecha, VALOR fUSD from FORTALEZA_PRD.dbo.CF_VALOR_DOLAR where FECHA=@xMaxFecha; \n";
if (RSLib_ODBC.ReadSQL(xSQL, false))
{
if (!DateTime.TryParse(RSLib_ODBC.GlobalReturnValue[0], out xLastUpdate))
{
xLastUpdate = new DateTime(2012, 1, 1);
}
dLastUSDValue = RSLib_String.AToF(RSLib_ODBC.GlobalReturnValue[1]);
lblLastUpdate.Text = "$" + dLastUSDValue.ToString("#,##0.0000") + " al " + xLastUpdate.ToString("dd/MM/yyyy");
lblLastUpdate.Visible = true;
}
else
{
RSLib_CriticalError.CriticalErrorHandler("Form Load on RS DOF ExchangeRate",
"Err-xxx", "Failure Reading last Update Rate",
"Falla leyendo el último Tipo de Cambio", "RS DOF ExhangeRate", xSQL);
}
}
private void UpdateFromDOF()
{
string xProvider = "http://dof.gob.mx/indicadores.xml";
WebRequest SendReq = HttpWebRequest.Create(xProvider);
WebResponse GetRes = SendReq.GetResponse();
System.IO.Stream StreamRes = GetRes.GetResponseStream();
StreamReader ResStrmRdr = new StreamReader(StreamRes, Encoding.UTF8);
string xDOFOriginal = ResStrmRdr.ReadToEnd();
StreamRes.Close();
GetRes.Close();
string xDOF = RSLib_String.MyStringProvider(xDOFOriginal, "<title>DOLAR</title>", "</item>");
xDOF = xDOF.Replace("\n", "");
xDOF = xDOF.Replace("\t", "");
xDOF = xDOF.Replace(" ", "");
string xValue = RSLib_String.MyStringProvider(xDOF, "<description>", "</description>");
string xDate = RSLib_String.MyStringProvider(xDOF, "<valueDate>", "</valueDate>");
double fValue = RSLib_String.AToF(xValue);
DateTime xLocalClock = DateTime.Now;
string xSQL = "";
if (!DateTime.TryParse(xDate, out xLocalClock) || fValue == 0)
{
xLocalClock = DateTime.Now;
xSQL = "select distinct CONVERT(date,FECHA_FESTIVO) Festivo \n" +
"from FORTALEZA_PRD.dbo.CF_DIAS_FESTIVOS \n" +
"where FECHA_FESTIVO='" + xLocalClock.ToString(WhatIsDateFormat) + "' \n" +
"; \n";
if (!RSLib_ODBC.ReadSQL(xSQL, false))
{
if (xLocalClock.DayOfWeek == DayOfWeek.Saturday || xLocalClock.DayOfWeek == DayOfWeek.Sunday)
{
// IT is Saturday or Sunday - Nothing 2 save, then use the latest
fValue = dLastUSDValue;
xLocalClock = DateTime.Now;
}
else
{
// No Es feriado: Ignore
RSLib_CriticalError.CriticalErrorHandler("Form UpdateFromDOF on RS DOF ExchangeRate",
"Err-xxx", "Failure Getting Update Rate from DOF",
"Falla leyendo el WebService", "RS DOF ExhangeRate", xDOFOriginal);
return;
}
}
else
{
// IT is feriado - Nothing 2 save, then use the latest
fValue = dLastUSDValue;
xLocalClock = DateTime.Now;
}
}
xSQL = "insert into FORTALEZA_PRD.dbo.CF_VALOR_DOLAR (COD_EMPRESA,FECHA,VALOR) VALUES('00030','" + xLocalClock.ToString(WhatIsDateFormat) +
"','" + fValue.ToString() + "'); \n";
if (!RSLib_ODBC.RunSQL(xSQL))
{
RSLib_CriticalError.CriticalErrorHandler("Form UpdateFromDOF on RS DOF ExchangeRate",
"Err-xxx", "Failure Updating Table",
"Falla actualizando tabla", "RS DOF ExhangeRate", xSQL);
}
else
{
// Show
ShowLastUpdateValue();
// Send eMail Notificaciones
string xMessage =
"Fecha: \t" + xLocalClock.ToString(WhatIsDateFormat) + "\n" +
"Valor Tipo de Cambio: \t" + fValue.ToString("#,##0.0000") + "\n";
RSLib_ODBC.RunLOG("PLD-001", "Exchange Rate Updated -> " + xMessage.Replace("\n", " ").Replace("\t", "-"));
string xBody = RSFormaTable(xMessage, "Tipo de Cambio - Sistema PLD", true, true, false, true, true);
if (!RSLib_SendMail.SendMailMessage(RSLib_SendMail.SMTP_From, "Oficial.Cumplimiento" + WhatIsDomain, "", "Help.Desk" + WhatIsDomain, "[Tipo de Cambio] " + xLocalClock.ToString(WhatIsDateFormat), xBody, true))
{
RSLib_CriticalError.CriticalErrorHandler("Form UpdateFromDOF on RS DOF ExchangeRate",
"Err-xxx", "Failure sending email Notificacion",
"Falla enviando correo de notificacion", "RS DOF ExhangeRate", "");
}
}
}