/// <summary> /// Inserts new item type. /// </summary> /// <param name="itemType">The item type.</param> /// <returns><c>true</c> on success.</returns> public bool InsertItemType(ItemType itemType) { Log.DebugFormat("InsertItemType '{0}'", itemType); using (dbConnection) { using (DbCommand dbCommand = dbConnection.CreateCommand()) { dbConnection.Open(); string commandText = String.Format(CultureInfo.InvariantCulture, "INSERT INTO ItemType (Name) VALUES('{0}')", itemType.Name); Log.Debug(commandText); dbCommand.CommandText = commandText; if (dbCommand.ExecuteNonQuery() == 1) { return true; } Log.ErrorFormat("Failed to insert itemType [{0}]", itemType); return false; } } }
/// <summary> /// Gets the item types. /// </summary> /// <returns></returns> public IList<ItemType> GetItemTypes() { Log.Debug("GetItemTypes"); IList<ItemType> itemTypes = new List<ItemType>(); using (dbConnection) { using (DbCommand dbCommand = dbConnection.CreateCommand()) { dbConnection.Open(); const string commandText = "SELECT * FROM ItemType"; dbCommand.CommandText = commandText; Log.Debug(commandText); using (DbDataReader reader = dbCommand.ExecuteReader()) { while (reader.Read()) { ItemType itemType = new ItemType { Id = Int32.Parse(reader[0].ToString()), Name = reader[1].ToString(), }; itemTypes.Add(itemType); Log.InfoFormat("Adding ItemType [{0}]", itemType); } } } } return itemTypes; }