public Int32 GetIntervalinSeconds(QuartzParam quartzParam)
{
try
{
return(ConvertDaytoSeconds(quartzParam.IntervalDay) + ConvertHourtoSeconds(quartzParam.IntervalHour) +
ConvertMinutestoSeconds(quartzParam.IntervalMinute) + quartzParam.IntervalSecond);
}
catch (Exception ex)
{
logger.Error("GetInterval Function");
logger.Error(ex.Message);
throw;
}
}
public QuartzParam getQuartzParam()
{
try
{
this.ConnectSQLServer();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conSql;
cmd.CommandText = "SELECT [SCHID] " +
",[SCHSDESC] " +
",[SCHLDESC] " +
",[SCHINTSEC] " +
",[SCHINTMIN] " +
",[SCHINTHOR] " +
",[SCHINTDAY] " +
",[SCHSTRTHOR] " +
",[SCHSTRTMIN] " +
",[SCHISDLY] " +
",[SCHISMTH] " +
",[SCHISWKY] " +
",[SCHDAYWK] " +
",[SCHDAYMTH] " +
"FROM [MSTSCH] " +
"where SCHSDESC = 'Idle Email'";
cmd.CommandType = CommandType.Text;
logger.Debug(cmd.CommandText);
SqlDataReader dr = cmd.ExecuteReader();
quartzParam = new QuartzParam();
while (dr.Read())
{
logger.Debug(dr["SCHID"].ToString() + " " + dr["SCHSDESC"].ToString() + " " + dr["SCHLDESC"].ToString() + " " +
dr["SCHINTSEC"].ToString() + " " + dr["SCHINTMIN"].ToString() + " " + dr["SCHINTHOR"].ToString() + " " +
dr["SCHINTDAY"].ToString() + " " + dr["SCHSTRTHOR"].ToString() + " " + dr["SCHSTRTMIN"].ToString() + " " +
dr["SCHISDLY"].ToString() + " " + dr["SCHISMTH"].ToString() + " " + dr["SCHISWKY"].ToString() + " " +
dr["SCHDAYWK"].ToString() + " " + dr["SCHDAYMTH"].ToString());
quartzParam.ID = int.Parse(dr["SCHID"].ToString());
logger.Debug("Masuk ID");
quartzParam.ShortDesc = dr["SCHSDESC"].ToString();
logger.Debug("Masuk Short Desc");
quartzParam.LongDesc = dr["SCHLDESC"].ToString();
logger.Debug("Masuk Long Desc");
quartzParam.IntervalSecond = int.Parse(dr["SCHINTSEC"].ToString());
logger.Debug("Masuk Interval Secong");
quartzParam.IntervalMinute = int.Parse(dr["SCHINTMIN"].ToString());
logger.Debug("Masuk Interval Minute");
quartzParam.IntervalHour = int.Parse(dr["SCHINTHOR"].ToString());
logger.Debug("Masuk Intervcal Hour");
quartzParam.IntervalDay = int.Parse(dr["SCHINTDAY"].ToString());
logger.Debug("Masuk Interval Day");
quartzParam.StartHour = int.Parse(dr["SCHSTRTHOR"].ToString());
logger.Debug("Masuk Start Hour");
quartzParam.StartMinute = int.Parse(dr["SCHSTRTMIN"].ToString());
logger.Debug("Masuk Start Min");
quartzParam.IsDaily = bool.Parse(dr["SCHISDLY"].ToString());
logger.Debug("Masuk Is Daily");
quartzParam.IsMonthly = bool.Parse(dr["SCHISMTH"].ToString());
logger.Debug("Masuk Is Monthly");
quartzParam.IsWeekly = bool.Parse(dr["SCHISWKY"].ToString());
logger.Debug("Masuk Is Weekly");
quartzParam.DayOfWeek = dr["SCHDAYWK"].ToString();
logger.Debug("Masuk Day of Week");
quartzParam.DayOfMonth = int.Parse(dr["SCHDAYMTH"].ToString());
logger.Debug("Masuk Day of Month");
}
return(quartzParam);
}
catch (Exception ex)
{
logger.Error("getQuartzParam function");
logger.Error(ex.Message);
logger.Error("Error getting GetIntervalDay Value, returning 0 as default");
return(null);
}
}
