//Eliminar contacto
public int?eliminarCont(int id_contacto)
{
int?regAfec;
using (DataAccessLayer dal = new DataAccessLayer())
{
var connection = dal.AbrirConexion();
SqlTransaction transaction = connection.BeginTransaction();
try
{
regAfec = dal.EjecutarEliminacion(transaction, connection, id_contacto);
transaction.Commit();
return(regAfec);
}
catch (Exception e)
{
transaction.Rollback();
return(null);
}
finally
{
transaction.Dispose();
}
}
}
//Busqueda de contactos segun filtro
public List <Contacto> EjecutarConsultaFiltro(Filtro filter)
{
try
{
using (DataAccessLayer dal = new DataAccessLayer())
{
var connection = dal.AbrirConexion();
//DataSet ds = dal.EjecutarQueryConPaginado(connection, filter);
DataSet ds = dal.ConsultarContactosFilter(connection, filter);
return(SetDsContactos(ds));
}
}
catch (Exception e)
{
throw new Exception("ERROR GENERAL EN AgendaABM.EjecutarConsultaFiltro", e);
}
}