private static CollectionRelationshipDTO Populate(SqlDataReader reader)
{
CollectionRelationshipDTO obj = new CollectionRelationshipDTO()
{
CollectionRelationshipID = reader.GetInt32(reader.GetOrdinal("CollectionRelationshipID")),
ParentCollectionID = reader.GetInt32(reader.GetOrdinal("ParentCollectionID")),
CollectionID = reader.GetInt32(reader.GetOrdinal("CollectionID"))
};
return(obj);
}
public CollectionRelationshipDTO InsertCollectionRelationship(CollectionRelationshipDTO item)
{
using (SqlConnection connection = new SqlConnection(Properties.Settings.Default.DatabaseConnectoin))
{
connection.Open();
using (SqlCommand command = new SqlCommand())
{
command.CommandText = "INSERT INTO [dbo].[CollectionRelationship] ([ParentCollectionID], [CollectionID]) VALUES (@ParentCollectionID, @CollectionID); SELECT @@IDENTITY AS [ID]";
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@CollectionID", item.CollectionID);
command.Parameters.AddWithValue("@ParentCollectionID", item.ParentCollectionID);
item.CollectionRelationshipID = Convert.ToInt32(command.ExecuteScalar());
}
connection.Close();
connection.Dispose();
}
return(item);
}
