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