/// <summary>
/// Actualiza un ReceptoresAvisos a partir del id
/// </summary>
internal int Update(Models.ReceptoresAvisos oReceptoresAvisos)
{
try
{
SqlParameter[] dbparams = new SqlParameter[2] {
Param(enumDBFields.t001_idficepi, oReceptoresAvisos.t001_idficepi),
Param(enumDBFields.t399_avisopreventa, oReceptoresAvisos.t399_avisopreventa)
};
return((int)cDblib.Execute("SIC_ReceptoresAvisos_U", dbparams));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Obtiene todos los ReceptoresAvisos de preventa
/// </summary>
internal List <Models.ReceptoresAvisos> Catalogo()
{
Models.ReceptoresAvisos oP = null;
List <Models.ReceptoresAvisos> lst = new List <Models.ReceptoresAvisos>();
IDataReader dr = null;
try
{
SqlParameter[] dbparams = new SqlParameter[0] {
};
dr = cDblib.DataReader("SIC_ReceptoresAvisos_C", dbparams);
while (dr.Read())
{
oP = new Models.ReceptoresAvisos();
oP.t001_idficepi = Convert.ToInt32(dr["t001_idficepi"]);
oP.denProfesional = dr["Profesional"].ToString();
oP.t399_avisopreventa = (bool)dr["t399_avisopreventa"];
lst.Add(oP);
}
return(lst);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dr != null)
{
if (!dr.IsClosed)
{
dr.Close();
}
dr.Dispose();
}
}
}
public int Update(Models.ReceptoresAvisos oReceptoresAvisos)
{
Guid methodOwnerID = new Guid("D8198EC4-92C4-49ED-9054-2C550CE39AFD");
OpenDbConn();
if (cDblib.Transaction.ownerID.Equals(new Guid()))
{
cDblib.beginTransaction(methodOwnerID);
}
try
{
DAL.ReceptoresAvisos cReceptoresAvisos = new DAL.ReceptoresAvisos(cDblib);
int result = cReceptoresAvisos.Update(oReceptoresAvisos);
//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;
}
}
