public void showInventoryListView() { using (var sqlCon = new MySqlConnection(connection)) { try { sqlCon.Open(); using (var command = new MySqlCommand("SELECT * FROM inventory", sqlCon)) { using (var rdr = command.ExecuteReader()) { while (rdr.Read()) { var listViewItem = new ListViewItem(rdr[1].ToString()) { Tag = rdr[1] }; listViewItem.SubItems.Add(rdr[2].ToString()); listViewItem.SubItems.Add(rdr[3].ToString()); listViewItem.SubItems.Add(rdr[4].ToString()); listViewItem.SubItems.Add(rdr[5].ToString()); //listViewItem.SubItems.Add(address.ToString()); inventoryListView.Items.Add(listViewItem); } rdr.Close(); } } } catch (Exception e) { mL.ErrorLog(e.ToString()); } } }
public void showWeeklyInvoice() { using (var sqlCon = new MySqlConnection(connection)) { try { sqlCon.Open(); using (var command = new MySqlCommand(selectInvoicescommand, sqlCon)) { using (var rdr = command.ExecuteReader()) { while (rdr.Read()) { var address = $"{rdr[4]} {rdr[5]} {rdr[6]}"; var listViewItem = new ListViewItem(rdr[1].ToString()) { Tag = rdr[1] }; listViewItem.SubItems.Add(rdr[3].ToString()); listViewItem.SubItems.Add(address.ToString()); weeklyInvoiceView.Items.Add(listViewItem); } rdr.Close(); } } } catch (Exception e) { mL.ErrorLog(e.ToString()); } } }
public bool insertNewInvoice(Invoices inv) { try { using (MySqlConnection sqlCon = new MySqlConnection(SSHomeRestore.connection)) { sqlCon.Open(); using (MySqlCommand sqlCommand = new MySqlCommand()) { sqlCommand.CommandText = insertSQL; sqlCommand.Connection = sqlCon; sqlCommand.Parameters.AddWithValue("@woNum", inv.workOrderNum); sqlCommand.Parameters.AddWithValue("@acctNum", inv.accountNum); sqlCommand.Parameters.AddWithValue("@bID", inv.bankID.Trim(new Char[] { '(', ')' }));//SANITIZE THIS sqlCommand.Parameters.AddWithValue("@streetName", inv.streetName); sqlCommand.Parameters.AddWithValue("@cityName", inv.cityName.ToString()); sqlCommand.Parameters.AddWithValue("@stateName", inv.stateName); sqlCommand.Parameters.AddWithValue("@zipCode", inv.zipCode); sqlCommand.Parameters.AddWithValue("@wP", inv.workCompleted); sqlCommand.Parameters.AddWithValue("@dA", inv.dateAdded.ToString()); int numRowsInserted = sqlCommand.ExecuteNonQuery(); if (numRowsInserted == 1) { return(true); } else { return(false); } } } } catch (Exception e) { mL.ErrorLog(e.ToString()); return(false); } }