private int SafeGetInt(OdbcDataReader reader, string column, int defaultValue) { try { if (reader.IsDBNull(reader.GetOrdinal(column))) { logger.Debug("Reader column {column} is DbNull. Returning default value of {defaultValue}.", column, defaultValue); return(defaultValue); } else { return(reader.GetInt32(reader.GetOrdinal(column))); } } catch (InvalidCastException ex) { string columnValue = reader.GetString(reader.GetOrdinal(column)); logger.Info(ex, "Could not cast column {column} value {value} as Int32. returning default value of {defaultValue}.", column, columnValue, defaultValue); return(defaultValue); } catch (Exception ex) { logger.Error("An unexpected error occurred while processing reader column {column}. Error: {errorMessage}", column, ex.Message); throw; } }
public List <Turma> listaturma() { List <Turma> retorno = new List <Turma>(); try { this.abrirConexao(); OdbcCommand DbCommand = conn.CreateCommand(); DbCommand.CommandText = "SELECT idTurma, NomeTur FROM Turma"; OdbcDataReader DbReader = DbCommand.ExecuteReader(); while (DbReader.Read()) { Turma turma = new Turma(); turma.IdTurma = (DbReader.GetInt32(DbReader.GetOrdinal("idTurma"))); turma.NomeTurma = (DbReader.GetString(DbReader.GetOrdinal("NomeTur"))); retorno.Add(turma); } DbReader.Close(); DbCommand.Dispose(); this.fecharConexao(); } catch (Exception a) { throw new Exception("Erro no Lista ID Turma:" + a + ""); } return(retorno); }
public List <Disciplina> listaDisciplina() { List <Disciplina> retorno = new List <Disciplina>(); try { this.abrirConexao(); OdbcCommand DbCommand = conn.CreateCommand(); DbCommand.CommandText = "SELECT idDisciplina, nomeDisc FROM Disciplina"; OdbcDataReader DbReader = DbCommand.ExecuteReader(); while (DbReader.Read()) { Disciplina disciplina = new Disciplina(); disciplina.IdDisc = (DbReader.GetInt32(DbReader.GetOrdinal("idDisciplina"))); disciplina.NomeDisc = (DbReader.GetString(DbReader.GetOrdinal("nomeDisc"))); retorno.Add(disciplina); } DbReader.Close(); DbCommand.Dispose(); this.fecharConexao(); } catch (Exception a) { throw new Exception("Erro no Lista ID Disciplina:" + a + ""); } return(retorno); }
public List <Aluno> listaaluno() { List <Aluno> retorno = new List <Aluno>(); try { this.abrirConexao(); OdbcCommand DbCommand = conn.CreateCommand(); DbCommand.CommandText = "SELECT idAlun, nomeAlun FROM Aluna"; OdbcDataReader DbReader = DbCommand.ExecuteReader(); while (DbReader.Read()) { Aluno aluna = new Aluno(); aluna.IdAluno = (DbReader.GetInt32(DbReader.GetOrdinal("idAlun"))); aluna.NomelAuno = (DbReader.GetString(DbReader.GetOrdinal("nomeAlun"))); retorno.Add(aluna); } DbReader.Close(); DbCommand.Dispose(); this.fecharConexao(); } catch (Exception a) { throw new Exception("Erro no Lista ID Aluno:" + a + ""); } return(retorno); }
public List <Professor> listaprofessor() { List <Professor> retorno = new List <Professor>(); try { this.abrirConexao(); OdbcCommand DbCommand = conn.CreateCommand(); DbCommand.CommandText = "SELECT idProf, nomeProf FROM Professor"; OdbcDataReader DbReader = DbCommand.ExecuteReader(); while (DbReader.Read()) { Professor professor = new Professor(); professor.IdProf = (DbReader.GetInt32(DbReader.GetOrdinal("idProf"))); professor.NomeProf = (DbReader.GetString(DbReader.GetOrdinal("nomeProf"))); retorno.Add(professor); } DbReader.Close(); DbCommand.Dispose(); this.fecharConexao(); } catch (Exception a) { throw new Exception("Erro no Lista ID Professor:" + a + ""); } return(retorno); }
public List <Curso> listacurso() { List <Curso> retorno = new List <Curso>(); try { this.abrirConexao(); OdbcCommand DbCommand = conn.CreateCommand(); DbCommand.CommandText = "SELECT idCurso, nomeCurso FROM Curso"; OdbcDataReader DbReader = DbCommand.ExecuteReader(); while (DbReader.Read()) { Curso curso = new Curso(); curso.IdCurso = (DbReader.GetInt32(DbReader.GetOrdinal("idCurso"))); curso.NomeCurso = (DbReader.GetString(DbReader.GetOrdinal("nomeCurso"))); retorno.Add(curso); } DbReader.Close(); DbCommand.Dispose(); this.fecharConexao(); } catch (Exception a) { throw new Exception("Erro no Lista ID curso:" + a + ""); } return(retorno); }
public static List <Post> GetAllPosts() { conn.ConnectionString = connString; conn.Open(); List <Post> posts = new List <Post>(); using (conn) { OdbcCommand cmd = new OdbcCommand("SELECT * from post", conn); using (OdbcDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { posts.Add(new Post() { postID = reader.GetInt32(reader.GetOrdinal("ID")), opID = reader.GetString(reader.GetOrdinal("opID")), content = reader.GetString(reader.GetOrdinal("content")), timeStamp = reader.GetString(reader.GetOrdinal("timeStamp")), tagged = reader.GetString(reader.GetOrdinal("tagged")) }); } } } conn.Close(); return(posts); }
private void textBoxRutCliente_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == (char)13) { textBoxRutCliente.Text = new MetodosComunes().formatearRut(textBoxRutCliente.Text); OdbcDataReader reader = clienteM.getClienteReader(textBoxRutCliente.Text.ToUpper()); if (MetodosComunes.ValidaRut(textBoxRutCliente.Text) == true) { if (reader.RecordsAffected != 0) { while (reader.Read()) { textBoxRutCliente.Text = reader.GetString(reader.GetOrdinal("rutRecep")); textBoxRazonSocial.Text = reader.GetString(reader.GetOrdinal("rznSocRecep")); textBoxGiro.Text = reader.GetString(reader.GetOrdinal("giroRecep")); textBoxDireccion.Text = reader.GetString(reader.GetOrdinal("dirRecep")); labelCodComuna.Text = reader.GetString(reader.GetOrdinal("codComuna")); labelCodCiudad.Text = reader.GetInt32(reader.GetOrdinal("codCiudad")).ToString(); comboBoxCiudad.Text = reader.GetString(reader.GetOrdinal("nomCiudad")); textBoxTelefono.Text = reader.GetString(reader.GetOrdinal("telefono")); comboBoxComuna.Text = reader.GetString(reader.GetOrdinal("nomComuna")); } } else { MessageBox.Show("No esta Registrado el cliente", "Digital Terminal", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } else { MessageBox.Show("Rut Mal Ingresado!", "Digital Terminal", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } }
/* public List<String> select(string nome) * { * List<String> retorno = new List<String>(); * try * { * this.abrirConexao(); * OdbcCommand DbCommand = DbConnection.CreateCommand(); * string sql = "SELECT count(*) FROM Anuncio "; * * if (nome != "") * { * sql += " where nome like '%" + nome + "%'"; * } * DbCommand.CommandText = sql; * OdbcDataReader DbReader = DbCommand.ExecuteReader(); * while (DbReader.Read()) * { * string m = DbReader.GetString(DbReader.GetOrdinal("nome")); * retorno.Add(m); * } * * DbReader.Close(); * DbCommand.Dispose(); * this.fecharConexao(); * } * catch (Exception e) * { * * throw new Exception("Falha ao executar instrução select " + e.Message); * } * return retorno; * }*/ #endregion public string Contagem() { string statement = ""; int qtd_anuncios = 0; int qtd_gatos = 0; int qtd_cachorros = 0; try { this.abrirConexao(); OdbcCommand DbCommand = DbConnection.CreateCommand(); string sql = "SELECT count(*) as qtd_anuncios FROM Anuncio "; DbCommand.CommandText = sql; OdbcDataReader DbReader = DbCommand.ExecuteReader(); while (DbReader.Read()) { qtd_anuncios = Convert.ToInt32(DbReader.GetString(DbReader.GetOrdinal("qtd_anuncios"))); } sql = "SELECT count(*) FROM Anuncio as qtd_cachorros where conteudo_anun like '%cacho%'"; DbCommand.CommandText = sql; DbReader = DbCommand.ExecuteReader(); while (DbReader.Read()) { qtd_cachorros = Convert.ToInt32(DbReader.GetString(DbReader.GetOrdinal("qtd_cachorros"))); } sql = "SELECT count(*) FROM Anuncio as qtd_gatos where conteudo_anun like '%gat%'"; DbCommand.CommandText = sql; DbReader = DbCommand.ExecuteReader(); while (DbReader.Read()) { qtd_cachorros = Convert.ToInt32(DbReader.GetString(DbReader.GetOrdinal("qtd_gatos"))); } DbReader.Close(); DbCommand.Dispose(); this.fecharConexao(); } catch (Exception e) { throw new Exception("Falha ao solicitar relatório " + e.Message); } statement = "Neste momento temos:\n- " + qtd_anuncios + " registros de anúncio;\n- " + qtd_cachorros + " cachorros e;\n- " + qtd_gatos + " gatos!"; return(statement); }
private void getInfoFromOpKeyEntry(TextBox opkey) { try { using (OdbcConnection conn = new OdbcConnection(connection_string)) { conn.Open(); opKeyGlobal = opkey.Text; string query = "SELECT Job.Part_Number, Job_Operation.Job, Job_Operation.Operation_Service\n" + "FROM PRODUCTION.dbo.Job\n" + "INNER JOIN PRODUCTION.dbo.Job_Operation\n" + "ON Job.Job = Job_Operation.Job\n" + "WHERE Job_Operation.Job_Operation = '" + opkey.Text + "';"; OdbcCommand com = new OdbcCommand(query, conn); OdbcDataReader reader = com.ExecuteReader(); if (reader.Read()) { partNumberLabelValue.Text = reader.GetString(reader.GetOrdinal("Part_Number")); jobNumberLabelValue.Text = reader.GetString(reader.GetOrdinal("Job")); opNumberLabelValue.Text = reader.GetString(reader.GetOrdinal("Operation_Service")); partNumberLabelValue.Visible = true; jobNumberLabelValue.Visible = true; opNumberLabelValue.Visible = true; partNumGlobal = partNumberLabelValue.Text; jobNumGlobal = jobNumberLabelValue.Text; opService = opNumberLabelValue.Text; } else { partNumberLabelValue.Text = null; jobNumberLabelValue.Text = null; opNumberLabelValue.Text = null; opKeyGlobal = null; } } } catch { //MessageBox.Show("Please insert a valid OpKey "); } }
public List <Detalle> getDetalle(int tipoDoc, int folioDoc) { List <Detalle> detalles = new List <Detalle>(); Detalle detalle = new Detalle(); String detalleJson = String.Empty; try { BaseDato con = new BaseDato(); OdbcConnection conexion = con.ConnectPostgres(); OdbcCommand select = new OdbcCommand(); select.Connection = conexion; select.CommandText = "select row_to_json(detalle) from detalle where \"FolioDoc\" = " + folioDoc + " and \"TipoDoc\" = " + tipoDoc + ";"; OdbcDataReader reader = select.ExecuteReader(); while (reader.Read()) { detalleJson = reader.GetString(reader.GetOrdinal("row_to_json")); DataContractJsonSerializer js = new DataContractJsonSerializer(typeof(Detalle)); MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(detalleJson)); detalle = (Detalle)js.ReadObject(ms); detalles.Add(detalle); } return(detalles); } catch (Exception ex) { throw new Exception("Error" + ex.Message); } }
public List <ReferenciaDoc> getReferencia(int tipoDoc, int folioDoc) { List <ReferenciaDoc> referencias = new List <ReferenciaDoc>(); ReferenciaDoc referencia = new ReferenciaDoc(); String referenciaJson = String.Empty; try { BaseDato con = new BaseDato(); OdbcConnection conexion = con.ConnectPostgres(); OdbcCommand select = new OdbcCommand(); select.Connection = conexion; select.CommandText = "select row_to_json(referencia) from referencia where \"FolioDoc\" = " + folioDoc + " and \"TipoDoc\" = " + tipoDoc + " order by \"NroLinRef\" ASC;"; OdbcDataReader reader = select.ExecuteReader(); while (reader.Read()) { referenciaJson = reader.GetString(reader.GetOrdinal("row_to_json")); String referenciaJson1 = referenciaJson.Replace("null", "\"\""); String referenciaJson2 = referenciaJson1.Replace("\"TpoDocRef\\r\\n", "\"TpoDocRef"); DataContractJsonSerializer js = new DataContractJsonSerializer(typeof(ReferenciaDoc)); MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(referenciaJson2)); referencia = (ReferenciaDoc)js.ReadObject(ms); referencias.Add(referencia); } return(referencias); } catch (Exception ex) { throw new Exception("Error" + ex.Message); } }
public virtual T CreateModel(string sql, string company) { var results = new List <T>(); using (clsOdbcDataGetter dg = new clsOdbcDataGetter(company)) { OdbcDataReader reader = dg.GetDataReader(sql); var NotMapped = new List <String>(); var props = typeof(T).GetProperties(); while (reader.Read()) { var item = Activator.CreateInstance <T>(); foreach (var property in typeof(T).GetProperties()) { if (!NotMapped.Contains(property.Name)) { if (!reader.IsDBNull(reader.GetOrdinal(property.Name))) { Type convertTo = Nullable.GetUnderlyingType(property.PropertyType) ?? property.PropertyType; property.SetValue(item, Convert.ChangeType(reader[property.Name], convertTo), null); } } } results.Add(item); } dg.KillReader(reader); } return(results[0]); }
public int getUltimoFolioCaf(int idCaf, int tipoDte) { int ultimo = 0; try { BaseDato con = new BaseDato(); OdbcConnection conexion = con.ConnectPostgres(); OdbcCommand select = new OdbcCommand(); select.Connection = conexion; select.CommandText = "SELECT * FROM caf where id = " + idCaf + " and \"tipoDte\" = '" + tipoDte + "';"; OdbcDataReader reader = select.ExecuteReader(); if (reader.RecordsAffected != 0) { while (reader.Read()) { ultimo = reader.GetInt32(reader.GetOrdinal("folioFinal")); } } } catch (Exception ex) { throw new Exception("Error" + ex.Message); } return(ultimo + 1); }
public String getNombre(String codDte) { String nombre = String.Empty; SqlConnection sqlcon = new SqlConnection(); try { BaseDato con = new BaseDato(); OdbcConnection conexion = con.ConnectPostgres(); OdbcCommand select = new OdbcCommand(); select.Connection = conexion; select.CommandText = "SELECT * FROM tipodte where tipo = '" + codDte + "';"; OdbcDataReader reader = select.ExecuteReader(); while (reader.Read()) { nombre = reader.GetString(reader.GetOrdinal("nombre")); } } catch (Exception ex) { throw new Exception("Error" + ex.Message); } finally { sqlcon.Close(); } return(nombre); }
private void queryInspectionStatus() { string status = null; string query; try { using (OdbcConnection conn = new OdbcConnection(connection_string)) { conn.Open(); query = "SELECT status FROM ATI_FeatureInspection.dbo.Inspection WHERE Inspection_Key = " + getInspectionKey() + ";"; OdbcCommand comm = new OdbcCommand(query, conn); OdbcDataReader reader = comm.ExecuteReader(); if (reader.Read()) { status = reader.GetString(reader.GetOrdinal("status")); } } } catch { status = null; } statusLabelValue.Text = status; }
public DocumentoModel getDocumento(int tipo, int folio) { DocumentoModel documentoModel = new DocumentoModel(); String documento = String.Empty; try { BaseDato con = new BaseDato(); OdbcConnection conexion = con.ConnectPostgres(); OdbcCommand select = new OdbcCommand(); select.Connection = conexion; select.CommandText = "select row_to_json(documento) from documento where \"Folio\" = " + folio + " and \"TipoDTE\" = '" + tipo + "';"; OdbcDataReader reader = select.ExecuteReader(); while (reader.Read()) { documento = reader.GetString(reader.GetOrdinal("row_to_json")); } DataContractJsonSerializer js = new DataContractJsonSerializer(typeof(DocumentoModel)); MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(documento)); documentoModel = (DocumentoModel)js.ReadObject(ms); documentoModel.detalle = new Detalle().getDetalle(tipo, folio); documentoModel.Referencia = new ReferenciaDoc().getReferencia(tipo, folio); return(documentoModel); } catch (Exception ex) { throw new Exception("Error" + ex.Message); } }
public bool getBool(string cn) { try { if (Program.dataSource == Program.DataSources.Access) { return(dbr.GetBoolean(dbr.GetOrdinal(cn))); } else { return(Odbr.GetBoolean(Odbr.GetOrdinal(cn))); } } catch (InvalidCastException ice) { return(false); } }
long get_schedule(long level, long area) { long retval = 0; string s_l; if (level > 6) { s_l = "h" + level.ToString(); } else { s_l = "g" + level.ToString(); } if (Program.dataSource == Program.DataSources.Access) { try { dbcmd = Program.maindbCon.CreateCommand(); dbcmd.CommandText = "select scheduleid from schedules where instr(scope_areas,'a" + area.ToString() + "') > 0 and instr(scope_levels,'" + s_l + "')>0"; dbr = dbcmd.ExecuteReader(); while (dbr.Read()) { retval = dbr.GetInt32(dbr.GetOrdinal("scheduleid")); } dbr.Close(); } catch (Exception ie) { MessageBox.Show(ie.Message); //this.Close(); } } else { try { Odbcmd = Program.OmaindbCon.CreateCommand(); Odbcmd.CommandText = "select scheduleid from schedules where instr(scope_areas,'a" + area.ToString() + "') > 0 and instr(scope_levels,'" + s_l + "')>0"; Odbr = Odbcmd.ExecuteReader(); while (Odbr.Read()) { retval = Odbr.GetInt32(Odbr.GetOrdinal("scheduleid")); } Odbr.Close(); } catch (Exception ie) { MessageBox.Show(ie.Message); // this.Close(); } } return(retval); }
private bool GetBoolValue(OdbcDataReader reader, string column) { try { if (reader.IsDBNull(reader.GetOrdinal(column))) { logger.Debug("Reader column {column} is DbNull. Returning default value.", column); return(false); } else { return(RoseConvert.ToBool(reader.GetString(reader.GetOrdinal(column)))); } } catch (Exception ex) { logger.Error("An unexpected error occurred while processing reader column {column}. Error: {errorMessage}", column, ex.Message); throw; } }
private bool SafeGetBool(OdbcDataReader reader, string column, bool defaultValue) { try { if (reader.IsDBNull(reader.GetOrdinal(column))) { logger.Debug("Reader column {column} is DbNull. Returning default value of {defaultValue}.", column, defaultValue); return(defaultValue); } else { return(SafeGetBool(reader.GetString(reader.GetOrdinal(column)), defaultValue)); } } catch (Exception ex) { logger.Error("An unexpected error occurred while processing reader column {column}. Error: {errorMessage}", column, ex.Message); throw; } }
//overloaded for ODBC public static bool getBool(OdbcDataReader dr, string cn) { try { return(dr.GetBoolean(dr.GetOrdinal(cn))); } catch (InvalidCastException ice) { return(false); } }
public static long getLong(OdbcDataReader dr, string cn) { try { return(dr.GetInt32(dr.GetOrdinal(cn))); } catch (InvalidCastException ice) { return(0); } }
public void ListarAlunospainelprof(ListView list, Aluno aluna) { try { this.abrirConexao(); OdbcCommand DbCommand = conn.CreateCommand(); DbCommand.CommandText = "SELECT idAlun,nomeAlun FROM Aluna where idCursoalu = " + aluna.Curso.IdCurso + " and idTurmaalu =" + aluna.Turma.IdTurma + ""; OdbcDataReader DbReader = DbCommand.ExecuteReader(); while (DbReader.Read()) { ListViewItem item = list.Items.Add("" + DbReader.GetInt32(DbReader.GetOrdinal("idAlun"))); item.SubItems.Add(DbReader.GetString(DbReader.GetOrdinal("nomeAlun"))); } DbReader.Close(); DbCommand.Dispose(); this.fecharConexao(); } catch (Exception e) { throw new Exception("Falha ao executar instrução select " + e.Message); } }
public EmpresaModel getEmpresa() { SqlConnection sqlcon = new SqlConnection(); try { BaseDato con = new BaseDato(); OdbcConnection conexion = con.ConnectPostgres(); OdbcCommand select = new OdbcCommand(); select.Connection = conexion; select.CommandText = "SELECT * FROM empresa "; OdbcDataReader reader = select.ExecuteReader(); while (reader.Read()) { this.Rut = reader.GetString(reader.GetOrdinal("rutempresa")); this.RazonSocial = reader.GetString(reader.GetOrdinal("razonsocial")); this.GiroEmisor = reader.GetString(reader.GetOrdinal("giroemisor")); this.CodigoSiiSucursal = reader.GetInt32(reader.GetOrdinal("codigosiisucursal")); this.Telefono = reader.GetString(reader.GetOrdinal("telefonoemis")); this.Correo = reader.GetString(reader.GetOrdinal("correoemis")); this.Acteco = reader.GetInt32(reader.GetOrdinal("acteco")); this.DireccionOrigen = reader.GetString(reader.GetOrdinal("direccionorigen")); this.ComunaOrigen = reader.GetString(reader.GetOrdinal("comunaorigen")); this.CiudadOrigen = reader.GetString(reader.GetOrdinal("ciudadorigen")); } } catch (Exception ex) { throw new Exception("Error" + ex.Message); } finally { sqlcon.Close(); } return(this); }
private void formLoadQuery() { List <int> opKeys = new List <int>(); List <int> inspecKeys = new List <int>(); int row = 0; int col = 1; dataGridView1.Rows.Clear(); dataGridView1.Rows.Add(); opKeys = getOpKeysWithSamePartAndOpNum(op.getOpKey()); inspecKeys = getInspecKeysWithOpKeys(opKeys); string query; using (OdbcConnection conn = new OdbcConnection(connection_string)) { conn.Open(); foreach (int value in inspecKeys) { //This query is for new inspections only query = "SELECT Feature_Key, Nominal, Plus_Tolerance, Minus_Tolerance, Feature_Name, Places, Pieces FROM ATI_FeatureInspection.dbo.Features\n" + "WHERE Inspection_Key_FK = " + value + " AND InheritedFromFeature IS NULL;\n"; OdbcCommand com = new OdbcCommand(query, conn); OdbcDataReader reader = com.ExecuteReader(); while (reader.Read()) { dataGridView1.Rows[row].Cells[col].Value = reader.GetString(reader.GetOrdinal("Feature_Name")); col++; dataGridView1.Rows[row].Cells[col].Value = reader.GetDecimal(reader.GetOrdinal("Nominal")); col++; dataGridView1.Rows[row].Cells[col].Value = reader.GetDecimal(reader.GetOrdinal("Plus_Tolerance")); col++; dataGridView1.Rows[row].Cells[col].Value = reader.GetDecimal(reader.GetOrdinal("Minus_Tolerance")); col++; dataGridView1.Rows[row].Cells[col].Value = reader.GetInt32(reader.GetOrdinal("Places")); col++; dataGridView1.Rows[row].Cells[col].Value = reader.GetInt32(reader.GetOrdinal("Pieces")); col++; dataGridView1.Rows[row].Cells[col].Value = reader.GetInt32(reader.GetOrdinal("Feature_Key")); col = 1; row++; dataGridView1.Rows.Add(); //This will add an extra row after all rows are place in the table } } dataGridView1.Rows.RemoveAt(dataGridView1.Rows.Count - 1); //Will remove the last row that was created } }
private bool opKeyExistsInInspection() { //Query checking if an inspection for an opkey exists in the Inspection table using (OdbcConnection conn = new OdbcConnection(connection_string)) { conn.Open(); string status; string inspectExist = "SELECT Op_Key, Inspection_Key, status FROM ATI_FeatureInspection.dbo.Inspection\n" + "WHERE Op_Key = " + textBox1.Text; OdbcCommand command = new OdbcCommand(inspectExist, conn); OdbcDataReader reader = command.ExecuteReader(); // If there is a value in the reader then there is inspection if (reader.Read()) { inspectionExists = true; status = reader.GetString(reader.GetOrdinal("status")); if (status == "Complete") { inspectionExists = false; //If the old inspection is complete allow for the creation of a new one } else { inspectionKeyGlobal = reader.GetInt32(reader.GetOrdinal("Inspection_Key")); } } else { inspectionExists = false; } } return(inspectionExists); }
public UsuarioEntity CrearEntidad(OdbcDataReader dr) { UsuarioEntity entidad = new UsuarioEntity(); entidad.IdUsuario = Convert.ToInt32(dr["IdUsuario"]); entidad.Usuario = dr["Usuario"].ToString(); entidad.Clave = dr["Clave"].ToString(); entidad.Apellido = dr["Apellido"].ToString(); entidad.Nombre = dr["Nombre"].ToString(); if (!dr.IsDBNull(dr.GetOrdinal("Mail"))) { entidad.Mail = dr["Mail"].ToString(); } return(entidad); }
// read tablenames from DB public bool readTables(ArrayList _tables, ref OdbcConnection conn, bool IsWildCardFilterOn) { bool RetValue = true; try { #region get User Id from connection string int start = conn.ConnectionString.IndexOf("UID=") + 4; int end = conn.ConnectionString.IndexOf(";", start); string uID = conn.ConnectionString.Substring((start), (end - start));// User ID #endregion OdbcCommand selectCommand = new OdbcCommand(); if (IsWildCardFilterOn) { //string selectQuery = "select object_name from user_objects where object_type = 'TABLE' or object_type = 'SYNONYM' or object_type = 'VIEW' order by object_name"; string selectQuery = "SELECT DISTINCT TABLE_NAME FROM ALL_TAB_COLUMNS WHERE OWNER like '" + uID.ToUpper() + "%' AND TABLE_NAME IN (SELECT object_name FROM user_objects WHERE object_type = 'TABLE' OR object_type = 'SYNONYM' OR object_type = 'VIEW') ORDER BY TABLE_NAME"; selectCommand.CommandText = selectQuery; } else { //string selectQuery = "select object_name from user_objects where object_type = 'TABLE' or object_type = 'SYNONYM' or object_type = 'VIEW' order by object_name"; string selectQuery = "SELECT DISTINCT TABLE_NAME FROM ALL_TAB_COLUMNS WHERE OWNER like '" + uID.ToUpper() + "' AND TABLE_NAME IN (SELECT object_name FROM user_objects WHERE object_type = 'TABLE' OR object_type = 'SYNONYM' OR object_type = 'VIEW') ORDER BY TABLE_NAME"; selectCommand.CommandText = selectQuery; } selectCommand.Connection = conn; //int rows = selectCommand.ExecuteNonQuery(); OdbcDataReader myReader = selectCommand.ExecuteReader(); while (myReader.Read()) { string tn = myReader.GetString(myReader.GetOrdinal("TABLE_NAME")); _tables.Add(tn); } _tables.Sort(); myReader.Close(); // close to be able to read again } catch (OdbcException ex) { MessageBox.Show(ex.StackTrace + " : \r\n\r\n" + ex.Message, "OdbcException", MessageBoxButtons.OK, MessageBoxIcon.Error); RetValue = false; } return(RetValue); }// read tablenames from DB
private void textBoxRutCliente_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == (char)13) { textBoxRutCliente.Text = new MetodosComunes().formatearRut(textBoxRutCliente.Text); OdbcDataReader reader = clienteM.getClienteReader(textBoxRutCliente.Text); while (reader.Read()) { textBoxRazonSocial.Text = reader.GetString(reader.GetOrdinal("rznSocRecep")); textBoxGiro.Text = reader.GetString(reader.GetOrdinal("giroRecep")); textBoxDireccion.Text = reader.GetString(reader.GetOrdinal("dirRecep")); labelCodComuna.Text = reader.GetString(reader.GetOrdinal("codComuna")); comboBoxComuna.Text = reader.GetString(reader.GetOrdinal("nomComuna")); labelCodCiudad.Text = reader.GetInt32(reader.GetOrdinal("codCiudad")).ToString(); comboBoxCiudad.Text = reader.GetString(reader.GetOrdinal("nomCiudad")); textBoxTelefono.Text = reader.GetString(reader.GetOrdinal("telefono")); } } }