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