public Collection <Explicacao> FindExplicacoesFromPasso(int id)
{
Collection <Explicacao> resultado = new Collection <Explicacao>();
using (SqlCommand command = _connection.Fetch().CreateCommand())
{
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "Select url, video, id, duvida, Passo_id From Explicacao where Passo_id = @id;";
command.Parameters.Add("@id", SqlDbType.Int).Value = id;
using (SqlDataAdapter adapter = new SqlDataAdapter(command))
{
DataTable tab = new DataTable();
adapter.Fill(tab);
foreach (DataRow row in tab.Rows)
{
Explicacao nova = new Explicacao
{
Url = row["url"].ToString(),
Video = (bool)row["video"],
Id = (int)row["id"],
Duvida = row["duvida"].ToString(),
IdP = (int)row["Passo_id"]
};
resultado.Add(nova);
}
}
}
return(resultado);
}
public Explicacao FindById(int idE)
{
Explicacao obj = new Explicacao();
using (SqlCommand command = _connection.Fetch().CreateCommand())
{
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "Select url, video, id, duvida, Passo_id From Explicacao where id = @idE";
command.Parameters.Add("@idE", SqlDbType.Int).Value = idE;
using (SqlDataAdapter adapter = new SqlDataAdapter(command))
{
DataTable tab = new DataTable();
adapter.Fill(tab);
foreach (DataRow row in tab.Rows)
{
obj = new Explicacao
{
Url = row["url"].ToString(),
Video = (bool)row["video"],
Id = (int)row["id"],
Duvida = row["duvida"].ToString(),
IdP = (int)row["IdP"]
};
}
}
}
return(obj);
}
public bool Insert(Explicacao inserir)
{
bool resultado = true;
using (SqlCommand command = _connection.Fetch().CreateCommand())
{
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "Insert Into Explicacao Values(@url, @video, @duvida, @Passo_id)";
command.Parameters.Add("@url", SqlDbType.VarChar).Value = inserir.Url;
command.Parameters.Add("@video", SqlDbType.Binary).Value = inserir.Video;
command.Parameters.Add("@duvida", SqlDbType.VarChar).Value = inserir.Duvida;
command.Parameters.Add("@Passo_id", SqlDbType.Int).Value = inserir.IdP;
resultado = (command.ExecuteNonQuery() > 0);
}
return(resultado);
}
