private static void InitializeDb_SqlServer()
{
using (SqlConnection connection = GetNewOpenDbConnection_SqlServer())
{
using (SqlCommand command = connection.CreateCommand())
{
// *** Initialize the [Ex_A_306] TABLE ******
command.CommandText = "INSERT INTO [Ex_A_306] ([ID], [PictureTrimmerValue], [SourceImage], [OutputImage]) VALUES (@Id, @PictureTrimmerValue, @SourceImage, @OutputImage)";
command.Parameters.AddWithValue("@Id", 1);
string sourceImageFilePath = HttpContext.Current.Server.MapPath("~/repository/source/trevi1.jpg");
command.Parameters.AddWithValue("@SourceImage", File.ReadAllBytes(sourceImageFilePath));
string pictureTrimmerValueString = "{\"imageSelection\":{\"transformation\":{\"resizeFactor\":102.4734,\"rotationAngle\":0,\"flipH\":true,\"flipV\":false},\"crop\":{\"rectangle\":{\"x\":34,\"y\":37,\"width\":320,\"height\":180},\"canvasColor\":{\"value\":{\"a\":255,\"r\":255,\"g\":255,\"b\":255},\"autoUseTransparentColor\":true}}},\"imageAdjustments\":{\"brightness\":-1.973684,\"contrast\":5.921052,\"hue\":-180,\"saturation\":-13.1579},\"imageBackColorApplyMode\":1}";
command.Parameters.AddWithValue("@PictureTrimmerValue", pictureTrimmerValueString);
PictureTrimmerValue value = PictureTrimmerValue.FromJSON(pictureTrimmerValueString);
command.Parameters.AddWithValue("@OutputImage", value.SaveProcessedImageToByteArray(sourceImageFilePath, new JpegFormatEncoderParams()));
command.ExecuteNonQuery();
// *********
}
}
}
