public void BorrarAsuntos(List <Models.AsuntoCat> lista)
{
Guid methodOwnerID = new Guid("24F47F9E-3364-41FF-A033-51DCB288D780");
OpenDbConn();
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.beginTransaction(methodOwnerID);
}
try
{
DAL.AsuntoCat cAsunto = new DAL.AsuntoCat(cDblib);
foreach (Models.AsuntoCat asunto in lista)
{
cAsunto.Borrar(asunto.idAsunto);
}
//Finalizar transacción
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.commitTransaction(methodOwnerID);
}
}
catch (Exception ex)
{//rollback
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.rollbackTransaction(methodOwnerID);
}
throw ex;
}
}
public List <Models.AsuntoCat> Catalogo(int idPSN, Nullable <int> idTipoAsunto, Nullable <byte> idEstado)
{
OpenDbConn();
DAL.AsuntoCat cConsulta = new DAL.AsuntoCat(cDblib);
return(cConsulta.Catalogo(idPSN, idTipoAsunto, idEstado));
}