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