public void InsertFlowerBucket(FlowersBucket bucket)
{
List <int> flowerIds = new List <int>();
foreach (var flower in bucket.Flowers)
{
flowerIds.Add(InsertFlower(flower));
}
string query = string.Format("INSERT INTO flower_bucket (price, currency) output INSERTED.ID " +
"VALUES (@{0},@{1})", FLOWER_BUCKET_PRICE_FIELD, FLOWER_BUCKET_CURRENCY_FIELD);
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = new SqlParameter(FLOWER_PRICE_FIELD, SqlDbType.Int);
parameters[0].Value = bucket.Price;
parameters[1] = new SqlParameter(FLOWER_CURRENCY_FIELD, SqlDbType.VarChar);
parameters[1].Value = bucket.Currency;
int bucketId = DbConnection.ExecuteResultIdOperation(query, parameters);
string flowerBucketQuery = string.Format("INSERT INTO flower_bucket_flower (flower_id, bucket_id) VALUES (@{0},@{1})",
FLOWER_BUCKET_FLOWER_ID_FIELD, FLOWER_BUCKET_BUCKET_ID_FIELD);
foreach (var flowerId in flowerIds)
{
SqlParameter[] parametersFBQuery = new SqlParameter[2];
parametersFBQuery[0] = new SqlParameter(FLOWER_BUCKET_FLOWER_ID_FIELD, SqlDbType.Int);
parametersFBQuery[0].Value = flowerId;
parametersFBQuery[1] = new SqlParameter(FLOWER_BUCKET_BUCKET_ID_FIELD, SqlDbType.Int);
parametersFBQuery[1].Value = bucketId;
DbConnection.ExecuteNonResultOperation(flowerBucketQuery, parametersFBQuery);
}
}
private static void TestSerializationDeserialization()
{
FlowersBucket bucket = CreateBucketDirectly();
Console.WriteLine("Created directly flower bucket: " + Environment.NewLine + bucket.ToString());
FlowersBucket bucketFromXml = CreateBucketFromXml();
Console.WriteLine("Created from XML flower bucket: " + Environment.NewLine + bucketFromXml.ToString());
FlowersBucket bucketFromTextFile = CreateBucketFromTextFile();
Console.WriteLine("Created from text file flower bucket: " + Environment.NewLine + bucketFromTextFile.ToString());
FlowersBucket bucketFromBinaryFile = CreateBucketFromBinaryFile();
Console.WriteLine("Created from binary file flower bucket: " + Environment.NewLine + bucketFromBinaryFile.ToString());
FlowersBucket bucketFromJsonFile = CreateBucketFromJsonFile();
Console.WriteLine("Created from json file flower bucket: " + Environment.NewLine + bucketFromJsonFile.ToString());
Console.ReadLine();
}
