private void saveSettingsButton_Clicked(object sender, EventArgs e) { foreach (object field in settingFields) { SettingModel setting = new SettingModel(); if (field.GetType() == typeof(TextBox)) { TextBox tb = (TextBox)field; setting.SettingName = tb.Name; setting.SettingValue = tb.Text; if (!SqliteDataMgr.SettingExists(tb.Name)) { SqliteDataMgr.AddSetting(setting); } else { SqliteDataMgr.UpdateSetting(setting); } } } SKUDBMgr.ConnectToDatabase(databaseLocation.Text.Trim()); }
private void skuPromptInputBox_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { string result = SKUDBMgr.ExecuteQuery($"SELECT F3 FROM SmartphoneTable WHERE F9='{skuPromptInputBox.Text.Trim()}' OR F10='{skuPromptInputBox.Text.Trim()}' OR F11='{skuPromptInputBox.Text.Trim()}'", skuDataGridView); if (result != "") { skuDataGridView.ClearSelection(); skuDataGridView.CurrentCell = null; skuOptionInputBox.Enabled = true; skuOptionInputBox.Focus(); } else { result = SKUDBMgr.ExecuteQuery($"SELECT F2 FROM TabletsTable WHERE F8='{skuPromptInputBox.Text.Trim()}' OR F9='{skuPromptInputBox.Text.Trim()}' OR F10='{skuPromptInputBox.Text.Trim()}'", skuDataGridView); if (result != "") { skuDataGridView.ClearSelection(); skuDataGridView.CurrentCell = null; skuOptionInputBox.Enabled = true; skuOptionInputBox.Focus(); } else { result = SKUDBMgr.ExecuteQuery($"SELECT F2 FROM MP3Table WHERE F8='{skuPromptInputBox.Text.Trim()}' OR F9='{skuPromptInputBox.Text.Trim()}' OR F10='{skuPromptInputBox.Text.Trim()}'", skuDataGridView); if (result != "") { skuDataGridView.ClearSelection(); skuDataGridView.CurrentCell = null; skuOptionInputBox.Enabled = true; skuOptionInputBox.Focus(); } else { skuPromptInputBox.SelectAll(); MessageBox.Show("Cannot Find SKU"); } } } } }
public Form1() { InitializeComponent(); deviceList.SelectionMode = DataGridViewSelectionMode.FullRowSelect; updateThread = new BackgroundWorker(); updateThread.DoWork += UpdateThread_DoWork; updateThread.RunWorkerCompleted += UpdateThread_RunUpdateCompleted; updateThread.ProgressChanged += UpdateThread_ProgressChanged; updateThread.WorkerReportsProgress = true; updateThread.WorkerSupportsCancellation = true; settingFields = new List <object>(); settingFields.Add(dataLocation); settingFields.Add(labelerLocation); settingFields.Add(labelLocation); settingFields.Add(databaseLocation); mainString = new StringBuilder(); mainString2 = new StringBuilder(); selectOptionCB.SelectedIndex = 0; this.KeyPreview = true; LoadSettings(); SKUDBMgr.ConnectToDatabase(databaseLocation.Text.Trim()); object[] row = { "iphone 5s 16gb", "1234asf1234df", "11111333333444", "111113333334445555", "M123 LL/A 2345", null }; object[] row2 = { "iphone 7s 32gb", "345gfg43tt3vv", "111155333444", "1111553334447777", "M456 LL/A rwrt", null }; object[] row3 = { "iphone 11 pro 128gb", "7u7u7u7u7u7u", "00000088677774", "000006555333", "M765 LL/A feef", null }; object[] row4 = { "iphone 6s 64gb", "8i8i8i8i8i8i", "222223333445", "6664446464646", "M353 LL/A f33g", null }; object[] row5 = { "iphone 8 16gb", "9o9o6u6y5t4t4t", "57575757575757", "5757575757", "M634 LL/A aa4g", null }; //var listViewItem = new ListViewItem(row); deviceList.Rows.Add(row); deviceList.Rows.Add(row2); deviceList.Rows.Add(row3); deviceList.Rows.Add(row4); deviceList.Rows.Add(row5); //ProcessLabels("THIS IS TITLE ENJOY", "whats going on man", null, @"C:\Users\Vince\Documents\QrCodeLabelTemp2.dotx", true); //doc.Close(ref saveChanges, ref missing, ref missing); //AndroidMgr.GetConnectedDevices(); /* * ImageConverter conv = new ImageConverter(); * System.Drawing.Image im = Bitmap.FromFile(@"C:\Users\Vince\Pictures\maxresdefault.jpg"); * byte[] xByte = (byte[])conv.ConvertTo(im, typeof(byte[])); * * * * //SKUDBMgr.ExecuteQuery($"INSERT INTO Pics (Data) VALUES ('{"efe"}')",null); * * //SKUDBMgr.ExecuteQuery("SELECT F1 FROM Table1 WHERE F2='23456'"); * * string qry = "INSERT INTO Pics (Data) VALUES(@Data)"; * * using (SKUDBMgr.conn) * { * OleDbCommand cmd = new OleDbCommand(qry, SKUDBMgr.conn); * cmd.Parameters.AddWithValue("@Data", xByte); * * //SKUDBMgr.conn.Open(); * cmd.ExecuteNonQuery(); * } * * List<KeyValuePair<string, object>> values = new List<KeyValuePair<string, object>>(); * * values.Add(new KeyValuePair<string, object>("F9", "00500")); * values.Add(new KeyValuePair<string, object>("F11", "44444")); * * SKUDBMgr.ExecuteQuery(SKUDBMgr.SKUDBOPTIONS.SELECT, "Smartphones", new List<string> { "F3","F9","F11"}, SKUDBMgr.SKUDBOPTIONS.FROM, values,SKUDBMgr.SKUDBOPTIONS.WHERE,SKUDBMgr.SKUDBOPTIONS.OR); * * * var usbDevices = GetUSBDevices(); * * foreach (var usbDevice in usbDevices) * { * Console.WriteLine("Device ID: {0}, PNP Device ID: {1}, Description: {2}", * usbDevice.DeviceID, usbDevice.PnpDeviceID, usbDevice.Description); * } * * Console.Read(); */ AndroidMgr.InitiateADBService(); List <string> dev = AndroidMgr.GetConnectedDevices(); foreach (string devs in dev) { Console.WriteLine(devs); } foreach (aDevice ad in AndroidMgr.LoadDevices(dev)) { Console.WriteLine($"DEVICE: {ad.deviceName} MODEL: {ad.model} SERIAL: {ad.serialNo} IMEI: {ad.imeiNo} MANUFACTURER: {ad.manufacturer}"); } }