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;
}
