public List <Models.MOTIVOOCFA> Catalogo(Models.MOTIVOOCFA oMOTIVOOCFAFilter) { OpenDbConn(); DAL.MOTIVOOCFA cMOTIVOOCFA = new DAL.MOTIVOOCFA(cDblib); return(cMOTIVOOCFA.Catalogo(oMOTIVOOCFAFilter)); }
/// <summary> /// Inserta un MOTIVOOCFA /// </summary> internal int Insert(Models.MOTIVOOCFA oMOTIVOOCFA) { try { SqlParameter[] dbparams = new SqlParameter[2] { Param(enumDBFields.t820_tipo, oMOTIVOOCFA.t820_tipo), Param(enumDBFields.t840_descripcion, oMOTIVOOCFA.t840_descripcion) }; return((int)cDblib.Execute("SUP_MOTIVOOCFA_INS", dbparams)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Obtiene todos los MOTIVOOCFA /// </summary> internal List <Models.MOTIVOOCFA> Catalogo(Models.MOTIVOOCFA oMOTIVOOCFAFilter) { Models.MOTIVOOCFA oMOTIVOOCFA = null; List <Models.MOTIVOOCFA> lst = new List <Models.MOTIVOOCFA>(); IDataReader dr = null; try { SqlParameter[] dbparams = new SqlParameter[1] { Param(enumDBFields.t820_tipo, oMOTIVOOCFAFilter.t820_tipo) }; dr = cDblib.DataReader("SUP_MOTIVOOCFA_CAT", dbparams); while (dr.Read()) { oMOTIVOOCFA = new Models.MOTIVOOCFA(); oMOTIVOOCFA.t840_idmotivo = Convert.ToInt32(dr["t840_idmotivo"]); oMOTIVOOCFA.t820_tipo = Convert.ToString(dr["t820_tipo"]); oMOTIVOOCFA.t840_descripcion = Convert.ToString(dr["t840_descripcion"]); oMOTIVOOCFA.desTipo = Convert.ToString(dr["desTipo"]); lst.Add(oMOTIVOOCFA); } return(lst); } catch (Exception ex) { throw ex; } finally { if (dr != null) { if (!dr.IsClosed) { dr.Close(); } dr.Dispose(); } } }
/// <summary> /// Obtiene un MOTIVOOCFA a partir del id /// </summary> internal Models.MOTIVOOCFA Select(Int32 t840_idmotivo) { Models.MOTIVOOCFA oMOTIVOOCFA = null; IDataReader dr = null; try { SqlParameter[] dbparams = new SqlParameter[1] { Param(enumDBFields.t840_idmotivo, t840_idmotivo) }; dr = cDblib.DataReader("SUP_MOTIVOOCFA_SEL", dbparams); if (dr.Read()) { oMOTIVOOCFA = new Models.MOTIVOOCFA(); oMOTIVOOCFA.t840_idmotivo = Convert.ToInt32(dr["t840_idmotivo"]); oMOTIVOOCFA.t820_tipo = Convert.ToString(dr["t820_tipo"]); oMOTIVOOCFA.t840_descripcion = Convert.ToString(dr["t840_descripcion"]); } return(oMOTIVOOCFA); } catch (Exception ex) { throw ex; } finally { if (dr != null) { if (!dr.IsClosed) { dr.Close(); } dr.Dispose(); } } }
public int Update(Models.MOTIVOOCFA oMOTIVOOCFA) { Guid methodOwnerID = new Guid("c04ee672-fb30-4243-b204-a8a7d2139680"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.MOTIVOOCFA cMOTIVOOCFA = new DAL.MOTIVOOCFA(cDblib); int result = cMOTIVOOCFA.Update(oMOTIVOOCFA); //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.MOTIVOOCFA oMOTIVOOCFA) { Guid methodOwnerID = new Guid("b70fc40f-b61f-408b-94d1-fa4a138331dc"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.MOTIVOOCFA cMOTIVOOCFA = new DAL.MOTIVOOCFA(cDblib); int idMOTIVOOCFA = cMOTIVOOCFA.Insert(oMOTIVOOCFA); //Finalizar transacción if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.commitTransaction(methodOwnerID); } return(idMOTIVOOCFA); } 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; } }