public DataTable getDatosTabla()
{
try
{
contexto ct = new contexto();
OracleConnection conn = new OracleConnection();
conn.ConnectionString = ct.getConexion();
conn.Open();
DataTable dt = new DataTable();
string qry = string.Empty;
string tbNombre = ConfigurationManager.AppSettings["tbName"];
string tbAlias = ConfigurationManager.AppSettings["tbAlias"];
qry = "SELECT * from " + tbNombre + " " + tbAlias + " WHERE " + tbAlias + ".ESTADO = 'P'";
OracleDataAdapter dtsOra = new OracleDataAdapter(qry, ct.getConexion());
dtsOra.Fill(dt);
conn.Close();
return(dt);
}
catch (Exception)
{
throw;
}
}//Fin de datosTabla
}//Fin de datosTabla
public string setEstadoFecha(string pAnno, string pConsecutivo)
{
try
{
try
{
contexto ct = new contexto();
OracleConnection conn = new OracleConnection();
conn.ConnectionString = ct.getConexion();
conn.Open();
string tbNombre = ConfigurationManager.AppSettings["tbName"];
string tbAlias = ConfigurationManager.AppSettings["tbAlias"];
OracleCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "update " + tbNombre + " " + tbAlias + " set " + tbAlias + ".estado = 'E', " + tbAlias + ".fecha_gestion = to_date(Sysdate) where " + tbAlias + ".ano = " + pAnno + " and " + tbAlias + ".consecutivo = " + pConsecutivo + "";
cmd.ExecuteNonQuery();
conn.Close();
return("Correo enviado, tabla actualizada correctamente");
}
catch
{
return("No hay correos por enviar");
}
}
catch (Exception e)
{
return("Error en archivo gestion, metodo setEstadoFecha: " + e.Message);
}
}
