public void setSynchronizationParameters(ref bool?isSynchronizationEnabled, ref int?periodicityInMinutes)
{
SqlConnection conn = null;
SqlCommand cmd = null;
try {
conn = new SqlConnection(CommonMethods.getConnectionString(ConfigurationManager.AppSettings["SROCalendarProvider"]));
conn.Open();
cmd = new SqlCommand("SRSSynchronizationControlGetAndSet", conn);
cmd.CommandType = CommandType.StoredProcedure;
if (isSynchronizationEnabled.HasValue)
{
cmd.Parameters.Add("@IsSynchronizationActive", SqlDbType.Bit).Value = isSynchronizationEnabled.Value;
}
if (periodicityInMinutes.HasValue)
{
cmd.Parameters.Add("@SynchronizationPeriodicityInMinutes", SqlDbType.Int).Value = periodicityInMinutes.Value;
}
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
if (CommonRoutines.HasData(ds))
{
periodicityInMinutes = CommonRoutines.ObjectToInt(ds.Tables[0].Rows[0]["SynchronizationPeriodicityInMinutes"]);
isSynchronizationEnabled = CommonRoutines.ObjectToBool(ds.Tables[0].Rows[0]["IsSynchronizationActive"]);
}
} catch (Exception e) {
} finally {
try { cmd.Dispose(); } catch { }
try { conn.Close(); } catch { }
}
}
public void getSynchronizationParameters(
out bool isSynchronizationEnabled,
out int periodicityInMinutes)
{
periodicityInMinutes = 60;
isSynchronizationEnabled = true;
SqlConnection conn = null;
SqlCommand cmd = null;
try {
conn = new SqlConnection(CommonMethods.getConnectionString(ConfigurationManager.AppSettings["SROCalendarProvider"]));
conn.Open();
cmd = new SqlCommand("SRSSynchronizationControlGetAndSet", conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
if (CommonRoutines.HasData(ds))
{
periodicityInMinutes = CommonRoutines.ObjectToInt(ds.Tables[0].Rows[0]["SynchronizationPeriodicityInMinutes"]);
isSynchronizationEnabled = CommonRoutines.ObjectToBool(ds.Tables[0].Rows[0]["IsSynchronizationActive"]);
}
} catch (Exception e) {
} finally {
try { cmd.Dispose(); } catch { }
try { conn.Close(); } catch { }
}
}
/// <summary>
///
/// </summary>
/// <param name="sessionId">If comming from a web app, pass its SessionId string value,
/// otherwise, pass in any value.</param>
/// <param name="source">Either the web app or the windows service</param>
public Scheduler(string sessionId, string source)
{
mSessionId = sessionId;
mSource = source;
mDBController = new DBController(mSessionId);
mWriteLogEntries =
CommonRoutines.ObjectToBool(ConfigurationManager.AppSettings["WriteLogEntries"]);
}
public static DbParameter buildBooleanParm(string parmName, object value, ParameterDirection parmDirection)
{
return(buildBooleanParm(parmName,
value is DBNull ? NULL_INT : (CommonRoutines.ObjectToBool(value)?1:0),
parmDirection));
}
