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