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