public void EliminarTag(UEUTag EU_Tag, String modif)
{
NpgsqlConnection conection = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["Postgresql"].ConnectionString);
try
{
NpgsqlCommand command = new NpgsqlCommand("sp_borrar_palabraclave", conection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("_idpalabra", NpgsqlTypes.NpgsqlDbType.Integer).Value = EU_Tag.IdTag;
command.Parameters.Add("_modif", NpgsqlTypes.NpgsqlDbType.Text).Value = modif;
conection.Open();
command.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
}
public DataTable MostrarTags(UEUTag EU_Tag)
{
DataTable Tags = new DataTable();
NpgsqlConnection conection = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["Postgresql"].ConnectionString);
try
{
NpgsqlCommand command = new NpgsqlCommand("sp_mostrar_palabraclave", conection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("_idproducto", NpgsqlTypes.NpgsqlDbType.Integer).Value = EU_Tag.IdProducto;
conection.Open();
NpgsqlDataAdapter DA = new NpgsqlDataAdapter(command);
DA.Fill(Tags);
}
catch (Exception e)
{
throw e;
}
finally
{
if (conection != null)
{
conection.Close();
}
}
return(Tags);
}
//METODO PARA AÑADIR UN NUEVO TAG
public void añadir_tag(UEUTag data)
{
using (var db = new Mapeo("public"))
{
db.tag.Add(data);
db.SaveChanges();
DBAuditoria.insert(data, crearAcceso(), "dbo", "Palabra_clave");
}
}
//METODO PARA ELIMINAR UN TAG
public void delete_tag(UEUTag tagg)
{
using (var db = new Mapeo("public"))
{
var data = db.tag.Find(tagg.IdTag);
db.Entry(data).State = EntityState.Deleted;
db.SaveChanges();
DBAuditoria.delete(data, crearAcceso(), "dbo", "Palabra_clave");
}
}
private void BorrarPalabra(int idPalabra, String modif)
{
//DDAOTag DAO_Tag = new DDAOTag();
DB_Producto daoTag = new DB_Producto();
UEUTag EU_Tag = new UEUTag();
EU_Tag.IdTag = idPalabra;
daoTag.delete_tag(EU_Tag);
//DAO_Tag.EliminarTag(EU_Tag, modif);
}
public DataTable MostrarTags(UEUTag tag)
{
using (var db = new Mapeo("public"))
{
var data = (from palabraClave in db.tag
where palabraClave.IdProducto == tag.IdProducto
select palabraClave);
ListToDataTable conv = new ListToDataTable();
DataTable res = conv.ToDataTable <UEUTag>(data.ToList <UEUTag>());
return(res);
}
}
private void RegistrarPalabra(String palabra, int idProducto, String modif)
{
//DDAOTag DAO_Tag = new DDAOTag();
DB_Producto daoTag = new DB_Producto();
UEUTag EU_Tag = new UEUTag();
EU_Tag.Palabra = palabra;
EU_Tag.IdProducto = idProducto;
EU_Tag.ModifiedBy = modif;
daoTag.añadir_tag(EU_Tag);
//DAO_Tag.AgregarTag(EU_Tag, modif);
}
public DataTable MostrarTags(int idProducto)
{
DB_Tag daoTag = new DB_Tag();
DataTable Tags = new DataTable();
UEUTag EU_Tag = new UEUTag();
//DDAOTag DAO_Tag = new DDAOTag();
//daoTag.MostrarTags(EU_Tag);
EU_Tag.IdProducto = idProducto;
Tags = daoTag.MostrarTags(EU_Tag);
return(Tags);
}
