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"));
}
}
}
