public Ami_Period[] getData(string q)
{
model.cnx cnx = new cnx();
DataTable dataTable = new DataTable();
Ami_Period p = null;
Ami_Period[] parr = null;
dataTable = cnx.hacerSelect(q);
int cantidad = dataTable.Rows.Count;
if (dataTable != null && cantidad > 0)
{
parr = new Ami_Period[cantidad];
for (int i = 0; i < cantidad; i++)
{
p = new Ami_Period();
p.id = int.Parse(dataTable.Rows[i]["id"].ToString());
p.status = int.Parse(dataTable.Rows[i]["status"].ToString());
p.emissionDate = Convert.ToDateTime(dataTable.Rows[i]["emissionDate"].ToString());
p.endDate = Convert.ToDateTime(dataTable.Rows[i]["endDate"].ToString());
p.monthDate = int.Parse(dataTable.Rows[i]["monthDate"].ToString());
p.yearDate = int.Parse(dataTable.Rows[i]["yearDate"].ToString());
p.idPeriodRead = dataTable.Rows[i]["idPeriodRead"].ToString();
parr[i] = p;
}
}
return(parr);
}
private Ami_Medidores_Instalados[] getData(string q)
{
model.cnx cnx = new cnx();
DataTable dataTable = new DataTable();
Ami_Medidores_Instalados t = null;
Ami_Medidores_Instalados[] tarr = null;
dataTable = cnx.hacerSelect(q);
int cantidad = dataTable.Rows.Count;
if (dataTable != null && cantidad > 0)
{
tarr = new Ami_Medidores_Instalados[cantidad];
for (int i = 0; i < cantidad; i++)
{
t = new Ami_Medidores_Instalados();
t.ID = int.Parse(dataTable.Rows[i]["ID"].ToString());
t.COD_MEDIDOR = dataTable.Rows[i]["COD_MEDIDOR"].ToString();
t.COD_INTERNO = dataTable.Rows[i]["COD_INTERNO"].ToString();
t.RUTA = dataTable.Rows[i]["RUTA"].ToString();
t.ESN = dataTable.Rows[i]["ESN"].ToString();
tarr[i] = t;
}
}
return(tarr);
}
private Ami_Token[] getData(string q)
{
model.cnx cnx = new cnx();
DataTable dataTable = new DataTable();
Ami_Token t = null;
Ami_Token[] tarr = null;
dataTable = cnx.hacerSelect(q);
int cantidad = dataTable.Rows.Count;
if (dataTable != null && cantidad > 0)
{
tarr = new Ami_Token[cantidad];
for (int i = 0; i < cantidad; i++)
{
t = new Ami_Token();
t.id = int.Parse(dataTable.Rows[i]["id"].ToString());
t.meter = dataTable.Rows[i]["meter"].ToString();
t.period = int.Parse(dataTable.Rows[i]["period"].ToString());
t.status = int.Parse(dataTable.Rows[i]["status"].ToString());
t.token = dataTable.Rows[i]["token"].ToString();
t.tokenType = dataTable.Rows[i]["tokenType"].ToString();
tarr[i] = t;
}
}
return(tarr);
}
public bool transaction(List <string> tranList)
{
bool r = false;
cnx cnx = new cnx();
r = cnx.do_transaction(tranList);
return(r);
}
public bool setData(string q)
{
bool r = false;
cnx cnx = new cnx();
if (cnx.abrir())
{
r = cnx.hacerHit(q);
}
return(r);
}
public bool insert()
{
bool r = false;
string q =
"INSERT INTO AMI.dbo.Ami_Reads " +
"(fecha_lectura, whd, cod_medidor, whr, whnet, token_result, esn, serialnumber, readjson, token_request, period) " +
"VALUES('" + fecha_lectura.ToString("yyyy-MM-dd HH:mm:ss") + "'," + whd + ",'" + cod_medidor + "'," + whr + "," + whnet + ",'" + token_result + "','" + esn + "','" + serialnumber + "','" + readjson + "','" + token_request + "'," + period + "); ";
cnx cnx = new cnx();
if (cnx.abrir())
{
r = cnx.hacerHit(q);
}
return(r);
}
public bool insert()
{
bool r = false;
string q =
"INSERT INTO AMI.dbo.Ami_Control " +
"(status, token, meter, jsonData,executedDate) " +
"VALUES( '" + status + "', '" + token + "', '" + meter + "', '" + jsonData + "', GETDATE()); ";
cnx cnx = new cnx();
if (cnx.abrir())
{
r = cnx.hacerHit(q);
}
return(r);
}
