private void ResetForm(bool freset, bool resclear)
{
try
{
if (freset)
{
BTN_Start.Text = "Start";
BTN_Clr.Enabled = true;
TB_LogDir.Enabled = true;
BTN_LogDir.Enabled = true;
TB_Payload.Enabled = true;
TB_Version.Enabled = true;
LBL_Time.Text = "00:00:00";
}
if (resclear)
{
if (BTN_Start.Text == "Start")
{
TB_Payload.Text = "";
TB_Version.Text = "";
}
results.Clear();
DGV_Data.Refresh();
iplist.Clear();
waits.Clear();
}
}
catch
{
MessageBox.Show("Catastrophic ResetForm error.", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
public void ProcessCAI()
{
try
{
while (!cancel_request)
{
Build();
StartTimer();
Wait(TWAIT);
TMR_Tick.Stop();
LBL_Time.Text = "RUNNING";
Scan();
Check();
}
DGV_Data.Refresh();
FinalResult();
}
catch
{
MessageBox.Show("Catastrophic ProcessCAI error.", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool Remove(ConnectedApplianceInfo cai, IPData ipd)
{
bool changed = false;
try
{
string[] vers = cai.VersionNumber.Replace(" ", "").Split('|');
if (vers[0] == TVers)
{
ipd.Version = vers[0];
ipd.Done = true;
ipd.Result = "PASS - Product Version changed to final version.";
WriteFile(ipd.TabIndex, null);
DataRow dr = results.Rows[ipd.TabIndex];
results.Rows.Remove(dr);
changed = true;
DGV_Data.Refresh();
}
return(changed);
}
catch
{
MessageBox.Show("Catastrophic Remove error.", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
public bool RunCAITask(ConnectedApplianceInfo cai)
{
try
{
string[] parts;
IPData ipd;
if (cai != null)
{
parts = cai.VersionNumber.Replace(" ", "").Split('|');
if (parts[0] == TVers)
{
return(false);
}
ipd = AddResult(cai);
if (!RevelationConnect(cai))
{
ipd.Result = "FAIL - Revelation unable to connect.";
ipd.Done = true;
results.Rows[ipd.TabIndex]["OTA Result"] = iplist[ipd.TabIndex].Result;
WriteFile(ipd.TabIndex, null);
return(false);
}
else
{
if (SendRevelation(cai))
{
ipd.Result = "Revelation OTA payload sent.";
ipd.Sent = true;
results.Rows[ipd.TabIndex]["OTA Result"] = iplist[ipd.TabIndex].Result;
}
else
{
ipd.Result = "FAIL - Revelation unable to connect.";
ipd.Done = true;
results.Rows[ipd.TabIndex]["OTA Result"] = iplist[ipd.TabIndex].Result;
WriteFile(ipd.TabIndex, null);
return(false);
}
}
DGV_Data.Refresh();
return(true);
}
else
{
ipd = AddResult(cai);
ipd.Result = "FAIL - " + cai.IPAddress + " was unable to connect from WifiBasic.";
ipd.Done = true;
results.Rows[ipd.TabIndex]["OTA Result"] = iplist[ipd.TabIndex].Result;
DGV_Data.Refresh();
WriteFile(ipd.TabIndex, null);
return(false);
}
}
catch
{
MessageBox.Show("Catastrophic CAITask error.", "Error: RunCAITask",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
private void BTN_Clear_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("This will clear all IPs and their results from all windows. Press Yes to Clear or No to Cancel.",
"Verify Full Clear", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dialogResult == DialogResult.Yes)
{
parent.results.Clear();
parent.iplist.Clear();
parent.LB_IPs.Items.Clear();
DGV_Data.Refresh();
if (parent.autogen)
{
parent.autogen = false;
parent.BTN_MakeList.Enabled = true;
parent.BTN_Import.Enabled = true;
}
}
}
public void CancelRequest()
{
try
{
int stop = iplist.Count();
for (int i_base = 0; i_base < stop; i_base++)
{
if (iplist[i_base].Result.Contains("PASS") || iplist[i_base].Result.Contains("FAIL"))
{
continue;
}
else
{
if (results.Rows.Count < 0)
{
break;
}
iplist[i_base].Result = "FAIL - Cancelled by User.";
results.Rows[i_base]["OTA Result"] = iplist[i_base].Result;
iplist[i_base].Done = true;
WriteFile(i_base, null);
}
}
DGV_Data.Refresh();
foreach (Thread thread in waits)
{
//Wake sleeping wait threads that will no longer be used
if (thread.IsAlive)
{
thread.Interrupt();
}
}
}
catch
{
MessageBox.Show("Catastrophic thread closure error. Closing all threads and parent environment (Widebox).", "Error: Threads Failed to Close",
MessageBoxButtons.OK, MessageBoxIcon.Error);
//Environment.Exit(1);
}
}
private void SetText()
{
foreach (string s in responses)
{
string[] parts = s.Split('\t');
IPData ipd = iplist.FirstOrDefault(x => x.IPAddress == parts[0]);
listindex = iplist.IndexOf(ipd);
int rtt = parts[1].EndsWith("ms") ? int.Parse(parts[1].Substring(0, parts[1].Length - 2)) : pingtimeout;
iplist[listindex].AddReply(rtt);
if (parts[2] == "FALSE" && iplist[listindex].LinkState != -1)
{
iplist[listindex].LinkState = 0;
}
results.Rows[listindex]["Avg Resp Time"] = iplist[listindex].Average;
results.Rows[listindex]["# Missed Pings"] = iplist[listindex].DropCount;
results.Rows[listindex]["Ping Response %"] = iplist[listindex].UptimePct;
results.Rows[listindex]["Link State"] = iplist[listindex].LinkState;
results.Rows[listindex]["Claim State"] = iplist[listindex].ClaimState;
results.Rows[listindex]["Cloud Disconnect Count"] = iplist[listindex].MQTTDropCount;
results.Rows[listindex]["Current Connected Time"] = iplist[listindex].ConnectedTime.ToString("g");
results.Rows[listindex]["Current Disconnected Time"] = iplist[listindex].DisconnectedTime.ToString("g");
results.Rows[listindex]["Wifi Resync Statistics"] = iplist[listindex].WifiResyncStatistics;
try
{
using (StreamWriter sw = File.AppendText(curfilename))
{
sw.WriteLine(DateTime.Now.ToString("MM/dd/yy hh:mm:ss") + "," + parts[0] + "," +
iplist[listindex].MACAddress + "," +
rtt + "," +
iplist[listindex].DropCount + "," +
iplist[listindex].UptimePct + "," +
iplist[listindex].LinkState + "," +
iplist[listindex].ClaimState + "," +
iplist[listindex].MQTTDropCount + "," +
iplist[listindex].ConnectedTime.ToString("g") + "," +
iplist[listindex].DisconnectedTime.ToString("g") + "," +
iplist[listindex].WifiResyncStatistics);
}
}
catch { }
}
/*//LB_Response.Items.Add(pingresp);
* string[] parts = pingresp.Split('\t');
* int rtt = parts[1].EndsWith("ms") ? int.Parse(parts[1].Substring(0,parts[1].Length-2)) : pingtimeout;
* iplist[listindex].AddReply(rtt,mqttresp);
* results.Rows[listindex]["Avg Resp Time"] = iplist[listindex].Average;
* results.Rows[listindex]["# Missed Packets"] = iplist[listindex].DropCount;
* results.Rows[listindex]["Uptime %"] = iplist[listindex].Uptime;
* results.Rows[listindex]["MQTT Drop Count"] = iplist[listindex].MQTTDropCount;
* results.Rows[listindex]["MQTT Uptime %"] = iplist[listindex].MQTTUptime;*/
DGV_Data.Refresh();
responses.Clear();
/*try
* {
* sw.WriteLine(DateTime.Now.ToString("MM/dd/yy hh:mm:ss") + "," + parts[0] + "," + rtt + "," + mqttresp);
* }
* catch { }*/
}
private void IB_Buscar_Click(object sender, EventArgs e)
{
string parametro = "";
int VARIABLE = 0;
if (cliente == null)
{
cliente = new Negocios.Cliente();
}
try {
DGV_Data.Refresh();
if (TB_ID.Text != " Codigo" && TB_ID.Text != "")
{
if (VARIABLE != 1)
{
parametro = " ID_CLIENTE =" + TB_ID.Text;
}
VARIABLE = 1;
}
if (TB_Nombre.Text != " Nombre" && TB_Nombre.Text != "")
{
if (VARIABLE != 1)
{
parametro = " NOMB_CLIENTE LIKE '%" + TB_Nombre.Text + "%'";
}
else
{
parametro = parametro + " AND NOMB_CLIENTE LIKE '%" + TB_Nombre.Text + "%'";
}
VARIABLE = 1;
}
if (TB_Direccion.Text != " Direccion" && TB_Direccion.Text != "")
{
if (VARIABLE != 1)
{
parametro = " DIRECCION LIKE '%" + TB_Direccion.Text + "%'";
}
else
{
parametro = parametro + " AND DIRECCION LIKE '%" + TB_Direccion.Text + "%'";
}
VARIABLE = 1;
}
if (TB_Pais.Text != " Pais" && TB_Pais.Text != "")
{
if (VARIABLE != 1)
{
parametro = " PAIS LIKE '%" + TB_Pais.Text + "%'";
}
else
{
parametro = parametro + " AND PAIS LIKE '%" + TB_Pais.Text + "%'";
}
VARIABLE = 1;
}
string SQL = @"SELECT ID_CLIENTE, NOMB_CLIENTE, DIRECCION, PAIS, SALDO_INIC, SALDO_ACT, Estatus FROM dbo.CLIENTES ";
if (VARIABLE == 1)
{
parametro = SQL + " WHERE " + parametro;
dataSet.Clear();
//dataSet = cliente.BuscarRecord(parametro);
DGV_Data.AutoGenerateColumns = false;
DGV_Data.DataSource = dataSet;
DGV_Data.DataMember = "VerRecord";
L_Registros.Visible = true;
L_Registros.Text = string.Format("R: {0}", dataSet.Tables["VerRecord"].Rows.Count.ToString());
}
else
{
MostrarTodoslosRegistrosCargados();
DGV_Data.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
L_Registros.Visible = false;
}
} catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
private void IB_Buscar_Click(object sender, EventArgs e)
{
string parametro = "";
int VARIABLE = 0;
obj = new Negocios.Producto();
try {
DGV_Data.Refresh();
if (TB_ID.Text != " Codigo" && TB_ID.Text != "")
{
if (VARIABLE != 1)
{
parametro = " ID_PRODUCTO=" + TB_ID.Text;
}
VARIABLE = 1;
}
if (TB_Descripcion.Text != " Descripcion" && TB_Descripcion.Text != "")
{
if (VARIABLE != 1)
{
parametro = " DESC_PRODUCTO LIKE '%" + TB_Descripcion.Text + "%'";
}
else
{
parametro = parametro + " AND DESC_PRODUCTO LIKE '%" + TB_Descripcion.Text + "%'";
}
VARIABLE = 1;
}
if (TB_Fabricante.Text != " Fabricante" && TB_Fabricante.Text != "")
{
if (VARIABLE != 1)
{
parametro = " NOMB_FABRICANTE LIKE '%" + TB_Fabricante.Text + "%'";
}
else
{
parametro = parametro + " AND NOMB_FABRICANTE LIKE '%" + TB_Fabricante.Text + "%'";
}
VARIABLE = 1;
}
string SQL = @"SELECT TOP (1000) [ID_PRODUCTO],[DESC_PRODUCTO],Fabricante.NOMB_FABRICANTE,[COSTO],[PRECIO]" +
" FROM [BD_VENTAS].[dbo].[PRODUCTOS] as Producto" +
" Inner Join [BD_VENTAS].[dbo].[FABRICANTES] as Fabricante" +
" on Producto.ID_FABRICANTE = Fabricante.ID_FABRICANTE";
if (VARIABLE == 1)
{
parametro = SQL + " WHERE " + parametro;
dataSet.Clear();
dataSet = obj.BuscarRecord(parametro);
DGV_Data.AutoGenerateColumns = false;
//SetupColumns(DSQL);
DGV_Data.DataSource = dataSet;
DGV_Data.DataMember = "VerRecord";
L_Registros.Visible = true;
L_Registros.Text = string.Format("R: {0}", dataSet.Tables["VerRecord"].Rows.Count.ToString());
}
else
{
MostrarTodoslosRegistrosCargados();
DGV_Data.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
L_Registros.Visible = false;
}
} catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
private void IB_Buscar_Click(object sender, EventArgs e)
{
string parametro = "";
int VARIABLE = 0;
obj = new Negocios.Fabricante();
try {
DGV_Data.Refresh();
if (TB_ID.Text != " Codigo" && TB_ID.Text != "")
{
if (VARIABLE != 1)
{
parametro = " ID_FABRICANTE =" + TB_ID.Text;
}
VARIABLE = 1;
}
if (TB_Nombre.Text != " Nombre" && TB_Nombre.Text != "")
{
if (VARIABLE != 1)
{
parametro = " NOMB_FABRICANTE LIKE '%" + TB_Nombre.Text + "%'";
}
else
{
parametro = parametro + " AND NOMB_FABRICANTE LIKE '%" + TB_Nombre.Text + "%'";
}
VARIABLE = 1;
}
if (TB_Direccion.Text != " Direccion" && TB_Direccion.Text != "")
{
if (VARIABLE != 1)
{
parametro = " DIRECCION LIKE '%" + TB_Direccion.Text + "%'";
}
else
{
parametro = parametro + " AND DIRECCION LIKE '%" + TB_Direccion.Text + "%'";
}
VARIABLE = 1;
}
if (TB_Pais.Text != " Pais" && TB_Pais.Text != "")
{
if (VARIABLE != 1)
{
parametro = " PAIS LIKE '%" + TB_Pais.Text + "%'";
}
else
{
parametro = parametro + " AND PAIS LIKE '%" + TB_Pais.Text + "%'";
}
VARIABLE = 1;
}
string SQL = @"SELECT TOP (1000) [ID_FABRICANTE],[NOMB_FABRICANTE],[DIRECCION],[PAIS] FROM [BD_VENTAS].[dbo].[FABRICANTES]";
if (VARIABLE == 1)
{
parametro = SQL + " WHERE " + parametro;
dataSet.Clear();
dataSet = obj.BuscarRecord(parametro);
DGV_Data.AutoGenerateColumns = false;
//SetupColumns(DSQL);
DGV_Data.DataSource = dataSet;
DGV_Data.DataMember = "VerRecord";
L_Registros.Visible = true;
L_Registros.Text = string.Format("R: {0}", dataSet.Tables["VerRecord"].Rows.Count.ToString());
}
else
{
MostrarTodoslosRegistrosCargados();
L_Registros.Visible = false;
}
} catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
private void IB_Buscar_Click(object sender, EventArgs e)
{
string parametro = "";
int VARIABLE = 0;
obj = new Negocios.Vendedor();
try {
DGV_Data.Refresh();
if (TB_ID.Text != " Codigo" && TB_ID.Text != "")
{
if (VARIABLE != 1)
{
parametro = " ID_VENDEDOR=" + TB_ID.Text;
}
VARIABLE = 1;
}
if (TB_Nombre.Text != " Nombre" && TB_Nombre.Text != "")
{
if (VARIABLE != 1)
{
parametro = " NOMB_VENDEDOR LIKE '%" + TB_Nombre.Text + "%'";
}
else
{
parametro = parametro + " AND NOMB_VENDEDOR LIKE '%" + TB_Nombre.Text + "%'";
}
VARIABLE = 1;
}
if (TB_Oficina.Text != " Oficina" && TB_Oficina.Text != "")
{
if (VARIABLE != 1)
{
parametro = " OFICINA LIKE '%" + TB_Oficina.Text + "%'";
}
else
{
parametro = parametro + " AND OFICINA LIKE '%" + TB_Oficina.Text + "%'";
}
VARIABLE = 1;
}
string SQL = @"SELECT TOP (1000) [ID_VENDEDOR],[NOMB_VENDEDOR],[ID_JEFE],[OFICINA],[COMISION]" +
" FROM [BD_VENTAS].[dbo].[VENDEDOR]";
if (VARIABLE == 1)
{
parametro = SQL + " WHERE " + parametro;
dataSet.Clear();
dataSet = obj.BuscarRecord(parametro);
DGV_Data.AutoGenerateColumns = false;
//SetupColumns(DSQL);
DGV_Data.DataSource = dataSet;
DGV_Data.DataMember = "VerRecord";
L_Registros.Visible = true;
L_Registros.Text = string.Format("R: {0}", dataSet.Tables["VerRecord"].Rows.Count.ToString());
}
else
{
MostrarTodoslosRegistrosCargados();
DGV_Data.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
L_Registros.Visible = false;
}
} catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
