public Section CurrentSystemSection(string OysterPassword) { if(OysterPassword == "6419DC43-84B9-43e2-89FE-BB8C96D5CF6F") { Functions F = new Functions(); Section X = F.GetSystemSection(); return X; } else return null; }
// public void ReleaseCameras() // { // // if(NeedToRelinqueshControl == true) // { // try // { // NeedToRelinqueshControl = false; // UserTimer.Enabled = false; // //Functions F = new Functions(); // Functions F = new Functions(); // F.ForceEncoderFree(CurrentControlledEncoder); //// if(SC.State == ConnectionState.Closed) //// { //// //// //SC.Open(); //// //// // F.ShareOpenConnection(ref SC); //// //// } // // // // string sSQL = "DELETE FROM tblUserStreamingEncoderRel WHERE StreamingEncoderId = " + CurrentControlledEncoder; // //SqlCommand cm = new SqlCommand(sSQL,SC); // // int numrecs = cm.ExecuteNonQuery(); // // // //SC.Close(); // } // catch(Exception Err) // { // string peekerrror = Err.Message; // } // } // } // public void UserTimer_Tick(object sender, ElapsedEventArgs e) // { // if(ControllingCamera == true) // { // if(SC == null) // { // Functions F = new Functions(); // // F.ShareOpenConnection(ref SC); // // } // string sSQL = "UPDATE tblUserStreamingEncoderRel SET LastUpdatedTime = '" + System.DateTime.Now + // "' WHERE StreamingEncoderId = " + CurrentControlledEncoder + // " AND UserId = " + mvarID; // SqlCommand CM = new SqlCommand(sSQL,SC); // try // { // int numRecs = CM.ExecuteNonQuery(); // if(numRecs == 0) // throw new ApplicationException("ERROR: Failed to update system with new camera control time for SE.ID:" + CurrentControlledEncoder); // } // catch(Exception Err) // { // string peekerror = Err.Message; // throw new ApplicationException("ERROR: Failed to update system with new camera control time for SE.ID:" + CurrentControlledEncoder + " ERROR MESSAGE: " + Err.Message); // } // NeedToRelinqueshControl = true; // } // // } // public bool AquireCameraControl(int StreamingEncoderId) // { // Functions F = new Functions(); // // NeedToRelinqueshControl = false; // StreamingEncoder S = F.GetStreamingEncoder(StreamingEncoderId); // if(S == null) // return false; // if(S.HasControlableCamera == false) // return false; // // F.ShareOpenConnection(ref SC); // // // string sSQL = "SELECT * FROM tblUserStreamingEncoderRel WHERE StreamingEncoderId = " + StreamingEncoderId; // SqlDataAdapter da = new SqlDataAdapter(sSQL,SC); // DataTable dt = new DataTable(); // da.Fill(dt); // try // { // if(dt.Rows.Count > 0) //Then another User has control of it already // { // return false; // } // } // catch(Exception Err) // { // string peekerror = Err.Message; // } // // // //Enforce that this user will only control 1 camera at a time // sSQL = "DELETE FROM tblUserStreamingEncoderRel WHERE UserId = " + mvarID; // SqlCommand CM = new SqlCommand(sSQL,SC); // CM.ExecuteNonQuery(); // // sSQL = "Insert INTO tblUserStreamingEncoderRel(StreamingEncoderId, UserId, LastUpdatedTime) Values(" + // StreamingEncoderId + "," + mvarID + ",'" + System.DateTime.Now + "')"; // CM = new SqlCommand(sSQL,SC); // int numRecs = CM.ExecuteNonQuery(); // if(numRecs == 0) // { // CurrentControlledEncoder = 0; // ControllingCamera = false; // UserTimer.Enabled = false; // return false; // } // else // { // CurrentControlledEncoder = StreamingEncoderId; // UserTimer.Enabled = true; // ControllingCamera = true; // NeedToRelinqueshControl = true; // return true; // // } // } public bool Update(string FirstName, string MiddleName, string LastName, string LoginName, string Password, bool CanRecord, string CardNumber) { Functions F = new Functions(); FirstName = F.CheckSqlSafeString(FirstName); MiddleName = F.CheckSqlSafeString(MiddleName); LastName = F.CheckSqlSafeString(LastName); LoginName = F.CheckSqlSafeString(LoginName); Password = F.CheckSqlSafeString(Password); CardNumber = F.CheckSqlSafeString(CardNumber); string Description = LastName + ", " + FirstName + " " + MiddleName; int SysAdminID = ((Section)F.GetSystemSection()).OwnerID; if(mvarID == SysAdminID) Description = mvarDescription; // string sSQL = "SELECT * FROM tblUser WHERE ID = " + mvarID; // SqlDataAdapter DA = new SqlDataAdapter(sSQL,MC); string sCommand = "UPDATE tblUSER SET Name = '" + Description + "' , FirstName = '" + FirstName + "' , MiddleName = '" + MiddleName + "' , LastName = '" + LastName + "' , LoginName = '" + LoginName + "' , Password = '******' , CanRecord = " + Convert.ToInt32(CanRecord) + " , CardNumber = '" + CardNumber + "' WHERE ID = " + mvarID; int orow = F.ExecuteNonQuery(sCommand); F.Dispose(); if(orow == 0) return false; else return true; }