public void fillData()
{
try
{
SQLiteConnection conn = new SQLiteConnection("Data Source=" + AppDomain.CurrentDomain.BaseDirectory + "MyDatabase.db3;Version=3;");
conn.Open();
string sql = "SELECT * FROM config";
SQLiteCommand command = new SQLiteCommand(sql, conn);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
log = reader["logs"].ToString();
id = reader["event_ids"].ToString();
sender = reader["sender"].ToString();
alias = reader["alias"].ToString();
receiver = reader["receiver"].ToString();
receiverAlias = reader["receiver_alias"].ToString();
senderPassword = reader["password"].ToString();
subject = reader["subject"].ToString();
SMPTHost = reader["host"].ToString();
SMTPPort = Convert.ToInt32(reader["port"].ToString());
hours = Convert.ToInt32(reader["frequency"].ToString());
days = Convert.ToInt32(reader["days"].ToString());
SSL = Convert.ToBoolean(reader["ssl"].ToString());
}
conn.Close();
txt_log.Text = log;
txt_ids.Text = id;
txt_sender.Text = sender;
txt_sendAlias.Text = alias;
txt_receiver.Text = receiver;
txt_getAlias.Text = receiverAlias;
txt_password.Text = senderPassword;
txt_subject.Text = subject;
txt_host.Text = SMPTHost;
txt_port.Text = SMTPPort.ToString();
txt_hours.Value = hours;
txt_days.Value = days;
if (SSL == true)
{
useSSL.Checked = true;
noSSL.Checked = false;
}
else
{
noSSL.Checked = true;
useSSL.Checked = false;
}
}
catch (Exception er) { MessageBox.Show(er.ToString()); }
}
public string Info()
{
int i;
StringBuilder sb = new StringBuilder();
sb.AppendLine();
sb.Append("QualityPreference: ");
for (i = 0; i < QualityPreference.Length; i++)
{
sb.AppendFormat("{0} ", QualityPreference[i]);
}
sb.AppendLine();
sb.AppendFormat("{0}: {1}\n", "TrailerDownloadFolder", TrailerDownloadFolder.ToString());
sb.AppendFormat("{0}: {1}\n", "MetadataDownloadFolder", MetadataDownloadFolder.ToString());
sb.AppendFormat("{0}: {1}\n", "3DTrailerDownloadFolder", Trailer3DDownloadFolder.ToString());
sb.AppendFormat("{0}: {1}\n", "3DMetadataDownloadFolder", Metadata3DDownloadFolder.ToString());
sb.AppendFormat("{0}: {1}\n", "GrabPoster", GrabPoster.ToString());
sb.AppendFormat("{0}: {1}\n", "CreateFolder", CreateFolder.ToString());
sb.AppendFormat("{0}: {1}\n", "VerboseLogging", VerboseLogging.ToString());
sb.AppendFormat("{0}: {1}\n", "PhysicalLog", PhysicalLog.ToString());
sb.AppendFormat("{0}: {1}\n", "PauseWhenDone", PauseWhenDone.ToString());
sb.AppendFormat("{0}: {1}\n", "KeepFor", KeepFor.ToString());
sb.AppendFormat("{0}: {1}\n", "DeleteToRecycleBin", DeleteToRecycleBin.ToString());
sb.AppendFormat("{0}: {1}\n", "UseExclusions", UseExclusions.ToString());
sb.AppendFormat("{0}: {1}\n", "TrailersOnly", TrailersOnly.ToString());
sb.AppendFormat("{0}: {1}\n", "TrailersIdenticaltoTheatricalTrailers", TrailersIdenticaltoTheatricalTrailers.ToString());
sb.AppendFormat("{0}: {1}\n", "SkipTheatricalTrailers", SkipTheatricalTrailers.ToString());
sb.AppendFormat("{0}: {1}\n", "SkipTeaserTrailers", SkipTeaserTrailers.ToString());
sb.AppendFormat("{0}: {1}\n", "ConsiderTheatricalandNumberedTrailersasIdentical", ConsiderTheatricalandNumberedTrailersasIdentical.ToString());
sb.AppendFormat("{0}: {1}\n", "DownloadSpecifiedGenresOnly", IncludeGenres.ToString());
sb.AppendFormat("{0}: {1}\n", "DownloadSpecifiedGenresOnly", ExcludeGenres.ToString());
sb.AppendFormat("{0}: {1}\n", "DownloadSpecifiedLanguagesOnly", IncludeLanguages.ToString());
sb.AppendFormat("{0}: {1}\n", "MinTrailerSize", MinTrailerSize.ToString());
sb.AppendFormat("{0}: {1}\n", "AddDates", AddDates.ToString());
if ((UserAgentId == null) || (UserAgentId.Length == 0))
{
sb.AppendLine("No UserAgentId defined");
}
else
{
for (i = 0; i < UserAgentId.Length; i++)
{
sb.AppendFormat("UserAgendId({0}): {1}\n", i + 1, UserAgentId[i]);
}
}
if ((UserAgentString == null) || (UserAgentString.Length == 0))
{
sb.AppendLine("No UserAgentString defined");
}
else
{
for (i = 0; i < UserAgentString.Length; i++)
{
sb.AppendFormat("UserAgentString({0}): {1}\n", i + 1, UserAgentString[i]);
}
}
sb.AppendFormat("{0}: {1}\n", "FeedAddress", FeedAddress.ToString());
sb.AppendFormat("{0}: {1}\n", "YouTubePlayList", YouTubePlayList.ToString());
sb.AppendFormat("{0}: {1}\n", "EmailAddress", EmailAddress.ToString());
sb.AppendFormat("{0}: {1}\n", "EmailSummary", EmailSummary.ToString());
sb.AppendFormat("{0}: {1}\n", "SMTPServer", SMTPServer.ToString());
sb.AppendFormat("{0}: {1}\n", "SMTPPort", SMTPPort.ToString());
sb.AppendFormat("{0}: {1}\n", "UseDefaultCredentials", UseDefaultCredentials.ToString());
if (!UseDefaultCredentials)
{
sb.AppendFormat("{0}: {1}\n", "SMTPUsername", "*********");
sb.AppendFormat("{0}: {1}\n", "SMTPPassword", "*********");
}
sb.AppendFormat("{0}: {1}\n", "SMTPEnableSsl", SMTPEnableSsl.ToString());
sb.AppendFormat("{0}: {1}\n", "EmailReturnAddress", EmailReturnAddress.ToString());
sb.AppendFormat("{0}: {1}\n", "EmailReturnDisplayName", EmailReturnDisplayName.ToString());
return(sb.ToString());
}
protected virtual void SaveGatewaySettings(SchemaSettings settings)
{
settings.SetValue(moleQule.Library.Properties.Settings.Default.SETTING_NAME_SMTP_ENABLE_SSL, SMTPEnableSSL.ToString());
settings.SetValue(moleQule.Library.Properties.Settings.Default.SETTING_NAME_SMTP_EMAIL, SMTPEmail);
settings.SetValue(moleQule.Library.Properties.Settings.Default.SETTING_NAME_SMTP_HOST, SMTPHost);
settings.SetValue(moleQule.Library.Properties.Settings.Default.SETTING_NAME_SMTP_PORT, SMTPPort.ToString());
settings.SetValue(moleQule.Library.Properties.Settings.Default.SETTING_NAME_SMTP_USER, SMTPUser);
settings.SetValue(moleQule.Library.Properties.Settings.Default.SETTING_NAME_SMTP_PWD, SMTPPwd);
settings.SetValue(moleQule.Library.Properties.Settings.Default.SETTING_NAME_SMS_GATEWAY_ACCOUNT, SMSGatewayAccount);
settings.SetValue(moleQule.Library.Properties.Settings.Default.SETTING_NAME_SMS_GATEWAY_CODE, SMSGatewayCode.ToString());
settings.SetValue(moleQule.Library.Properties.Settings.Default.SETTING_NAME_SMS_GATEWAY_NAME, SMSGatewayName);
settings.SetValue(moleQule.Library.Properties.Settings.Default.SETTING_NAME_SMS_GATEWAY_PWD, SMSGatewayPwd);
settings.SetValue(moleQule.Library.Properties.Settings.Default.SETTING_NAME_SMS_GATEWAY_USER, SMSGatewayUser);
}