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