internal static void InsertNewGroup(PNGroup group)
{
try
{
var c = new ColorConverter();
var drcc = new System.Drawing.ColorConverter();
var wfc = new WPFFontConverter();
var lfc = new LogFontConverter();
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, FONT, FONT_COLOR, IS_DEFAULT_IMAGE) VALUES(");
sb.Append(group.ID);
sb.Append(",");
sb.Append(group.ParentID);
sb.Append(",'");
sb.Append(group.Name.Replace("'", "''"));
sb.Append("','");
if (!group.IsDefaultImage)
{
var base64String = Convert.ToBase64String(group.Image.ToBytes());
sb.Append(base64String);
}
else
{
sb.Append(group.ImageName);
sb.Append(".png");
}
//using (var ms = new MemoryStream(1))
//{
// group.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
// ms.Position = 0;
// string base64String = Convert.ToBase64String(ms.ToArray());
// sb.Append(base64String);
//}
sb.Append("','");
sb.Append(c.ConvertToString(null, PNStatic.CultureInvariant, group.Skinless.BackColor));
sb.Append("','");
sb.Append(c.ConvertToString(null, PNStatic.CultureInvariant, group.Skinless.CaptionColor));
sb.Append("','");
sb.Append(wfc.ConvertToString(group.Skinless.CaptionFont));
sb.Append("','");
sb.Append(group.Skin.SkinName);
sb.Append("','");
sb.Append(group.PasswordString);
sb.Append("','");
sb.Append(lfc.ConvertToString(group.Font));
sb.Append("','");
sb.Append(drcc.ConvertToString(null, PNStatic.CultureInvariant, group.FontColor));
sb.Append("', ");
sb.Append(Convert.ToInt32(group.IsDefaultImage));
sb.Append("); ");
if (ExecuteTransactionForStringBuilder(sb, ConnectionString))
{
sb = new StringBuilder();
var id = HK_START;
using (var oData = new SQLiteDataObject(ConnectionString))
{
var o = oData.GetScalar("SELECT MAX(ID) FROM HOT_KEYS");
if (o != null && !DBNull.Value.Equals(o))
{
id = (int)(long)o + 1;
}
}
var prefix = group.ID + "_show";
sb.Append("INSERT INTO HOT_KEYS (HK_TYPE, MENU_NAME, ID, SHORTCUT) VALUES(");
sb.Append(((int)HotkeyType.Group).ToString(PNStatic.CultureInvariant));
sb.Append(",'");
sb.Append(prefix);
sb.Append("',");
sb.Append(id.ToString(PNStatic.CultureInvariant));
sb.Append(",'');");
if (ExecuteTransactionForStringBuilder(sb, ConnectionString))
{
PNStatic.HotKeysGroups.Add(new PNHotKey { MenuName = prefix, ID = id, Type = HotkeyType.Group });
}
sb = new StringBuilder();
id++;
prefix = group.ID + "_hide";
sb.Append("INSERT INTO HOT_KEYS (HK_TYPE, MENU_NAME, ID, SHORTCUT) VALUES(");
sb.Append(((int)HotkeyType.Group).ToString(PNStatic.CultureInvariant));
sb.Append(",'");
sb.Append(prefix);
sb.Append("',");
sb.Append(id.ToString(PNStatic.CultureInvariant));
sb.Append(",'');");
if (ExecuteTransactionForStringBuilder(sb, ConnectionString))
{
PNStatic.HotKeysGroups.Add(new PNHotKey { MenuName = prefix, ID = id, Type = HotkeyType.Group });
}
}
}
catch (Exception ex)
{
PNStatic.LogException(ex);
}
}
internal static void SaveGeneralSettings()
{
try
{
var sb = new StringBuilder();
var cc = new System.Drawing.ColorConverter();
var pngeneral = PNStatic.Settings.GeneralSettings;
sb.Append("UPDATE GENERAL_SETTINGS SET ");
sb.Append("LANGUAGE = '");
sb.Append(pngeneral.Language);
sb.Append("', RUN_ON_START = ");
sb.Append(Convert.ToInt32(pngeneral.RunOnStart));
sb.Append(", SHOW_CP_ON_START = ");
sb.Append(Convert.ToInt32(pngeneral.ShowCPOnStart));
sb.Append(", CHECK_NEW_VERSION_ON_START = ");
sb.Append(Convert.ToInt32(pngeneral.CheckNewVersionOnStart));
sb.Append(", HIDE_TOOLBAR = ");
sb.Append(Convert.ToInt32(pngeneral.HideToolbar));
sb.Append(", USE_CUSTOM_FONTS = ");
sb.Append(Convert.ToInt32(pngeneral.UseCustomFonts));
sb.Append(", SHOW_SCROLLBAR = ");
sb.Append(Convert.ToInt32(pngeneral.ShowScrollbar));
sb.Append(", HIDE_DELETE_BUTTON = ");
sb.Append(Convert.ToInt32(pngeneral.HideDeleteButton));
sb.Append(", CHANGE_HIDE_TO_DELETE = ");
sb.Append(Convert.ToInt32(pngeneral.ChangeHideToDelete));
sb.Append(", HIDE_HIDE_BUTTON = ");
sb.Append(Convert.ToInt32(pngeneral.HideHideButton));
sb.Append(", BULLETS_INDENT = ");
sb.Append(pngeneral.BulletsIndent);
sb.Append(", MARGIN_WIDTH = ");
sb.Append(pngeneral.MarginWidth);
sb.Append(", SAVE_ON_EXIT = ");
sb.Append(Convert.ToInt32(pngeneral.SaveOnExit));
sb.Append(", CONFIRM_SAVING = ");
sb.Append(Convert.ToInt32(pngeneral.ConfirmSaving));
sb.Append(", CONFIRM_BEFORE_DELETION = ");
sb.Append(Convert.ToInt32(pngeneral.ConfirmBeforeDeletion));
sb.Append(", SAVE_WITHOUT_CONFIRM_ON_HIDE = ");
sb.Append(Convert.ToInt32(pngeneral.SaveWithoutConfirmOnHide));
sb.Append(", WARN_ON_AUTOMATICAL_DELETE = ");
sb.Append(Convert.ToInt32(pngeneral.WarnOnAutomaticalDelete));
sb.Append(", AUTO_SAVE = ");
sb.Append(Convert.ToInt32(pngeneral.Autosave));
sb.Append(", AUTO_SAVE_PERIOD = ");
sb.Append(pngeneral.AutosavePeriod);
sb.Append(", REMOVE_FROM_BIN_PERIOD = ");
sb.Append(pngeneral.RemoveFromBinPeriod);
sb.Append(", DATE_FORMAT = '");
sb.Append(pngeneral.DateFormat.Replace("'", "''"));
sb.Append("', TIME_FORMAT = '");
sb.Append(pngeneral.TimeFormat.Replace("'", "''"));
sb.Append("', SKINLESS_WIDTH = ");
sb.Append(pngeneral.Width);
sb.Append(", SKINLESS_HEIGHT = ");
sb.Append(pngeneral.Height);
sb.Append(", SPELL_COLOR = '");
sb.Append(cc.ConvertToString(null, PNStatic.CultureInvariant, pngeneral.SpellColor));
sb.Append("', USE_SKINS = ");
sb.Append(Convert.ToInt32(pngeneral.UseSkins));
sb.Append(", DOCK_WIDTH = ");
sb.Append(pngeneral.DockWidth);
sb.Append(", DOCK_HEIGHT = ");
sb.Append(pngeneral.DockHeight);
sb.Append(", SHOW_PRIORITY_ON_START = ");
sb.Append(Convert.ToInt32(pngeneral.ShowPriorityOnStart));
sb.Append(", BUTTONS_SIZE = ");
sb.Append(Convert.ToInt32(pngeneral.ButtonsSize));
sb.Append(", AUTOMATIC_SMILIES = ");
sb.Append(Convert.ToInt32(pngeneral.AutomaticSmilies));
sb.Append(", SPACE_POINTS = ");
sb.Append(pngeneral.SpacePoints);
sb.Append(", RESTORE_AUTO = ");
sb.Append(Convert.ToInt32(pngeneral.RestoreAuto));
sb.Append(", PARAGRAPH_INDENT = ");
sb.Append(pngeneral.ParagraphIndent);
sb.Append(", AUTO_HEIGHT = ");
sb.Append(Convert.ToInt32(pngeneral.AutoHeight));
sb.Append(", CRITICAL_ON_START = ");
sb.Append(Convert.ToInt32(pngeneral.CheckCriticalOnStart));
sb.Append(", CRITICAL_PERIODICALLY = ");
sb.Append(Convert.ToInt32(pngeneral.CheckCriticalPeriodically));
sb.Append(", DELETE_SHORTCUTS_ON_EXIT = ");
sb.Append(Convert.ToInt32(pngeneral.DeleteShortcutsOnExit));
sb.Append(", RESTORE_SHORTCUTS_ON_START = ");
sb.Append(Convert.ToInt32(pngeneral.RestoreShortcutsOnStart));
sb.Append(", CLOSE_ON_SHORTCUT = ");
sb.Append(Convert.ToInt32(pngeneral.CloseOnShortcut));
ExecuteTransactionForStringBuilder(sb, SettingsConnectionString);
}
catch (Exception ex)
{
PNStatic.LogException(ex);
}
}
internal static void SaveGroupChanges(PNGroup group)
{
try
{
var c = new ColorConverter();
var dcc = new System.Drawing.ColorConverter();
var lfc = new LogFontConverter();
var wfc = new WPFFontConverter();
var sb = new StringBuilder();
sb.Append("UPDATE GROUPS SET GROUP_NAME = '");
sb.Append(group.Name.Replace("'", "''"));
sb.Append("', PARENT_ID = ");
sb.Append(group.ParentID);
sb.Append(", ICON = ");
if (group.Image != null)
{
sb.Append("'");
if (!group.IsDefaultImage)
{
var base64String = Convert.ToBase64String(group.Image.ToBytes());
sb.Append(base64String);
}
else
{
sb.Append(group.ImageName);
sb.Append(".png");
}
//using (var ms = new MemoryStream(1))
//{
// group.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
// ms.Position = 0;
// string base64String = Convert.ToBase64String(ms.ToArray());
// sb.Append(base64String);
//}
sb.Append("',");
}
else
{
sb.Append("NULL,");
}
sb.Append(" BACK_COLOR = '");
sb.Append(c.ConvertToString(null, PNStatic.CultureInvariant, group.Skinless.BackColor));
sb.Append("', CAPTION_FONT_COLOR = '");
sb.Append(c.ConvertToString(null, PNStatic.CultureInvariant, group.Skinless.CaptionColor));
sb.Append("', CAPTION_FONT = '");
sb.Append(wfc.ConvertToString(group.Skinless.CaptionFont));
sb.Append("', SKIN_NAME = '");
sb.Append(group.Skin.SkinName.Replace("'", "''"));
sb.Append("', FONT_COLOR = '");
sb.Append(dcc.ConvertToString(null, PNStatic.CultureInvariant, group.FontColor));
sb.Append("', FONT = '");
sb.Append(lfc.ConvertToString(group.Font));
sb.Append("', IS_DEFAULT_IMAGE = ");
sb.Append(Convert.ToInt32(group.IsDefaultImage));
sb.Append(" WHERE GROUP_ID = ");
sb.Append(group.ID);
ExecuteTransactionForStringBuilder(sb, ConnectionString);
}
catch (Exception ex)
{
PNStatic.LogException(ex);
}
}
