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