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