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