internal int Insert(Models.TipoDocumento oTipoDocumento) { Guid methodOwnerID = new Guid("d5c7e134-54e7-45dc-8725-5f9030f61108"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try{ DAL.TipoDocumento cTipoDocumento = new DAL.TipoDocumento(cDblib); int idTipoDocumento = cTipoDocumento.Insert(oTipoDocumento); //Finalizar transacción if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.commitTransaction(methodOwnerID); } return(idTipoDocumento); } catch (Exception ex) { //rollback if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.rollbackTransaction(methodOwnerID); } throw ex; } }
internal int Update(Models.TipoDocumento oTipoDocumento) { Guid methodOwnerID = new Guid("dc9a160a-65f5-43c2-a854-95d38b1d7606"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try{ DAL.TipoDocumento cTipoDocumento = new DAL.TipoDocumento(cDblib); int result = cTipoDocumento.Update(oTipoDocumento); //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 List <Models.TipoDocumento> Catalogo(Models.TipoDocumento oTipoDocumentoFilter) { OpenDbConn(); DAL.TipoDocumento cTipoDocumento = new DAL.TipoDocumento(cDblib); return(cTipoDocumento.Catalogo(oTipoDocumentoFilter)); }
internal Models.TipoDocumento Select(Byte ta211_idtipodocumento) { OpenDbConn(); DAL.TipoDocumento cTipoDocumento = new DAL.TipoDocumento(cDblib); return(cTipoDocumento.Select(ta211_idtipodocumento)); }
internal int Delete(Byte ta211_idtipodocumento) { Guid methodOwnerID = new Guid("2d46cbc9-b60d-458d-8373-6389a539a70c"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try{ DAL.TipoDocumento cTipoDocumento = new DAL.TipoDocumento(cDblib); int result = cTipoDocumento.Delete(ta211_idtipodocumento); //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 List <Models.TipoDocumento> Catalogo() { OpenDbConn(); DAL.TipoDocumento cTipoDocumento = new DAL.TipoDocumento(cDblib); return(cTipoDocumento.Catalogo()); }
internal List <Models.TipoDocumento> GrabarListaTiposDocumento(List <Models.TipoDocumento> lstTiposDocumento) { Guid methodOwnerID = new Guid("f672bc44-f3fc-4102-8b50-2d3452b19198"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { //Datatable de tipos de tareas preventa DataTable dtTipoDocumentos = new DataTable(); dtTipoDocumentos.Columns.Add(new DataColumn("ta211_idtipodocumento", typeof(int))); dtTipoDocumentos.Columns.Add(new DataColumn("ta211_denominacion", typeof(string))); dtTipoDocumentos.Columns.Add(new DataColumn("ta211_orden", typeof(int))); dtTipoDocumentos.Columns.Add(new DataColumn("ta211_activo", typeof(bool))); foreach (Models.TipoDocumento oTipoDocumento in lstTiposDocumento) { DataRow rowAccion = dtTipoDocumentos.NewRow(); rowAccion["ta211_idtipodocumento"] = oTipoDocumento.ta211_idtipodocumento; rowAccion["ta211_denominacion"] = oTipoDocumento.ta211_denominacion; rowAccion["ta211_orden"] = oTipoDocumento.ta211_orden; rowAccion["ta211_activo"] = oTipoDocumento.ta211_estadoactiva; dtTipoDocumentos.Rows.Add(rowAccion); } DAL.TipoDocumento cTipoDocumento = new DAL.TipoDocumento(cDblib); List <Models.TipoDocumento> lstTipoDocumento = cTipoDocumento.GrabarDocumentos(dtTipoDocumentos); //Finalizar transacción if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.commitTransaction(methodOwnerID); } return(lstTiposDocumento); } catch (Exception ex) { //rollback if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.rollbackTransaction(methodOwnerID); } throw ex; } }