static private void LoadStartUpJob(T1.Shared.Classes.ObjectCron objCron)
{
try
{
IJobDetail _Job = JobBuilder.Create <StartUpJob>()
.WithIdentity(objCron.JobId, objCron.GroupId)
.Build();
ITrigger _Trigger = TriggerBuilder.Create()
.WithIdentity(objCron.TriggerId, objCron.GroupId)
.StartNow()
.WithCronSchedule(objCron.Cron)
.Build();
if (!T1.Cron.isJobRegistered(_Job.Key))
{
T1.Cron.addJob(_Job, _Trigger);
_Logger.Debug("B1Connection cron job added. Refreshing based on cron string " + objCron.Cron);
}
else
{
_Logger.Debug("Job Already created. Ignoring creation");
}
}
catch (Exception er)
{
_Logger.Fatal("", er);
}
}
public static bool upsertObjectCron(T1.Shared.Classes.ObjectCron objCron, DateTime oDate, string Key, string DateTimeColumn, string KeyColumn)
{
bool blResult = false;
DataTable objDT = null;
OdbcDataAdapter objAdapter = null;
DataRow objRow = null;
string strSql = "";
try
{
if (_Instance == null)
{
_Instance = new Instance();
}
if (objConnection == null)
{
getConnection();
}
if (objConnection != null && objConnection.State == ConnectionState.Open)
{
strSql = Settings._SQL.getObjectControlQuery.Replace("[--ObjectCronId--]", objCron.Id.ToString());
objAdapter = new OdbcDataAdapter(strSql, objConnection);
objAdapter.Fill(objDT);
if (objDT.Rows.Count > 0)
{
objDT.Rows[0][KeyColumn] = Key;
objDT.Rows[0][DateTimeColumn] = oDate;
}
else
{
objRow = objDT.NewRow();
objRow["OBJECTCRONID"] = objCron.Id;
objRow[KeyColumn] = Key;
objRow[DateTimeColumn] = oDate;
objDT.Rows.Add(objRow);
}
objAdapter.Update(objDT);
blResult = true;
}
}
catch (Exception er)
{
_Logger.Error("", er);
}
return(blResult);
}