public static void GrabarMatriculaUpdate(ref MatriculaDto mat, ref OracleConnection con, ref OracleTransaction tran) { var cmdPro = new OracleCommand("PRC_MATRICULA_UPDATE"); cmdPro.CommandType = CommandType.StoredProcedure; cmdPro.Connection = con; cmdPro.Parameters.Add(CreateParameter("iMTRID", mat.MtrId));//NUMBER cmdPro.Parameters.Add(CreateParameter("iMTRDESCRIPCION", mat.MtrDescripcion, 45));//NUMBER cmdPro.Transaction = tran; cmdPro.ExecuteNonQuery();//EJECUTO CONSULTA }
internal override DtoBase PopulateDto(OracleDataReader reader) { var matricula = new MatriculaDto(); // if (!reader.IsDBNull(_mtrId)) { matricula.MtrId = reader.GetInt32(_mtrId); } // if (!reader.IsDBNull(_mtrDescripcion)) {matricula.MtrDescripcion = reader.GetString(_mtrDescripcion); } // if (!reader.IsDBNull(_mttId)) { matricula.MtrTipo.MttId = reader.GetInt32(_mttId); } if (!reader.IsDBNull(_mttDescripcion)) { matricula.MtrTipo.MttDescripcion = reader.GetString(_mttDescripcion); } // IsNew matricula.IsNew = false; return matricula; }
public static void GrabarMatriculaInsert(ref MatriculaDto mat, ref OracleConnection con, ref OracleTransaction tran) { #region INSERT Matricula del profesional ------------------------------------------------------------------- var cmdMat = new OracleCommand("PRC_MATRICULA_INSERT"); cmdMat.CommandType = CommandType.StoredProcedure; cmdMat.Connection = con; cmdMat.Parameters.Add(CreateParameter("iMTRDESCRIPCION", mat.MtrDescripcion, 45));//VARCHAR cmdMat.Parameters.Add(CreateParameter("iMTR_MTTID", mat.MtrTipo.MttId));//NUMBER cmdMat.Parameters.Add(CrearParametroSalida("oMTRID", OracleDbType.Int32));//NUMBER cmdMat.Transaction = tran; cmdMat.ExecuteNonQuery(); var varMtrId = cmdMat.Parameters["oMTRID"].Value; mat.MtrId = Convert.ToInt16(varMtrId.ToString()); #endregion }