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; } }