public VisualSettingsForm(TimerVisualSettings visualSettings, string settingsName = null)
{
InitializeComponent();
const string formName = "Visual Settings";
this.Text = string.IsNullOrEmpty(settingsName) ? Util.GetFormName(formName) : settingsName.Trim() + " - " + formName;
this.VisualSettings = visualSettings;
this.InitSettings();
}
private SimpleTimerSettings Parse(SQLiteDataReader reader)
{
if (reader[TimerSettingsModel.IdCol.Name] is DBNull)
{
return(null);
}
int id = Convert.ToInt32(reader[TimerSettingsModel.IdCol.Name]);
string name = Convert.ToString(reader[TimerSettingsModel.NameCol.Name]);
string finalMessage = Convert.ToString(reader[TimerSettingsModel.MessageCol.Name]);
bool blinkOnExpired = Convert.ToInt32(reader[TimerSettingsModel.BlinkCol.Name]) > 0;
TimerDurationSettings durationSettings = DurationSettingsModel.Parse(reader);
TimerVisualSettings visualSettings = VisualSettingsModel.Parse(reader);
return(new SimpleTimerSettings(id, name, finalMessage, blinkOnExpired, durationSettings, visualSettings, null));
}
public static TimerSequenceSettings ParseCsv(string csv)
{
TimerSequenceSettings settings = TimerSequenceSettings.Empty;
try
{
var values = csv.Split(new char[] { ',' });
int id = TimerSequenceSettings.count;
int.TryParse(values[0], out id);
settings.Id = id;
settings.Name = values[1];
settings.BlinkOnExpired = bool.Parse(values[2]);
settings.FinalMessage = values[3];
settings.VisualSettings = TimerVisualSettings.ParseCsv(csv, 5);
return(settings);
}
catch
{
return(settings);
}
}
public TimerVisualSettings Save(TimerVisualSettings timerVisual)
{
var parameters = new List <SQLiteParameter>
{
new SQLiteParameter()
{
ParameterName = TimerFontFamilyCol.ParameterName, Value = timerVisual.TimerFont.FontFamily
},
new SQLiteParameter()
{
ParameterName = TimerFontSizeCol.ParameterName, Value = timerVisual.TimerFont.Size
},
new SQLiteParameter()
{
ParameterName = CounterModeCol.ParameterName, Value = timerVisual.CounterMode
},
new SQLiteParameter()
{
ParameterName = DisplayModeCol.ParameterName, Value = timerVisual.DisplayMode
},
new SQLiteParameter()
{
ParameterName = TimerColorCol.ParameterName, Value = timerVisual.TimerColor.Name
},
new SQLiteParameter()
{
ParameterName = RunningColorCol.ParameterName, Value = timerVisual.RunningColor.Name
},
new SQLiteParameter()
{
ParameterName = PausedColorCol.ParameterName, Value = timerVisual.PausedColor.Name
},
new SQLiteParameter()
{
ParameterName = WarningColorCol.ParameterName, Value = timerVisual.WarningColor.Name
},
new SQLiteParameter()
{
ParameterName = SecondWarningColorCol.ParameterName, Value = timerVisual.SecondWarningColor.Name
},
new SQLiteParameter()
{
ParameterName = StoppedColorCol.ParameterName, Value = timerVisual.StoppedColor.Name
},
new SQLiteParameter()
{
ParameterName = ExpiredColorCol.ParameterName, Value = timerVisual.ExpiredColor.Name
},
new SQLiteParameter()
{
ParameterName = BackgroundColorCol.ParameterName, Value = timerVisual.BackgroundColor.Name
},
new SQLiteParameter()
{
ParameterName = MessageColorCol.ParameterName, Value = timerVisual.MessageColor.Name
},
};
if (timerVisual.VisualId < 0)
{
var sql = "INSERT INTO [" + TableName + "] (" +
"[" + TimerFontFamilyCol.Name + "], " +
"[" + TimerFontSizeCol.Name + "], " +
"[" + CounterModeCol.Name + "], " +
"[" + DisplayModeCol.Name + "], " +
"[" + TimerColorCol.Name + "], " +
"[" + RunningColorCol.Name + "], " +
"[" + PausedColorCol.Name + "], " +
"[" + WarningColorCol.Name + "], " +
"[" + SecondWarningColorCol.Name + "], " +
"[" + StoppedColorCol.Name + "], " +
"[" + ExpiredColorCol.Name + "], " +
"[" + BackgroundColorCol.Name + "], " +
"[" + MessageColorCol.Name + "]" +
") VALUES (" +
"@" + TimerFontFamilyCol.ParameterName + ", " +
"@" + TimerFontSizeCol.ParameterName + ", " +
"@" + CounterModeCol.ParameterName + ", " +
"@" + DisplayModeCol.ParameterName + ", " +
"@" + TimerColorCol.ParameterName + ", " +
"@" + RunningColorCol.ParameterName + ", " +
"@" + PausedColorCol.ParameterName + ", " +
"@" + WarningColorCol.ParameterName + ", " +
"@" + SecondWarningColorCol.ParameterName + ", " +
"@" + StoppedColorCol.ParameterName + ", " +
"@" + ExpiredColorCol.ParameterName + ", " +
"@" + BackgroundColorCol.ParameterName + ", " +
"@" + MessageColorCol.ParameterName + ");";
var newId = (int)this.Insert(sql, parameters.ToArray());
return(new TimerVisualSettings(newId, timerVisual));
}
var update = "UPDATE [" + TableName + "] SET " +
"[" + TimerFontFamilyCol.Name + "] = @" + TimerFontFamilyCol.ParameterName + "," +
"[" + TimerFontSizeCol.Name + "] = @" + TimerFontSizeCol.ParameterName + "," +
"[" + CounterModeCol.Name + "] = @" + CounterModeCol.ParameterName + "," +
"[" + DisplayModeCol.Name + "] = @" + DisplayModeCol.ParameterName + "," +
"[" + TimerColorCol.Name + "] = @" + TimerColorCol.ParameterName + "," +
"[" + RunningColorCol.Name + "] = @" + RunningColorCol.ParameterName + "," +
"[" + PausedColorCol.Name + "] = @" + PausedColorCol.ParameterName + "," +
"[" + WarningColorCol.Name + "] = @" + WarningColorCol.ParameterName + "," +
"[" + SecondWarningColorCol.Name + "] = @" + SecondWarningColorCol.ParameterName + "," +
"[" + StoppedColorCol.Name + "] = @" + StoppedColorCol.ParameterName + "," +
"[" + ExpiredColorCol.Name + "] = @" + ExpiredColorCol.ParameterName + "," +
"[" + BackgroundColorCol.Name + "] = @" + BackgroundColorCol.ParameterName + "," +
"[" + MessageColorCol.Name + "] = @" + MessageColorCol.ParameterName + " " +
"WHERE [" + IdCol.Name + "] = @" + IdCol.ParameterName + ";";
parameters.Add(new SQLiteParameter(IdCol.ParameterName, timerVisual.VisualId));
this.ExecuteNonQuery(update, parameters.ToArray());
return(timerVisual);
}
private void btnDefaultSettings_Click(object sender, EventArgs e)
{
this.VisualSettings = TimerVisualSettings.Default;
this.InitSettings();
}