public List <ComentariosAspNet_Users> ObtenerListadoPorIdImagen(int idImagen) { List <ComentariosAspNet_Users> lista = new List <ComentariosAspNet_Users> (); try { string sql = "SELECT AspNet_Users.*, Comentarios.* FROM Comentarios INNER JOIN AspNet_Users ON Comentarios.UserId = aspnet_Users.UserId WHERE Comentarios.IdImagen = @idImagen"; SqlCommand comando = new SqlCommand(); comando.Connection = BaseDatos.conexion; comando.CommandText = sql; comando.Parameters.AddWithValue("@idImagen", idImagen); BaseDatos.conexion.Open(); SqlDataReader reader = comando.ExecuteReader(); ComentariosAspNet_Users comentariosAspnet_users; while (reader.Read()) { comentariosAspnet_users = new ComentariosAspNet_Users(); comentariosAspnet_users.IdComentario = Convert.ToInt32(reader["IdComentario"]); comentariosAspnet_users.UserId = new Guid(reader["UserId"].ToString()); comentariosAspnet_users.IdImagen = Convert.ToInt32(reader["IdImagen"]); comentariosAspnet_users.Comentario = reader["Comentario"].ToString(); comentariosAspnet_users.FechaPublicacion = Convert.ToDateTime(reader["FechaPublicacion"]); comentariosAspnet_users.MeGusta = Convert.ToInt32(reader["MeGusta"]); comentariosAspnet_users.ApplicationId = new Guid(reader["ApplicationId"].ToString()); comentariosAspnet_users.UserName = reader["UserName"].ToString(); comentariosAspnet_users.LoweredUserName = reader["LoweredUserName"].ToString(); comentariosAspnet_users.MobileAlias = reader["MobileAlias"].ToString(); comentariosAspnet_users.IsAnonymous = Convert.ToInt32(reader["IsAnonymous"]); comentariosAspnet_users.LastActivityDate = Convert.ToDateTime(reader["LastActivityDate"]); lista.Add(comentariosAspnet_users); } } catch (Exception) { throw; } finally { BaseDatos.conexion.Close(); } return(lista); }
public List<ComentariosAspNet_Users> ObtenerListadoPorIdImagen( int idImagen ) { List < ComentariosAspNet_Users > lista = new List < ComentariosAspNet_Users > (); try { string sql = "SELECT AspNet_Users.*, Comentarios.* FROM Comentarios INNER JOIN AspNet_Users ON Comentarios.UserId = aspnet_Users.UserId WHERE Comentarios.IdImagen = @idImagen"; SqlCommand comando = new SqlCommand(); comando.Connection = BaseDatos.conexion; comando.CommandText = sql; comando.Parameters.AddWithValue ( "@idImagen", idImagen ); BaseDatos.conexion.Open(); SqlDataReader reader = comando.ExecuteReader(); ComentariosAspNet_Users comentariosAspnet_users; while ( reader.Read() ) { comentariosAspnet_users = new ComentariosAspNet_Users(); comentariosAspnet_users.IdComentario = Convert.ToInt32 ( reader["IdComentario"] ); comentariosAspnet_users.UserId = new Guid ( reader["UserId"].ToString() ); comentariosAspnet_users.IdImagen = Convert.ToInt32 ( reader["IdImagen"] ); comentariosAspnet_users.Comentario = reader["Comentario"].ToString(); comentariosAspnet_users.FechaPublicacion = Convert.ToDateTime ( reader["FechaPublicacion"] ); comentariosAspnet_users.MeGusta = Convert.ToInt32 ( reader["MeGusta"] ); comentariosAspnet_users.ApplicationId = new Guid ( reader["ApplicationId"].ToString() ); comentariosAspnet_users.UserName = reader["UserName"].ToString(); comentariosAspnet_users.LoweredUserName = reader["LoweredUserName"].ToString(); comentariosAspnet_users.MobileAlias = reader["MobileAlias"].ToString(); comentariosAspnet_users.IsAnonymous = Convert.ToInt32 ( reader["IsAnonymous"] ); comentariosAspnet_users.LastActivityDate = Convert.ToDateTime ( reader["LastActivityDate"] ); lista.Add ( comentariosAspnet_users ); } } catch ( Exception ) { throw; } finally { BaseDatos.conexion.Close(); } return lista; }