//Metodo para actualizar los usuarios
public static void ActualizarUsuarios()
{
//Cadena para hacer las consultas
string CADENA;
//Metodos de conexiones
string sConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
OdbcConnection conexSql = new OdbcConnection(sConnectionString);
//metodo para abrir las cadenas de conexiones
OdbcConnection objcon = new OdbcConnection(sConnectionString);
objcon.Open();
//Cadena de string
CADENA = "SELECT usuario.usuacodi, usuario.usuapass, emplead.emplnomb FROM emplead emplead, usuario usuario WHERE emplead.emplterc = usuario.usuaterc";
//DataAdapter que se llena
OdbcDataAdapter daUsuariofox = new OdbcDataAdapter(CADENA, objcon);
//creamos un dataset
DataSet dsUsuariofox = new DataSet();
//llenamos el esquema
daUsuariofox.FillSchema(dsUsuariofox, SchemaType.Source, "usuario_FOX");
daUsuariofox.Fill(dsUsuariofox, "usuario_FOX");
//creamos un datatable
DataTable tbUsuariofox = new DataTable();
tbUsuariofox = dsUsuariofox.Tables["usuario_FOX"];
//////////////////////// sql
string sConnectionStringsql;
sConnectionStringsql = ("Server=servidor2sp;Database= CONTROL_ALMACEN;User Id=sa;Password=Qwer1234;");
SqlConnection objConnsql = new SqlConnection(sConnectionStringsql);
objConnsql.Open();
SqlDataAdapter dausuariosql = new SqlDataAdapter("Select * From Usuarios", objConnsql);
DataSet dsusuariosql = new DataSet();
dausuariosql.FillSchema(dsusuariosql, SchemaType.Source, "usuario_sql");
dausuariosql.Fill(dsusuariosql, "usuario_sql");
DataTable dtusuariosql = new DataTable();
dtusuariosql = dsusuariosql.Tables["usuario_sql"];
/////////////
compararUsuarios(tbUsuariofox, dtusuariosql, objConnsql);
//cerramos la conexion
objConnsql.Close();
objcon.Close();
}
/// <summary>
/// Test CUBRIDCommand column properties
/// </summary>
public static void Test_Command_ColumnProperties()
{
using (OdbcConnection conn = new OdbcConnection())
{
conn.ConnectionString = TestCases.connString;
conn.Open();
String sql = "select * from nation";
OdbcCommand cmd = new OdbcCommand(sql, conn);
OdbcDataAdapter da = new OdbcDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable("");
da.FillSchema(dt, SchemaType.Source);//To retrieve all the column properties you have to use the FillSchema() method
Assert.IsTrue(dt.Columns[0].ColumnName == "code");
}
}
public static DataSet Read(string filePath, string fileName, string newDSName, string newTableName)
{
//TODO: Filter for invalid filepath and filename?
// Driver={Microsoft Text Driver (*.txt; *.csv)}
string ConnectionString = null;
ConnectionString = "Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=" + filePath;
fileName = "`" + fileName + "`";
OdbcConnection connection = new OdbcConnection(ConnectionString);
connection.Open(); //TODO: necessary?
OdbcDataAdapter da;
da = new OdbcDataAdapter("Select * FROM " + fileName, connection);
DataSet ds = new DataSet(newDSName);
da.FillSchema(ds, SchemaType.Source, newTableName);
da.Fill(ds, newTableName);
return ds;
}
/// <summary>
/// Loads all address records</summary>
private void LoadFirstRecord()
{
OdbcCommand m_cmdCaoSelect = new OdbcCommand("select ADRESSEN.* FROM ADRESSEN WHERE KUNDENGRUPPE=1 ORDER BY REC_ID;", m_cnCaoConnection);
//von Silvio:
//OdbcDataReader rd = cmd.ExecuteReader();
//List<string> values = new List<string>(10);
//while (rd.Read())
//{
// values.Add(rd.GetValue(0).ToString());
//}
#region temp
//m_daCao = new OleDbDataAdapter("SELECT * FROM adressen", m_cnCaoConnection);
//OleDbCommand myUpdateCommand = new OleDbCommand("UPDATE qryNotenStudent SET fldStudentNr = ?, fldName = ?, fldVorname = ?, fldKlassenNr = ?, fldKlassenBez = ?, fldNotenNr = ?, fldNote = ?, fldFachNr = ?, fldBezeichnung = ? WHERE fldStudentNr = ?", myConnection);
//OleDbCommand myUpdateCommand = new OleDbCommand("UPDATE ADRESSEN SET NAME1 ='Hans Müller' where REC_ID=3", m_cnCaoConnection);
//myUpdateCommand.Parameters.Add("@fldStudentNr", OleDbType.Integer, 2, "fldStudentNr");
//myUpdateCommand.Parameters.Add("@fldName", OleDbType.VarChar, 255, "fldName");
//myUpdateCommand.Parameters.Add("@fldVorname", OleDbType.VarChar, 255, "fldVorname");
//myUpdateCommand.Parameters.Add("@fldKlassenNr", OleDbType.Integer, 2, "fldKlassenNr");
//myUpdateCommand.Parameters.Add("@fldKlassenBez", OleDbType.VarChar, 255, "fldKlassenBez");
//myUpdateCommand.Parameters.Add("@fldNotenNr", OleDbType.Integer, 2, "fldNotenNr");
//myUpdateCommand.Parameters.Add("@fldNote", OleDbType.Single, 2, "fldNote");
//myUpdateCommand.Parameters.Add("@fldFachNr", OleDbType.Integer, 2, "fldFachNr");
//myUpdateCommand.Parameters.Add("@fldBezeichnung", OleDbType.VarChar, 255, "fldBezeichnung");
//m_daCao.UpdateCommand = myUpdateCommand;
//delete
// OleDbCommand myDeleteCommand = new OleDbCommand("delete from ADRESSEN_LIEF Where ADDR_ID=3;delete from ADRESSEN_TO_MERK Where ADDR_ID=3;DELETE FROM ADRESSEN WHERE REC_ID=3.DeleteCommand = myDeleteCommand;", myConnection);
//myDeleteCommand.Parameters.Add("@fldStudentNr", OleDbType.Integer, 2, "fldStudentNr");
//m_daCaodelete from ADRESSEN_ASP Where ADDR_ID=3
//delete from ADRESSEN_LIEF Where ADDR_ID=3
//delete from ADRESSEN_TO_MERK Where ADDR_ID=3
//DELETE FROM ADRESSEN WHERE REC_ID=3.DeleteCommand = myDeleteCommand;
#endregion
m_daCao = new OdbcDataAdapter(m_cmdCaoSelect);
m_daCao.FillSchema(m_dsCao, SchemaType.Source, "tblAdressen");
m_daCao.Fill(m_dsCao, "tblAdressen");
m_dvCao = m_dsCao.Tables["tblAdressen"].DefaultView;
}
/// <summary>
///Searches the table adressen and returns a DataView with a selection of columns.</summary>
/// <param name="searchstring">the search string</param>
public DataView generate_dv_human(string searchstring)
{
StringBuilder m_strCommand = new StringBuilder();
//SELECT `REC_ID`, `MATCHCODE`, `KUNDENGRUPPE`, `SPRACH_ID`, `GESCHLECHT`, `KUNNUM1`, `KUNNUM2`, `NAME1`, `PLZ`, `ORT`, `LAND`, `NAME2`, `NAME3`, `ABTEILUNG`, `ANREDE`, `STRASSE`, `POSTFACH`, `PF_PLZ`, `DEFAULT_LIEFANSCHRIFT_ID`, `GRUPPE`, `TELE1`, `TELE2`, `FAX`, `FUNK`, `EMAIL`, `EMAIL2`, `INTERNET`, `DIVERSES`, `BRIEFANREDE`, `BLZ`, `KTO`, `BANK`, `IBAN`, `SWIFT`, `KTO_INHABER`, `DEB_NUM`, `KRD_NUM`, `STATUS`, `NET_SKONTO`, `NET_TAGE`, `BRT_TAGE`, `WAEHRUNG`, `UST_NUM`, `VERTRETER_ID`, `PROVIS_PROZ`, LEFT(`INFO`, 256), `GRABATT`, `KUN_KRDLIMIT`, `KUN_LIEFART`, `KUN_ZAHLART`, `KUN_PRLISTE`, `KUN_LIEFSPERRE`, `LIEF_LIEFART`, `LIEF_ZAHLART`, `LIEF_PRLISTE`, `LIEF_TKOSTEN`, `LIEF_MBWERT`, `PR_EBENE`, `BRUTTO_FLAG`, `MWST_FREI_FLAG`, `KUNPREIS_AUTO`, `KUN_SEIT`, `KUN_GEBDATUM`, `ENTFERNUNG`, `ERSTELLT`, `ERST_NAME`, `GEAEND`, `GEAEND_NAME`, `SHOP_KUNDE`, `SHOP_ID`, `SHOP_NEWSLETTER`, `SHOP_KUNDE_ID`, `SHOP_CHANGE_FLAG`, `SHOP_DEL_FLAG`, `SHOP_PASSWORD`, `USERFELD_01`, `USERFELD_02`, `USERFELD_03`, `USERFELD_04`, `USERFELD_05`, `USERFELD_06`, `USERFELD_07`, `USERFELD_08`, `USERFELD_09`, `USERFELD_10` FROM `caofaktura`.`adressen` LIMIT 0, 1000;
m_strCommand.Append(@"select ANREDE as Anrede, NAME1 as Name, STRASSE as Strasse, PLZ as PLZ, ORT as Ort, TELE1 as Telefon, FUNK as Mobile, EMAIL as Email from adressen where NAME1 like ");
m_strCommand.Append(@"'%");
m_strCommand.Append(searchstring);
m_strCommand.Append(@"%'");
//m_strCommand.Append(@"select * from adressen where NAME1 like 'Meier'");
OdbcCommand m_cmdSearchCommand = new OdbcCommand(m_strCommand.ToString());
OdbcDataAdapter m_daSearchCao = new OdbcDataAdapter(m_cmdSearchCommand.CommandText, m_cnCaoConnection);
m_daSearchCao.FillSchema(m_dsSearchCao, SchemaType.Source, "tblCaoSuche");
m_daSearchCao.Fill(m_dsSearchCao, "tblCaoSuche");
m_dvSearchCao = m_dsSearchCao.Tables["tblCaoSuche"].DefaultView;
return m_dvSearchCao;
//m_daCao.Update();
}
/// <summary>
///Searches the table adressen and returns a DataView with all columns</summary>
/// <param name="searchstring">the search string</param>
public DataView generate_dv_all(string searchstring)
{
StringBuilder m_strCommand = new StringBuilder();
m_strCommand.Append(@"select * from adressen where NAME1 like ");
m_strCommand.Append(@"'%");
m_strCommand.Append(searchstring);
m_strCommand.Append(@"%'");
//m_strCommand.Append(@"select * from adressen where NAME1 like 'Meier'");
OdbcCommand m_cmdSearchCommand = new OdbcCommand(m_strCommand.ToString());
OdbcDataAdapter m_daSearchCao = new OdbcDataAdapter(m_cmdSearchCommand.CommandText, m_cnCaoConnection);
m_daSearchCao.FillSchema(m_dsSearchCao, SchemaType.Source, "tblCaoSuche");
m_daSearchCao.Fill(m_dsSearchCao, "tblCaoSuche");
m_dvSearchCao = m_dsSearchCao.Tables["tblCaoSuche"].DefaultView;
return m_dvSearchCao;
}
} // RemoveTable
/// <summary>
/// Obtain a data adapter for the specified Table
/// </summary>
/// <param name="tableName">Name of the table to obtain the
/// adapter for</param>
/// <returns>Adapter object for the specified table</returns>
/// <remarks>An adapter serves as a bridge between a DataSet (in memory
/// representation of table) and the data source</remarks>
internal OdbcDataAdapter GetAdapterForTable(string tableName)
{
OdbcDataAdapter da = null;
AccessDBPSDriveInfo di = this.PSDriveInfo as AccessDBPSDriveInfo;
if (di == null || !TableNameIsValid(tableName) || !TableIsPresent(tableName))
{
return null;
}
OdbcConnection connection = di.Connection;
try
{
// Create a odbc data adpater. This can be sued to update the
// data source with the records that will be created here
// using data sets
string sql = "Select * from " + tableName;
da = new OdbcDataAdapter(new OdbcCommand(sql, connection));
// Create a odbc command builder object. This will create sql
// commands automatically for a single table, thus
// eliminating the need to create new sql statements for
// every operation to be done.
OdbcCommandBuilder cmd = new OdbcCommandBuilder(da);
// Set the delete cmd for the table here
sql = "Delete from " + tableName + " where ID = ?";
da.DeleteCommand = new OdbcCommand(sql, connection);
// Specify a DeleteCommand parameter based on the "ID"
// column
da.DeleteCommand.Parameters.Add(new OdbcParameter());
da.DeleteCommand.Parameters[0].SourceColumn = "ID";
// Create an InsertCommand based on the sql string
// Insert into "tablename" values (?,?,?)" where
// ? represents a column in the table. Note that
// the number of ? will be equal to the number of
// columnds
DataSet ds = new DataSet();
ds.Locale = CultureInfo.InvariantCulture;
da.FillSchema(ds, SchemaType.Source);
sql = "Insert into " + tableName + " values ( ";
for (int i = 0; i < ds.Tables["Table"].Columns.Count; i++)
{
sql += "?, ";
}
sql = sql.Substring(0, sql.Length - 2);
sql += ")";
da.InsertCommand = new OdbcCommand(sql, connection);
// Create parameters for the InsertCommand based on the
// captions of each column
for (int i = 0; i < ds.Tables["Table"].Columns.Count; i++)
{
da.InsertCommand.Parameters.Add(new OdbcParameter());
da.InsertCommand.Parameters[i].SourceColumn =
ds.Tables["Table"].Columns[i].Caption;
}
// Open the connection if its not already open
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
}
catch (Exception e)
{
WriteError(new ErrorRecord(e, "CannotAccessSpecifiedTable",
ErrorCategory.InvalidOperation, tableName));
}
return da;
} // GetAdapterForTable
public void FillSchema( string sqlQuery,DataSet dataSet,string tableName)
{
if (Connection.State == ConnectionState.Closed)
{
Connection.Open();
}
command.CommandText = sqlQuery;
OdbcDataAdapter oraDA = new OdbcDataAdapter();
oraDA.SelectCommand = command;
oraDA.FillSchema(dataSet, SchemaType.Mapped, tableName);
Connection.Close();
}
/// <summary>
/// Searches for Contacts by Street.
/// Table: tblCaoSearchAllPrivate</summary>
/// <param name="searchstring">the search string</param>
public void SearchContactsBySteet(string searchstring)
{
StringBuilder m_strCommand = new StringBuilder();
m_strCommand.Append(@"select * from adressen where STRASSE like ");
m_strCommand.Append(@"'%");
m_strCommand.Append(searchstring);
m_strCommand.Append(@"%'");
m_strCommand.Append(" AND KUNDENGRUPPE=1;");
//m_strCommand.Append(@"select * from adressen where NAME1 like 'Meier'");
OdbcCommand m_cmdSearchCommand = new OdbcCommand(m_strCommand.ToString());
m_daCao = new OdbcDataAdapter(m_cmdSearchCommand.CommandText, m_cnCao);
m_daCao.FillSchema(m_dsCao, SchemaType.Source, m_const_strCaoTableSearchAllPrivate);
m_daCao.Fill(m_dsCao, m_const_strCaoTableSearchAllPrivate);
}
/// <summary>
/// Searches for Companies by Mainphone.
/// Table: tblCaoSearchAllPrivate</summary>
/// <param name="searchstring">the searchstring</param>
public void SearchCompanyByPhone(string searchstring)
{
StringBuilder m_strCommand = new StringBuilder();
m_strCommand.Append(@"select * from adressen where TELE1 like ");
m_strCommand.Append(@"'%");
m_strCommand.Append(searchstring);
m_strCommand.Append(@"%'");
m_strCommand.Append(" AND KUNDENGRUPPE=2;");
OdbcCommand m_cmdSearchCommand = new OdbcCommand(m_strCommand.ToString());
m_daCao = new OdbcDataAdapter(m_cmdSearchCommand.CommandText, m_cnCao);
m_daCao.FillSchema(m_dsCao, SchemaType.Source, m_const_strCaoTableSearchAllCompanies);
m_daCao.Fill(m_dsCao, m_const_strCaoTableSearchAllCompanies);
}
//Retorna la lista de Proyectos Multi-Fox
public List<PagosFox> ConsultPagosFox(string refe)
{
try
{
List<PagosFox> litP = new List<PagosFox>();
ConectionString = GetConnectionString();
OdbcConnection objcon = new OdbcConnection(ConectionString);
objcon.Open();
cadena = "SELECT LEFT(democuot,9) AS 'referencia1', movidet.demosucu AS 'obra', movimie.moviterc AS 'codterc',"
+ " tercero.tercnitc AS 'cc/nit', movidet.demomovi AS 'recibo',"
+ " movidet.demonota AS '#recibo', IIF(movimie.moviesta='A','Anulado','Vigente') AS 'estado',"
+ " movimie.movifech AS 'fecharecibo', movimie.moviconc AS 'concepto', movimie.movivalo AS 'vlrdelrecibo',"
+ " movimie.movinuco AS '#consignacion', movimie.movifeco AS 'fechaconsignacion', movidet.demogira AS 'vlrcuotaaplicado',"
+ " movidet.democuot AS 'detalledelacuota', movimie.moviusua AS 'usuario', movimie.movidate AS 'fechaelaboración', "
+ " movimie.movicheq AS '#cheque', movimie.movidoc1 AS 'notaqueanulo'"
+ " FROM movidet movidet, movimie movimie, obradet obradet, obraspr obraspr, tercero tercero"
+ " WHERE movidet.demonota = movimie.movicodi AND movidet.demomovi = movimie.movimovi AND movidet.demopres = movimie.movipres"
+ " AND LEFT(democuot,9) = '"+ refe +"'"
+ " AND movidet.demosucu = movimie.movisucu AND movimie.moviterc = tercero.terccodi"
+ " AND movidet.demosucu = obradet.obrdcodi AND movidet.demopres = obradet.obrdpres AND obradet.obrdcodi = obraspr.obracodi AND ((movidet.democuot<>''))"
+ " ORDER BY movidet.democuot";
OdbcDataAdapter daProyectofox = new OdbcDataAdapter(cadena, objcon);
DataSet dsproyectofox = new DataSet("Pubs");
daProyectofox.FillSchema(dsproyectofox, SchemaType.Source, "PAGOS_FOX");
daProyectofox.Fill(dsproyectofox, "PAGOS_FOX");
DataTable tbproyectosfox = new DataTable();
tbproyectosfox = dsproyectofox.Tables["PAGOS_FOX"];
if (tbproyectosfox.Columns.Count.Equals(0))
{
return null;
}
else
{
foreach (DataRow row2 in tbproyectosfox.Rows)
{
PagosFox Pfx = new PagosFox();
Pfx.Referencia1 = row2["referencia1"].ToString();
Pfx.Obra = row2["obra"].ToString();
Pfx.Codterc = row2["codterc"].ToString();
Pfx.Nit = row2["cc/nit"].ToString();
Pfx.Recibo = row2["recibo"].ToString();
Pfx.Nrecibo = row2["#recibo"].ToString();
Pfx.Estado = row2["estado"].ToString();
Pfx.Fecharecibo = row2["fecharecibo"].ToString();
Pfx.Concepto = row2["concepto"].ToString();
Pfx.Vlrrecibo = row2["vlrdelrecibo"].ToString();
Pfx.Nconsignacion = row2["#consignacion"].ToString();
Pfx.Fechaconsignacion = row2["fechaconsignacion"].ToString();
Pfx.Vlrcuotaaplicado = row2["vlrcuotaaplicado"].ToString();
Pfx.Detallecuota = row2["detalledelacuota"].ToString();
Pfx.Usuario = row2["usuario"].ToString();
Pfx.Fechaelaboracion = row2["fechaelaboración"].ToString();
Pfx.Ncheque = row2["#cheque"].ToString();
Pfx.Nota = row2["notaqueanulo"].ToString();
litP.Add(Pfx);
}
return litP;
}
}
catch (OdbcException)
{
throw;
}
catch (NullReferenceException)
{
throw;
}
catch (Exception)
{
throw;
}
}
//Retorna la lista de Proyectos Multi-Fox
public List<ProyecFox> ConsulProyec()
{
try
{
List<ProyecFox> litP = new List<ProyecFox>();
ConectionString = GetConnectionString();
OdbcConnection objcon = new OdbcConnection(ConectionString);
objcon.Open();
cadena = "SELECT obraspr.obracodi, obraspr.obranomb FROM obraspr obraspr " +
"where (obraspr.obracodi NOT IN('999','101','128','131','132','CLH','CAS','AME','134','135')) order by obraspr.obranomb ASC";
OdbcDataAdapter daProyectofox = new OdbcDataAdapter(cadena, objcon);
DataSet dsproyectofox = new DataSet("Pubs");
daProyectofox.FillSchema(dsproyectofox, SchemaType.Source, "OBRAS_FOX");
daProyectofox.Fill(dsproyectofox, "OBRAS_FOX");
DataTable tbproyectosfox = new DataTable();
tbproyectosfox = dsproyectofox.Tables["OBRAS_FOX"];
if (tbproyectosfox.Columns.Count.Equals(0))
{
return null;
}
else
{
foreach (DataRow row2 in tbproyectosfox.Rows)
{
ProyecFox Pfx = new ProyecFox();
Pfx.ID_PROYEC = row2["obracodi"].ToString();
Pfx.NOMBRE_PROYEC = row2["obranomb"].ToString();
litP.Add(Pfx);
}
return litP;
}
}
catch (OdbcException)
{
throw;
}
catch (NullReferenceException)
{
throw;
}
catch (Exception)
{
throw;
}
}
public List<Inmuebles2Fox> ConsulInmuebles2()
{
try
{
List<Inmuebles2Fox> linmf = new List<Inmuebles2Fox>();
ConectionString = GetConnectionString();
OdbcConnection objcon = new OdbcConnection(ConectionString);
objcon.Open();
cadena = "SELECT inmubloq+inmucodi AS 'referencia', inmuebl.inmuobra,inmuebl.inmudesc,left(inmuebl.inmuobra,3) AS 'suc', right(inmuebl.inmuobra,3) AS 'ppto', bloques.bloqcodi AS 'mza', inmuebl.inmucodi AS 'inmueble',inmuebl.inmuarea AS 'area', inmuebl.inmuvent AS 'vlr inmueble', IIF(inmuebl.inmuesta=1,1,0)*inmuebl.inmuvent AS 'vlr vendido', IIF(inmuebl.inmuesta<>1,1,0)*inmuebl.inmuvent AS 'vlr x vender', inmuebl.inmuesta AS 'estado',inmuebl.inmubano, inmuebl.inmualco FROM bloques bloques, inmuebl inmuebl WHERE inmuebl.inmuobra = bloques.bloqobra AND ((bloques.bloqcodi=right(inmuebl.inmubloq,2))) order by inmueble ASC";
OdbcDataAdapter daProyectofox = new OdbcDataAdapter(cadena, objcon);
DataSet dsproyectofox = new DataSet("Pubs");
daProyectofox.FillSchema(dsproyectofox, SchemaType.Source, "BLOQUE_FOX");
daProyectofox.Fill(dsproyectofox, "BLOQUE_FOX");
DataTable tbproyectosfox = new DataTable();
tbproyectosfox = dsproyectofox.Tables["BLOQUE_FOX"];
if (tbproyectosfox.Columns.Count.Equals(0))
{
return null;
}
else
{
foreach (DataRow row2 in tbproyectosfox.Rows)
{
Inmuebles2Fox Ifx = new Inmuebles2Fox();
Ifx.REFERENCIA = row2["referencia"].ToString();
Ifx.INMUOBRA = row2["inmuobra"].ToString();
Ifx.INMUDECS = row2["inmudesc"].ToString();
Ifx.SUC = row2["suc"].ToString();
Ifx.PPTO = row2["ppto"].ToString();
Ifx.MZA = row2["mza"].ToString();
Ifx.INMUEBLE = row2["inmueble"].ToString();
Ifx.AREA = row2["area"].ToString();
Ifx.VAL_INMUEBLE = Convert.ToDecimal(row2["vlr inmueble"]);
Ifx.INMUESTADO = row2["estado"].ToString();
Ifx.BANO = row2["inmubano"].ToString();
Ifx.HABITACIONES = row2["inmualco"].ToString();
linmf.Add(Ifx);
}
return linmf;
}
}
catch (OdbcException)
{
throw;
}
catch (NullReferenceException)
{
throw;
}
catch (Exception)
{
throw;
}
}
public List<BloquesFox> ConsulBoques(string p)
{
try
{
List<BloquesFox> litB = new List<BloquesFox>();
ConectionString = GetConnectionString();
OdbcConnection objcon = new OdbcConnection(ConectionString);
objcon.Open();
cadena = "SELECT bloques.bloqobra,bloques.bloqcodi,bloques.bloqdesc FROM bloques bloques WHERE LEFT(bloques.bloqobra,3)='" + p + "'";
OdbcDataAdapter daProyectofox = new OdbcDataAdapter(cadena, objcon);
DataSet dsproyectofox = new DataSet("Pubs");
daProyectofox.FillSchema(dsproyectofox, SchemaType.Source, "BLOQUE_FOX");
daProyectofox.Fill(dsproyectofox, "BLOQUE_FOX");
DataTable tbproyectosfox = new DataTable();
tbproyectosfox = dsproyectofox.Tables["BLOQUE_FOX"];
if (tbproyectosfox.Columns.Count.Equals(0))
{
return null;
}
else
{
foreach (DataRow row2 in tbproyectosfox.Rows)
{
BloquesFox Bfx = new BloquesFox();
Bfx.ID_BLOQUE = row2["bloqobra"].ToString();
Bfx.PROYECTO_SET = row2["bloqcodi"].ToString();
Bfx.NOMBRE_SET = row2["bloqdesc"].ToString();
litB.Add(Bfx);
}
return litB;
}
}
catch (OdbcException)
{
throw;
}
catch (NullReferenceException)
{
throw;
}
catch (Exception)
{
throw;
}
}
public DataTable ExecuteTable(string tableName, string query, OdbcTransaction transaction)
{
try
{
OdbcCommand dbCommand = transaction.Connection.CreateCommand();
dbCommand.Transaction = transaction;
dbCommand.CommandText = query;
OdbcDataAdapter dbDataAdapter = new OdbcDataAdapter(dbCommand);
DataTable dataTable = new DataTable(tableName);
dbDataAdapter.MissingSchemaAction = MissingSchemaAction.Add;
dbDataAdapter.FillSchema(dataTable, SchemaType.Source);
dbDataAdapter.Fill(dataTable);
return dataTable;
}
catch (Exception)
{
transaction.Rollback();
var trace = new System.Diagnostics.StackTrace(true);
var frame = trace.GetFrame(0);
var method = frame.GetMethod();
return null;
}
}
