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 update(model.Ami_Token ami_Token) { bool r = false; r = ami_Token.updateStatusByToken(); return(r); }
public string qSuccsess(string token) { string q = ""; model.Ami_Token ami_Token = null; ami_Token = new model.Ami_Token(); ami_Token.status = 3;//Succsess ami_Token.token = token; q = convertToUpdateQuery(ami_Token); return(q); }
public string qFailure(string token) { string q = ""; model.Ami_Token ami_Token = null; ami_Token = new model.Ami_Token(); ami_Token.status = 5;//Failure ami_Token.token = token; q = convertToUpdateQuery(ami_Token); return(q); }
public string qCancell(string token) { string q = ""; model.Ami_Token ami_Token = null; ami_Token = new model.Ami_Token(); ami_Token.status = 4;//Cancell ami_Token.token = token; q = convertToUpdateQuery(ami_Token); return(q); }
public bool insert(dynamic resulToken, string meter, string tokenType) { dynamic dyObj = null; var json = ""; bool g = true; bool r = false; var param = resulToken; if (param is Ami_Diagnostic_Service.RequestToken) { Ami_Diagnostic_Service.RequestToken obj = new Ami_Diagnostic_Service.RequestToken(); obj = param; dyObj = obj; } else if (param is Ami_Control_Service.RequestToken) { Ami_Control_Service.RequestToken obj = new Ami_Control_Service.RequestToken(); obj = param; dyObj = obj; } else if (param is Ami_Data_Service.RequestToken) { Ami_Data_Service.RequestToken obj = new Ami_Data_Service.RequestToken(); obj = param; dyObj = obj; } else { g = false; } if (g) { model.Ami_Token ami_Token = new model.Ami_Token(); ami_Token.token = dyObj.Id.ToString(); ami_Token.status = 0; ami_Token.meter = meter; ami_Token.tokenType = tokenType; ami_Token.period = 1; r = ami_Token.insert(); } return(r); }