/// <summary>
/// Update ILC settings
/// </summary>
/// <param name="data">IlcSettingsData object</param>
/// <param name="user">principal object interface</param>
public static void UpdateIlcSettings(IlcSettingsData data, IPrincipal user)
{
using (DbConnection connection = GetConnection(user))
{
using (DbCommand cmd = connection.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText =
"UPDATE " + schemaName + ".ILC_INSTANCE SET " +
"SCHEDULE_CRON=:PARAM_SCHEDULE_CRON, OUT_CHANNEL_NUM=:PARAM_OUT_CHANNEL_NUM," +
"TIMESPAN=:PARAM_TIMESPAN, COMMON_RECIPIENT_EMAIL=:PARAM_COMMON_RECIPIENT_EMAIL, TIME_BETWEEN_VERIFICATION=:PARAM_TIME_BETWEEN_VERIF," +
"MAX_ATTEMPTS=:PARAM_MAX_ATTEMPTS, FROM_EMAIL=:PARAM_FROM_EMAIL," +
"SUMMARY_REPORT_CRON=:PARAM_SUMMARY_REPORT_CRON,SUMMARY_RECIPIENT_EMAIL=:PARAM_SUMMARY_RECIPIENT_EMAIL," +
"JOB_MISFIRE_THRESHOLD=:PARAM_JOB_MISFIRE_THRESHOLD, VERSION=VERSION+1";
AddInputParameter(cmd, "PARAM_SCHEDULE_CRON", data.scheduleCron);
AddInputParameter(cmd, "PARAM_OUT_CHANNEL_NUM", data.outgoingChannels);
AddInputParameter(cmd, "PARAM_TIMESPAN", data.timeSpan);
AddInputParameter(cmd, "PARAM_COMMON_RECIPIENT_EMAIL", data.commonRecipientEmailAddresses);
AddInputParameter(cmd, "PARAM_TIME_BETWEEN_VERIF", data.timeSpanBetweenVerifications);
AddInputParameter(cmd, "PARAM_MAX_ATTEMPTS", data.attemptsMaxNumber);
AddInputParameter(cmd, "PARAM_FROM_EMAIL", data.emailFromAddress);
AddInputParameter(cmd, "PARAM_SUMMARY_REPORT_CRON", data.summaryReportCron);
AddInputParameter(cmd, "PARAM_SUMMARY_RECIPIENT_EMAIL", data.summaryRecipientEmail);
AddInputParameter(cmd, "PARAM_JOB_MISFIRE_THRESHOLD", data.jobMisfireThreshold);
cmd.ExecuteNonQuery();
}
}
}
private void GetIlcSettingsData()
{
IlcSettingsData data = IlcWebDao.GetIlcSettingsData();
scheduleCron.Text = data.scheduleCron;
outgoingChanels.Text = data.outgoingChannels;
timeSpan.Text = data.timeSpan;
commonEmail.Text = data.commonRecipientEmailAddresses;
timeBetweenVerifications.Text = data.timeSpanBetweenVerifications;
maxAttempts.Text = data.attemptsMaxNumber;
fromEmail.Text = data.emailFromAddress;
summaryReportCron.Text = data.summaryReportCron;
summaryEmail.Text = data.summaryRecipientEmail;
jobMisfireThreshold.Text = data.jobMisfireThreshold;
}
protected void SaveButton_Click(object sender, EventArgs e)
{
if (!IsValid)
{
return;
}
IlcSettingsData data = new IlcSettingsData();
data.scheduleCron = scheduleCron.Text;
data.outgoingChannels = outgoingChanels.Text = outgoingChanels.Text.Trim();
data.timeSpan = timeSpan.Text = timeSpan.Text.Trim();
data.commonRecipientEmailAddresses = commonEmail.Text = commonEmail.Text;
data.timeSpanBetweenVerifications = timeBetweenVerifications.Text = timeBetweenVerifications.Text.Trim();
data.attemptsMaxNumber = maxAttempts.Text = maxAttempts.Text.Trim();
data.emailFromAddress = fromEmail.Text;
data.summaryReportCron = summaryReportCron.Text = summaryReportCron.Text.Trim();
data.summaryRecipientEmail = summaryEmail.Text;
data.jobMisfireThreshold = jobMisfireThreshold.Text = jobMisfireThreshold.Text.Trim();
IlcWebDao.UpdateIlcSettings(data, User);
}
/// <summary>
/// Gets ILC settings data
/// </summary>
/// <returns>IlcSettingsData object</returns>
public static IlcSettingsData GetIlcSettingsData()
{
IlcSettingsData data = new IlcSettingsData();
using (DbConnection connection = new OracleConnection(WebSettings.GetConnectionString()))
{
connection.Open();
using (DbCommand cmd = connection.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText =
"SELECT SCHEDULE_CRON,OUT_CHANNEL_NUM, TIMESPAN,COMMON_RECIPIENT_EMAIL," +
"TIME_BETWEEN_VERIFICATION, MAX_ATTEMPTS, FROM_EMAIL," +
"SUMMARY_REPORT_CRON,SUMMARY_RECIPIENT_EMAIL, JOB_MISFIRE_THRESHOLD FROM " +
schemaName + ".ILC_INSTANCE";
using (DbDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
data.scheduleCron = Convert.ToString(reader[0]);
data.outgoingChannels = Convert.ToString(reader[1]);
data.timeSpan = Convert.ToString(reader[2]);
data.commonRecipientEmailAddresses = Convert.ToString(reader[3]);
data.timeSpanBetweenVerifications = Convert.ToString(reader[4]);
data.attemptsMaxNumber = Convert.ToString(reader[5]);
data.emailFromAddress = Convert.ToString(reader[6]);
data.summaryReportCron = Convert.ToString(reader[7]);
data.summaryRecipientEmail = Convert.ToString(reader[8]);
data.jobMisfireThreshold = Convert.ToString(reader[9]);
}
}
}
}
return(data);
}
