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