private static ItemAttributeOptionDTO Populate(SqlDataReader reader) { ItemAttributeOptionDTO obj = new ItemAttributeOptionDTO() { ItemAttributeID = reader.GetInt32(reader.GetOrdinal("ItemAttributeID")), ItemAttributeOptionID = reader.GetInt32(reader.GetOrdinal("ItemAttributeOptionID")), DisplayLabel = reader.GetString(reader.GetOrdinal("DisplayLabel")), DisplayOrder = reader.GetInt32(reader.GetOrdinal("DisplayOrder")), Value = reader.GetString(reader.GetOrdinal("Value")) }; return(obj); }
public ItemAttributeOptionDTO UpdateItemAttributeOption(ItemAttributeOptionDTO item) { using (SqlConnection connection = new SqlConnection(Properties.Settings.Default.DatabaseConnectoin)) { connection.Open(); using (SqlCommand command = new SqlCommand()) { command.CommandText = "UPDATE [dbo].[ItemAttributeOption] SET [DisplayLabel] = @DisplayLabel, [Value] = @Value, [DisplayOrder] = @DisplayOrder WHERE [ItemAttributeOptionID] = @ItemAttributeOptionID"; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@DisplayLabel", item.DisplayLabel); command.Parameters.AddWithValue("@Value", item.Value); command.Parameters.AddWithValue("@DisplayOrder", item.DisplayOrder); command.Parameters.AddWithValue("@ItemAttributeOptionID", item.ItemAttributeOptionID); command.ExecuteNonQuery(); } connection.Close(); connection.Dispose(); } return(item); }
public ItemAttributeOptionDTO InsertItemAttributeOption(ItemAttributeOptionDTO item) { using (SqlConnection connection = new SqlConnection(Properties.Settings.Default.DatabaseConnectoin)) { connection.Open(); using (SqlCommand command = new SqlCommand()) { command.CommandText = "INSERT INTO [dbo].[ItemAttributeOption] ([DisplayLabel], [Value], [DisplayOrder], [ItemAttributeID]) VALUES (@DisplayLabel, @Value, @DisplayOrder, @ItemAttributeID); SELECT @@IDENTITY AS [ID]"; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@DisplayLabel", item.DisplayLabel); command.Parameters.AddWithValue("@Value", item.Value); command.Parameters.AddWithValue("@DisplayOrder", item.DisplayOrder); command.Parameters.AddWithValue("@ItemAttributeID", item.ItemAttributeID); item.ItemAttributeOptionID = Convert.ToInt32(command.ExecuteScalar()); } connection.Close(); connection.Dispose(); } return(item); }