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