internal static void InsertDefaultGroup(int id, int parentID, string name, BitmapImage image, ImageFormat imageFormat)
{
try
{
var c = new ColorConverter();
var wpfFontConverter = new WPFFontConverter();
var sb = new StringBuilder();
sb.Append("INSERT INTO GROUPS (GROUP_ID, PARENT_ID, GROUP_NAME, ICON, BACK_COLOR, CAPTION_FONT_COLOR, CAPTION_FONT, SKIN_NAME, PASSWORD_STRING, IS_DEFAULT_IMAGE) VALUES(");
sb.Append(id);
sb.Append(",");
sb.Append(parentID);
sb.Append(",'");
sb.Append(name.Replace("'", "''"));
sb.Append("','");
var base64String = Convert.ToBase64String(image.ToBytes());
sb.Append(base64String);
//using (var ms = new MemoryStream(1))
//{
// image.Save(ms, imageFormat);
// ms.Position = 0;
// string base64String = Convert.ToBase64String(ms.ToArray());
// sb.Append(base64String);
//}
sb.Append("','");
sb.Append(c.ConvertToString(null, PNStatic.CultureInvariant, PNSkinlessDetails.DefColor));
sb.Append("','");
sb.Append(c.ConvertToString(null, PNStatic.CultureInvariant, SystemColors.ControlTextColor));
sb.Append("','");
var f = new PNFont { FontWeight = FontWeights.Bold };
sb.Append(wpfFontConverter.ConvertToString(f));
sb.Append("','");
sb.Append(PNSkinDetails.NO_SKIN);
sb.Append("','',1");
sb.Append("); ");
ExecuteTransactionForStringBuilder(sb, ConnectionString);
}
catch (Exception ex)
{
PNStatic.LogException(ex);
}
}
