/// <summary> /// Obtiene todos los PRIOALERTAS /// </summary> internal List <Models.PRIOALERTAS> Catalogo() { Models.PRIOALERTAS oPRIOALERTAS = null; List <Models.PRIOALERTAS> lst = new List <Models.PRIOALERTAS>(); IDataReader dr = null; try { SqlParameter[] dbparams = new SqlParameter[0] { }; dr = cDblib.DataReader("SUP_PRIOALERTAS_C", dbparams); while (dr.Read()) { oPRIOALERTAS = new Models.PRIOALERTAS(); oPRIOALERTAS.t820_idalerta_1 = Convert.ToByte(dr["t820_idalerta_1"]); oPRIOALERTAS.t820_idalerta_2 = Convert.ToByte(dr["t820_idalerta_2"]); oPRIOALERTAS.t820_idalerta_g = Convert.ToByte(dr["t820_idalerta_g"]); oPRIOALERTAS.denAlert1 = dr["denAlert1"].ToString(); oPRIOALERTAS.denAlert2 = dr["denAlert2"].ToString(); oPRIOALERTAS.denAlertG = dr["denAlertG"].ToString(); oPRIOALERTAS.grupo1 = Convert.ToByte(dr["grupo1"]); oPRIOALERTAS.grupo2 = Convert.ToByte(dr["grupo2"]); oPRIOALERTAS.grupoG = Convert.ToByte(dr["grupoG"]); oPRIOALERTAS.denGrupo1 = dr["denGrupo1"].ToString(); lst.Add(oPRIOALERTAS); } return(lst); } catch (Exception ex) { throw ex; } finally { if (dr != null) { if (!dr.IsClosed) { dr.Close(); } dr.Dispose(); } } }
/// <summary> /// Actualiza un PRIOALERTAS a partir del id /// </summary> internal int Update(Models.PRIOALERTAS oPRIOALERTAS) { try { SqlParameter[] dbparams = new SqlParameter[3] { Param(enumDBFields.t820_idalerta_1, oPRIOALERTAS.t820_idalerta_1), Param(enumDBFields.t820_idalerta_2, oPRIOALERTAS.t820_idalerta_2), Param(enumDBFields.t820_idalerta_g, oPRIOALERTAS.t820_idalerta_g) }; return((int)cDblib.Execute("SUP_PRIOALERTAS_UPD", dbparams)); } catch (Exception ex) { throw ex; } }
public int Update(Models.PRIOALERTAS oPRIOALERTAS) { Guid methodOwnerID = new Guid("1efd6df0-8ebe-42e3-a1e1-ef71b020dc68"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.PRIOALERTAS cPRIOALERTAS = new DAL.PRIOALERTAS(cDblib); int result = cPRIOALERTAS.Update(oPRIOALERTAS); //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.PRIOALERTAS oPRIOALERTAS) { Guid methodOwnerID = new Guid("afb9ebac-943a-4752-a77c-b7d83c7eee80"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.PRIOALERTAS cPRIOALERTAS = new DAL.PRIOALERTAS(cDblib); int idPRIOALERTAS = cPRIOALERTAS.Insert(oPRIOALERTAS); //Finalizar transacción if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.commitTransaction(methodOwnerID); } return(idPRIOALERTAS); } 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; } }