public static Ideia EditarIdeia(string id)
{
var userForm = new Ideia();
userForm.Tags = new List<string>();
try
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("SELECT * FROM Ideias WHERE Id = @id", con))
{
cmd.Parameters.AddWithValue("@id", id);
con.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
userForm.Titulo = reader[1].ToString();
userForm.Descricao = reader[2].ToString();
}
}
con.Close();
}
using (SqlCommand cmd = new SqlCommand("SELECT Tag FROM Tags, TagsIdeia WHERE id=IdTag and IdIdeia = @id", con))
{
cmd.Parameters.AddWithValue("@id", id);
con.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
userForm.Tags.Add(reader[0].ToString());
}
} con.Close();
}
}
}
catch (Exception ex)
{
}
return userForm;
}
public static Ideia ObterIdeia(int id)
{
var formIdeia = new Ideia();
formIdeia.Tags = new List<string>();
try
{
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
using (var cmd = new SqlCommand("SELECT i.Nome, i.Publica, p.Pontuação, SUM(i.Visualizacoes) sumVisualizacoes, i.Descricao " +
"FROM Ideias i " +
"LEFT JOIN Pontação p ON (i.Id = p.IdIdeia) " +
"WHERE i.Id = @id " +
"GROUP BY i.Nome, i.Publica, p.Pontuação, i.Descricao", con))
{
cmd.Parameters.AddWithValue("@id", id);
con.Open();
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
formIdeia.Titulo = reader[0].ToString();
formIdeia.Tipo = reader[1].ToString() == "True" ? "Pública" : "Privada";
formIdeia.Pontuacao = String.IsNullOrEmpty(reader[2].ToString()) ? 0 : Int32.Parse(reader[2].ToString());
formIdeia.SomaVisualizacoes = String.IsNullOrEmpty(reader[3].ToString()) ? 0 : Int32.Parse(reader[3].ToString());
formIdeia.Descricao = reader[4].ToString();
}
}
}
using (var cmd = new SqlCommand("SELECT i.Imagem " +
"FROM IdeiasImagens i " +
"WHERE i.IdIdeia = @id", con))
{
cmd.Parameters.AddWithValue("@id", id);
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
formIdeia.Imagens = new List<string> { reader[0].ToString() };
}
}
}
using (var cmd = new SqlCommand("SELECT ta.Tag " +
"FROM TagsIdeia t " +
"LEFT JOIN Tags ta ON (ta.Id = t.IdTag)" +
"WHERE t.IdIdeia = @id", con))
{
cmd.Parameters.AddWithValue("@id", id);
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
formIdeia.Tags = new List<string> { reader[0].ToString() };
}
}
con.Close();
}
}
}
catch (Exception ex)
{
}
return formIdeia;
}
