public List <Models.Accion> Catalogo(int t382_idasunto)
{
OpenDbConn();
DAL.Accion cConsulta = new DAL.Accion(cDblib);
return(cConsulta.Catalogo(t382_idasunto));
}
public void BorrarAcciones(List <Models.Accion> lista)
{
Guid methodOwnerID = new Guid("74122BF0-F33B-48BE-B665-9C1A70AF00BC");
OpenDbConn();
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.beginTransaction(methodOwnerID);
}
try
{
DAL.Accion cAccion = new DAL.Accion(cDblib);
foreach (Models.Accion oAccion in lista)
{
cAccion.Delete(oAccion.t383_idaccion);
}
//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 Models.Accion Select(Int32 t383_idaccion)
{
OpenDbConn();
DAL.Accion cAccionPE = new DAL.Accion(cDblib);
return(cAccionPE.Select(t383_idaccion));
}
public int grabar(Models.Accion DatosGenerales, List <Models.AccionRecursos> Integrantes, List <Models.AccionTareas> Tareas)
{
int idReferencia;
bool bConTransaccion = false;
Guid methodOwnerID = new Guid("5590F1B4-7073-4B5F-A4DB-9F301648D151");
OpenDbConn();
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
bConTransaccion = true;
}
if (bConTransaccion)
{
cDblib.beginTransaction(methodOwnerID);
}
try
{
DAL.Accion oAccion = new DAL.Accion(cDblib);
DAL.AccionRecursos oRecursoDAL = new DAL.AccionRecursos(cDblib);
DAL.AccionTareas oTareaDAL = new DAL.AccionTareas(cDblib);
if (DatosGenerales.t383_idaccion == -1)
{
DatosGenerales.t383_fcreacion = System.DateTime.Now;
idReferencia = oAccion.Insert(DatosGenerales);
}
else
{
oAccion.Update(DatosGenerales);
idReferencia = DatosGenerales.t383_idaccion;
}
foreach (Models.AccionRecursos oRecurso in Integrantes)
{
switch (oRecurso.accionBD)
{
case "I":
//Inserción
oRecurso.T383_idaccion = idReferencia;
oRecursoDAL.Insert(oRecurso);
break;
case "D":
//delete
oRecursoDAL.Delete(oRecurso);
break;
case "U":
//update
oRecursoDAL.Update(oRecurso);
break;
}
}
foreach (Models.AccionTareas oTarea in Tareas)
{
switch (oTarea.accionBD)
{
case "I":
//Inserción
oTareaDAL.Insert(oTarea);
break;
case "D":
//delete
oTareaDAL.Delete(oTarea);
break;
}
}
if (bConTransaccion)
{
cDblib.commitTransaction(methodOwnerID);
}
return(idReferencia);
}
catch (Exception ex)
{
//rollback
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.rollbackTransaction(methodOwnerID);
}
throw new Exception(ex.Message);
}
finally
{
//nota.Dispose();
}
}
