public static List <object[]> exampleCnxOdooADONET()
{
var odooConfigCnn = new OdooConnectionStringBuilder
{
URL = "https://deltacargo-deltaw-515413.dev.odoo.com",
Database = "deltacargo-deltaw-515413",
User = "******",
Password = "******"
};
OdooConnection cnn = null;
try
{
cnn = new OdooConnection(odooConfigCnn);
cnn.Open();
OdooCommand cmd = new OdooCommand("SELECT id, name FROM res_partner", cnn);
List <object[]> dataList = new List <object[]>();
OdooDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
dataList.Add(new object[] { dr["id"], dr["name"], });
}
return(dataList);
}
catch (Exception e)
{
throw e;
}
finally
{
cnn.Close();
}
}
public void initConfig(string url, string dbName, string userName, string password)
{
OdooConnectionStringBuilder config = new OdooConnectionStringBuilder()
{
URL = url,
Database = dbName,
User = userName,
Password = password
};
odooConnection = new OdooConnection(config);
}
// Metodo de obtener de datos
public static List <MetadataModel> getTablesOdoo()
{
// credenciales estaticas
var odooConfigCnn = new OdooConnectionStringBuilder
{
URL = "https://deltacargo-deltaw-515413.dev.odoo.com",
Database = "deltacargo-deltaw-515413",
User = "******",
Password = "******"
};
//string cnnString = "URL = https://deltacargo-deltaw-515413.dev.odoo.com; User = [email protected]; Password = delta011235813; Database = deltacargo-deltaw-515413;";
OdooConnection cnn = null;
try
{
cnn = new OdooConnection(odooConfigCnn);
List <MetadataModel> dataList = new List <MetadataModel>();
int index = 0;
cnn.Open();
DataTable dt = cnn.GetSchema("Tables");
foreach (DataRow row in dt.Rows)
{
var objMetaModelo = new MetadataModel
{
id = ++index,
tableCatalog = row[0].ToString(),
tableSchema = row[1].ToString(),
tableName = row[2].ToString(),
tableType = row[3].ToString(),
};
/*
* List<Object> objCurrent = new List<object>() { ++index };
* foreach (DataColumn col in dt.Columns)
* {
* objCurrent.Add(row[col]);
* }*/
dataList.Add(objMetaModelo);
}
return(dataList);
}
catch (Exception e)
{
throw e;
}
finally
{
cnn.Clone();
}
}
