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