// /// <summary> // /// Returns a SystemStructures object that can access to all system objects // /// </summary> // public SystemStructures SYSTEMSTRUCTURE // { // get // { // SystemStructures SS = new SystemStructures(); // if((HighestSectionType.PreviousSectionTypeID == -99)&&(SystemAdminAlreadyLoggedIn == false)) // SS.IsEnabled = true; // else // SS.IsEnabled = false; // return SS; // } // } internal void AcquireSystemLock() { string sSQL = "UPDATE tblSystem SET SysAdminConnected = 1, SysAdminConnectionTime = '" + DateTime.Now + "' , SysAdminLastUpdateTime = '" + DateTime.Now + "'"; if((SC == null)||(SC.State == ConnectionState.Closed)) { Functions F = new Functions(); //F.ShareOpenConnection(ref SC); string ConnS = F.GetConnectionString(); SC = new SqlConnection(ConnS); F.Dispose(); SC.Open(); } SqlCommand cm = new SqlCommand(sSQL,SC); cm.ExecuteNonQuery(); }
private void OysterTimer_Tick(object source,System.Timers.ElapsedEventArgs e) { try { string sSQL = "UPDATE tblSystem SET SysAdminLastUpdateTime = '" + System.DateTime.Now + "'"; if((SC == null)||(SC.State == ConnectionState.Closed)) { Functions F = new Functions(); //F.ShareOpenConnection(ref SC); string ConnS = F.GetConnectionString(); SC = new SqlConnection(ConnS); F.Dispose(); SC.Open(); } SqlCommand cm = new SqlCommand(sSQL,SC); int numrecs = cm.ExecuteNonQuery(); if(numrecs == 0) throw new ApplicationException("Error writing update to System variable!"); } catch(Exception Err) { throw new ApplicationException(Err.Message); } }
public void ReleaseResources() { try { if(OysterTimer.Enabled == true) { OysterTimer.Enabled = false; string sSQL = "UPDATE tblSystem SET SysAdminConnected = 0, SysAdminLastUpdateTime = '" + DateTime.Now + "'"; //if((SC == null)||(SC.State == ConnectionState.Closed)) //{ Functions F = new Functions(); //F.ShareOpenConnection(ref SC); string ConnS = F.GetConnectionString(); SC = new SqlConnection(ConnS); F.Dispose(); SC.Open(); //} SqlCommand cm = new SqlCommand(sSQL,SC); cm.ExecuteNonQuery(); SC.Dispose(); } } catch(Exception Err) { throw new ApplicationException(Err.Message); } }