public static uf obtenerUF(int MES, int año) { uf retorno = new uf(); DateTime finDeMes = new DateTime(año, MES, 1); int mes = finDeMes.Month; DateTime temp = finDeMes; while (temp.Month == mes) { finDeMes = temp; temp = temp.AddDays(1); } SqlConnection cnx = conexion.crearConexion(); SqlCommand cmd = new SqlCommand(); cmd.Connection = cnx; cmd.CommandText = "SELECT * FROM uf WHERE fecha=@fecha"; cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@fecha", SqlDbType.DateTime).Value= finDeMes; SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { retorno.fecha = (DateTime)dr["fecha"]; retorno.valor = double.Parse(dr["valor"].ToString()); } cnx.Close(); return retorno; }
public static uf obtenerUltimaUF() { uf retorno = new uf(); SqlConnection cnx = conexion.crearConexion(); SqlCommand cmd = new SqlCommand(); cmd.Connection = cnx; cmd.CommandText = "SELECT TOP 1 * FROM uf ORDER BY fecha DESC"; cmd.CommandType = CommandType.Text; SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { retorno.fecha = (DateTime)dr["fecha"]; retorno.valor = double.Parse(dr["valor"].ToString()); } cnx.Close(); return retorno; }