public Blog_tag Buscar(int id, string tag)
{
try
{
Blog_tag Blog = null;
DBSession session = new DBSession();
Query quey = session.CreateQuery("SELECT isnull(blog_id, 0) AS blog_id, isnull(tag, '') AS tag FROM Blog_tag WHERE blog_id = @blog_id and tag = @tag");
quey.SetParameter("blog_id", id)
.SetParameter("tag", tag);
IDataReader reader = quey.ExecuteQuery();
if (reader.Read())
{
Blog = new Blog_tag(new Blog(Convert.ToInt32(reader["blog_id"])), Convert.ToString(reader["tag"]));
}
reader.Close();
session.Close();
return(Blog);
}
catch (Exception error)
{
throw error;
}
}
public void Excluir(Blog_tag variavel)
{
try
{
DBSession session = new DBSession();
Query query = session.CreateQuery("DELETE FROM blog_tag WHERE blog_id = @blog_id AND tag = @tag");
query.SetParameter("blog_id", variavel.blog_id.blog_id)
.SetParameter("tag", variavel.tag);
query.ExecuteUpdate();
session.Close();
}
catch (Exception erro)
{
throw erro;
}
}
public void Salvar(Blog_tag variavel)
{
try
{
DBSession session = new DBSession();
Query query = session.CreateQuery("INSERT INTO Blog_tag (blog_id, tag) VALUES (@blog_id, @tag) ");
query.SetParameter("blog_id", variavel.blog_id.blog_id)
.SetParameter("tag", variavel.tag);
query.ExecuteUpdate();
session.Close();
}
catch (Exception erro)
{
throw erro;
}
}
