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