public static DatosIP ObtenerIP(int TipoConsulta, string Correo) { DatosIP Codigo = new DatosIP(); SqlConnection connection = new SqlConnection(connectionStringSGUV); SqlCommand command = new SqlCommand("PJ_DatosEnvioCorreo", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@TipoConsulta", TipoConsulta); command.Parameters.AddWithValue("@TipoCorreo", Correo); connection.Open(); using (SqlDataReader sdr = command.ExecuteReader()) { while (sdr.Read()) { Codigo.IP_Publica = Convert.ToString(sdr["IPPublicada"]); Codigo.Publicado = Convert.ToInt32(sdr["Publicada"]); } } return(Codigo); }
public static DatosIP ObtenerIP(int TipoConsulta, string Correo) { DatosIP Codigo = new DatosIP(); SqlConnection connection = new SqlConnection(connectionStringSGUV); SqlCommand command = new SqlCommand("PJ_DatosEnvioCorreo", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@TipoConsulta", TipoConsulta); command.Parameters.AddWithValue("@TipoCorreo", Correo); connection.Open(); using (SqlDataReader sdr = command.ExecuteReader()) { while (sdr.Read()) { Codigo.IP_Publica = Convert.ToString(sdr["IPPublicada"]); Codigo.Publicado = Convert.ToInt32(sdr["Publicada"]); } } return Codigo; }