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