public void EditHardwareItem(HardwareItem itemToEdit)
{
using (SQLiteCommand com = new SQLiteCommand(con))
{
com.CommandText = "UPDATE Hardware SET itemName = '" + itemToEdit.ItemName + "', price = '" + itemToEdit.ItemPrice + "', weight = '" + itemToEdit.Weight + "' WHERE itemID = '" + itemToEdit.ItemID + "';";
com.ExecuteNonQuery();
}
}
public void DeleteHardware(HardwareItem itemToDelete)
{
using (SQLiteCommand com = new SQLiteCommand(con))
{
com.CommandText = "DELETE FROM Hardware WHERE itemID = '" + itemToDelete.ItemID + "';";
com.ExecuteNonQuery();
}
}
public void SaveItemHardware(HardwareItem itemToSave)
{
using (SQLiteCommand com = new SQLiteCommand(con))
{
com.CommandText = "INSERT INTO Hardware (itemID, itemName, price, weight) VALUES ('" + itemToSave.ItemID + "', '" + itemToSave.ItemName + "', '" + itemToSave.ItemPrice + "', '" + itemToSave.Weight + "' );";
com.ExecuteNonQuery();
com.Dispose();
}
}
public void SaveHardware(HardwareItem hardToSave)
{
SQLiteConnection conn = new SQLiteConnection("data source=itemsDatabase.db");
conn.Open();
using (SQLiteCommand com = new SQLiteCommand(conn))
{
com.CommandText = "INSERT INTO Items (SerialNumber,ItemName,Price,Weight) " +
"VALUES (" + hardToSave.ItemID + ",'" + hardToSave.ItemName + "','" + hardToSave.ItemPrice + "','" + hardToSave.Weight + "')";
com.ExecuteNonQuery();
com.Dispose();
}
conn.Close();
}
public void updateHardware(int id, HardwareItem hardToUpdate)
{
SQLiteConnection conn = new SQLiteConnection("data source=itemsDatabase.db");
conn.Open();
using (SQLiteCommand com = new SQLiteCommand(conn))
{
com.CommandText = "UPDATE Items " +
"SET ItemName='" + hardToUpdate.ItemName + "', Price=" + hardToUpdate.ItemPrice + ", Weight=" + hardToUpdate.Weight + "" +
" WHERE SerialNumber=" + id + ";";
com.ExecuteNonQuery();
com.Dispose();
}
conn.Close();
}
public HardwareItem readHardware(int id)
{
HardwareItem hard = new HardwareItem();
SQLiteConnection conn = new SQLiteConnection("data source=itemsDatabase.db");
conn.Open();
SQLiteCommand comm = new SQLiteCommand("SELECT Weight FROM Items WHERE ItemID=" + id + ";", conn);
using (SQLiteDataReader read = comm.ExecuteReader())
{
while (read.Read())
{
hard.Weight = read.GetDouble(0);
}
return(hard);
}
}
public List <HardwareItem> ReadHardwareItems()
{
List <HardwareItem> seznam = new List <HardwareItem>();
using (SQLiteCommand com = new SQLiteCommand(con))
{
com.CommandText = "SELECT * FROM Hardware";
SQLiteDataReader reader = null;
reader = com.ExecuteReader();
while (reader.Read())
{
HardwareItem item = new HardwareItem(Convert.ToString(reader["itemID"]), Convert.ToString(reader["itemName"]), Convert.ToDouble(reader["price"]), Convert.ToDouble(reader["weight"]));
seznam.Add(item);
}
}
return(seznam);
}
