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