public Models.ConsumoIAP Select(Int32 idtarea, Int32 idusuario, DateTime fecha)
{
OpenDbConn();
DAL.ConsumoIAP cConsumoIAP = new DAL.ConsumoIAP(cDblib);
return(cConsumoIAP.Select(idtarea, idusuario, fecha));
}
/// <summary>
/// Obtiene el sumatorio de lo imputado por el usuario en la tarea y la máxima fecha de imputación
/// </summary>
/// <param name="t314_idusuario"></param>
/// <param name="t332_idtarea"></param>
/// <returns></returns>
public Models.ConsumoIAP SelectAcumulados(int t314_idusuario, int t332_idtarea)
{
OpenDbConn();
DAL.ConsumoIAP cConsumoIAP = new DAL.ConsumoIAP(cDblib);
return(cConsumoIAP.SelectAcumulados(t314_idusuario, t332_idtarea));
}
public Models.ConsumoIAP SelectFecha(int t314_idusuario, DateTime t337_fecha)
{
OpenDbConn();
DAL.ConsumoIAP cConsumoIAP = new DAL.ConsumoIAP(cDblib);
return(cConsumoIAP.SelectFecha(t314_idusuario, t337_fecha));
}
public int DeleteTareaRango(int t314_idusuario, int t332_idtarea, DateTime dDesde, DateTime dHasta)
{
Guid methodOwnerID = new Guid("0ddf5a5b-b78d-42fa-b054-3b051f8c127d");
OpenDbConn();
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.beginTransaction(methodOwnerID);
}
try
{
DAL.ConsumoIAP cConsumoIAP = new DAL.ConsumoIAP(cDblib);
int result = cConsumoIAP.DeleteTareaRango(t314_idusuario, t332_idtarea, dDesde, dHasta);
//Finalizar transacción
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.commitTransaction(methodOwnerID);
}
return(result);
}
catch (Exception ex)
{
//rollback
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.rollbackTransaction(methodOwnerID);
}
throw ex;
}
}
internal int Update(Models.ConsumoIAP oConsumoIAP)
{
Guid methodOwnerID = new Guid("3571ea4a-2b1a-45bf-b67c-4e903185410d");
OpenDbConn();
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.beginTransaction(methodOwnerID);
}
try
{
DAL.ConsumoIAP cConsumoIAP = new DAL.ConsumoIAP(cDblib);
int result = cConsumoIAP.Update(oConsumoIAP);
//Finalizar transacción
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.commitTransaction(methodOwnerID);
}
return(result);
}
catch (Exception ex)
{
//rollback
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.rollbackTransaction(methodOwnerID);
}
throw ex;
}
}
public int Insert(Models.ConsumoIAP oConsumoIAP)
{
Guid methodOwnerID = new Guid("9d3f6f3d-e2ab-42e4-b737-03070e71ae9d");
OpenDbConn();
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.beginTransaction(methodOwnerID);
}
try
{
DAL.ConsumoIAP cConsumoIAP = new DAL.ConsumoIAP(cDblib);
int idConsumoIAP = cConsumoIAP.Insert(oConsumoIAP);
//Finalizar transacción
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.commitTransaction(methodOwnerID);
}
return(idConsumoIAP);
}
catch (Exception ex)
{
//rollback
if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
{
cDblib.rollbackTransaction(methodOwnerID);
}
throw ex;
}
}
