public List <Models.SALDOSSAP> Catalogo()
{
OpenDbConn();
DAL.SALDOSSAP cSALDOSSAP = new DAL.SALDOSSAP(cDblib);
return(cSALDOSSAP.Catalogo());
}
public int Delete()
{
Guid methodOwnerID = new Guid("b25cd191-51df-4f80-9499-fc9369f14716");
OpenDbConn();
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.beginTransaction(methodOwnerID);
}
try
{
DAL.SALDOSSAP cSALDOSSAP = new DAL.SALDOSSAP(cDblib);
int result = cSALDOSSAP.Delete();
//Finalizar transacción
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.commitTransaction(methodOwnerID);
}
return(result);
}
catch (Exception ex)
{
//rollback
//if (cDblib.Transaction.ownerID.Equals(new Guid())) cDblib.rollbackTransaction(methodOwnerID);
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.rollbackTransaction(methodOwnerID);
}
throw ex;
}
}
public int Insert(Models.SALDOSSAP oSALDOSSAP)
{
Guid methodOwnerID = new Guid("00e023c4-b023-40c9-a0a9-35babef8c832");
OpenDbConn();
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.beginTransaction(methodOwnerID);
}
try
{
DAL.SALDOSSAP cSALDOSSAP = new DAL.SALDOSSAP(cDblib);
int idSALDOSSAP = cSALDOSSAP.Insert(oSALDOSSAP);
//Finalizar transacción
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.commitTransaction(methodOwnerID);
}
return(idSALDOSSAP);
}
catch (Exception ex)
{
//rollback
//if (cDblib.Transaction.ownerID.Equals(new Guid())) cDblib.rollbackTransaction(methodOwnerID);
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.rollbackTransaction(methodOwnerID);
}
throw ex;
}
}
public int Pasar_a_SUPER(int iFecha)
{
Guid methodOwnerID = new Guid("43960C35-E254-4CCD-8A18-4245BB1B9EB5");
OpenDbConn();
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.beginTransaction(methodOwnerID);
}
try
{
DAL.SALDOSSAP cSALDOSSAP = new DAL.SALDOSSAP(cDblib);
int result = cSALDOSSAP.Pasar_a_SUPER(iFecha);
//Finalizar transacción
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.commitTransaction(methodOwnerID);
}
return(result);
}
catch (Exception ex)
{
//rollback
//if (cDblib.Transaction.ownerID.Equals(new Guid())) cDblib.rollbackTransaction(methodOwnerID);
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.rollbackTransaction(methodOwnerID);
}
throw ex;
}
}