internal List <Models.ParticipanteTareaPreventa> Catalogo(Models.ParticipanteTareaPreventa oParticipanteTareaPreventaFilter) { OpenDbConn(); DAL.ParticipanteTareaPreventa cParticipanteTareaPreventa = new DAL.ParticipanteTareaPreventa(cDblib); return(cParticipanteTareaPreventa.Catalogo(oParticipanteTareaPreventaFilter)); }
/// <summary> /// Inserta un ParticipanteTareaPreventa /// </summary> internal int Insert(Models.ParticipanteTareaPreventa oParticipanteTareaPreventa) { try { SqlParameter[] dbparams = new SqlParameter[3] { Param(enumDBFields.ta207_idtareapreventa, oParticipanteTareaPreventa.ta207_idtareapreventa), Param(enumDBFields.t001_idficepi_participante, oParticipanteTareaPreventa.t001_idficepi_participante), Param(enumDBFields.ta214_estado, oParticipanteTareaPreventa.ta214_estado) }; return((int)cDblib.Execute("SUPER.SIC_ParticipanteTareaPreventa_INS", dbparams)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Actualiza un ParticipanteTareaPreventa a partir del id /// </summary> internal int Update(Models.ParticipanteTareaPreventa oParticipanteTareaPreventa) { try { SqlParameter[] dbparams = new SqlParameter[3] { Param(enumDBFields.ta207_idtareapreventa, oParticipanteTareaPreventa.ta207_idtareapreventa), Param(enumDBFields.t001_idficepi_participante, oParticipanteTareaPreventa.t001_idficepi_participante), Param(enumDBFields.ta214_estado, oParticipanteTareaPreventa.ta214_estado) }; return((int)cDblib.Execute("SIC_PARTICIPANTETAREAPREVENTA_ESTADO_U", dbparams)); } catch (Exception ex) { throw ex; } }
public List <Models.ParticipanteTareaPreventa> ObtenerParticipantes(int ta207_idtareapreventa) { Models.ParticipanteTareaPreventa oParticipanteTareaPreventa = null; List <Models.ParticipanteTareaPreventa> lst = new List <Models.ParticipanteTareaPreventa>(); IDataReader dr = null; try { SqlParameter[] dbparams = new SqlParameter[1] { Param(enumDBFields.ta207_idtareapreventa, ta207_idtareapreventa) }; dr = cDblib.DataReader("SIC_TAREAPARTICIPANTES_C", dbparams); while (dr.Read()) { oParticipanteTareaPreventa = new Models.ParticipanteTareaPreventa(); oParticipanteTareaPreventa.ta214_estado = Convert.ToString(dr["ta214_estado"]); oParticipanteTareaPreventa.t001_idficepi_participante = Convert.ToInt32(dr["t001_idficepi_participante"]); oParticipanteTareaPreventa.participante = Convert.ToString(dr["participante"]); lst.Add(oParticipanteTareaPreventa); } return(lst); } catch (Exception ex) { throw ex; } finally { if (dr != null) { if (!dr.IsClosed) { dr.Close(); } dr.Dispose(); } } }
/// <summary> /// Obtiene todos los ParticipanteTareaPreventa /// </summary> internal List <Models.ParticipanteTareaPreventa> Catalogo(Models.ParticipanteTareaPreventa oParticipanteTareaPreventaFilter) { Models.ParticipanteTareaPreventa oParticipanteTareaPreventa = null; List <Models.ParticipanteTareaPreventa> lst = new List <Models.ParticipanteTareaPreventa>(); IDataReader dr = null; try { SqlParameter[] dbparams = new SqlParameter[1] { Param(enumDBFields.ta214_estado, oParticipanteTareaPreventaFilter.ta214_estado) }; dr = cDblib.DataReader("SUPER.SIC_ParticipanteTareaPreventa_CAT", dbparams); while (dr.Read()) { oParticipanteTareaPreventa = new Models.ParticipanteTareaPreventa(); oParticipanteTareaPreventa.ta207_idtareapreventa = Convert.ToInt32(dr["ta207_idtareapreventa"]); oParticipanteTareaPreventa.t001_idficepi_participante = Convert.ToInt32(dr["t001_idficepi_participante"]); oParticipanteTareaPreventa.ta214_estado = Convert.ToString(dr["ta209_estado"]); lst.Add(oParticipanteTareaPreventa); } return(lst); } catch (Exception ex) { throw ex; } finally { if (dr != null) { if (!dr.IsClosed) { dr.Close(); } dr.Dispose(); } } }
/// <summary> /// Obtiene un ParticipanteTareaPreventa a partir del id /// </summary> internal Models.ParticipanteTareaPreventa Select(Int32 ta207_idtareapreventa, Int32 t001_idficepi_participante) { Models.ParticipanteTareaPreventa oParticipanteTareaPreventa = null; IDataReader dr = null; try { SqlParameter[] dbparams = new SqlParameter[2] { Param(enumDBFields.ta207_idtareapreventa, ta207_idtareapreventa), Param(enumDBFields.t001_idficepi_participante, t001_idficepi_participante) }; dr = cDblib.DataReader("SUPER.SIC_ParticipanteTareaPreventa_SEL", dbparams); if (dr.Read()) { oParticipanteTareaPreventa = new Models.ParticipanteTareaPreventa(); oParticipanteTareaPreventa.ta207_idtareapreventa = Convert.ToInt32(dr["ta207_idtareapreventa"]); oParticipanteTareaPreventa.t001_idficepi_participante = Convert.ToInt32(dr["t001_idficepi_participante"]); oParticipanteTareaPreventa.ta214_estado = Convert.ToString(dr["ta209_estado"]); } return(oParticipanteTareaPreventa); } catch (Exception ex) { throw ex; } finally { if (dr != null) { if (!dr.IsClosed) { dr.Close(); } dr.Dispose(); } } }
public int Update(Models.ParticipanteTareaPreventa oParticipanteTareaPreventa) { Guid methodOwnerID = new Guid("2b6e2ba1-fe0f-4bff-a3ae-d03595b16f5b"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.ParticipanteTareaPreventa cParticipanteTareaPreventa = new DAL.ParticipanteTareaPreventa(cDblib); int result = cParticipanteTareaPreventa.Update(oParticipanteTareaPreventa); //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 Insert(Models.ParticipanteTareaPreventa oParticipanteTareaPreventa) { Guid methodOwnerID = new Guid("521885ca-75bf-471c-af33-813d4b5dc803"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.ParticipanteTareaPreventa cParticipanteTareaPreventa = new DAL.ParticipanteTareaPreventa(cDblib); int idParticipanteTareaPreventa = cParticipanteTareaPreventa.Insert(oParticipanteTareaPreventa); //Finalizar transacción if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.commitTransaction(methodOwnerID); } return(idParticipanteTareaPreventa); } catch (Exception ex) { //rollback if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.rollbackTransaction(methodOwnerID); } throw ex; } }