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