public int ItemStatusUpdate(ItemStatus itemStatus) { try { string commandText = @"UPDATE ItemStatus SET Name = @name, Description = @description WHERE Id = " + itemStatus.Id; Log.Debug("ItemStatusUpdate: [{0}], ItemStatus={1}", commandText, itemStatus.FormatItemStatus()); using (sqLiteConnection) { using (SQLiteCommand sqLiteCommand = new SQLiteCommand(commandText, sqLiteConnection)) { sqLiteConnection.Open(); sqLiteCommand.Parameters.AddWithValue("@name", itemStatus.Name); sqLiteCommand.Parameters.AddWithValue("@description", itemStatus.Description); int rowsUpdated = sqLiteCommand.ExecuteNonQuery(); sqLiteConnection.Close(); return rowsUpdated; } } } catch (Exception exception) { Log.Error(exception.ToString); return 0; } }
private ItemStatus ItemStatusSelect(string commandText) { try { using (sqLiteConnection) { sqLiteConnection.Open(); SQLiteCommand mycommand = new SQLiteCommand(sqLiteConnection) {CommandText = commandText}; SQLiteDataReader reader = mycommand.ExecuteReader(CommandBehavior.SequentialAccess); while (reader.Read()) { int id = reader.GetInt32(0); string name = reader.GetString(1); string description = reader.GetValue(2).ToString(); ItemStatus itemStatus = new ItemStatus { Id = id, Name = name, Description = description, }; Log.Debug("Found ItemStatus: {0}", itemStatus.FormatItemStatus()); return itemStatus; } reader.Close(); sqLiteConnection.Close(); } } catch (Exception exception) { Log.Error(exception.ToString()); } return null; }
public int ItemStatusInsert(ItemStatus itemStatus) { string insertCommand = String.Format(@"INSERT INTO ItemStatus (Name, Description) VALUES('{0}', '{1}')", itemStatus.Name, itemStatus.Description); return ExecuteNonQuery(insertCommand); }