public void Update(bool IsDesktopCapture,bool IsPrimaryCamera) { Functions F = new Functions(); int LatestSessionId = this.SessionID; if(IsPrimaryCamera == true) { string sTSQL = "Update tblRecording SET IsPrimaryCamera = 0 WHERE SessionId = " + LatestSessionId; int TResults = F.ExecuteNonQuery(sTSQL); } if(IsDesktopCapture == true) { string sTSQL = "Update tblRecording SET IsDesktopCapture = 0 WHERE SessionId = " + LatestSessionId; int TResults = F.ExecuteNonQuery(sTSQL); } string sSQL = "UPDATE tblRecording SET IsDesktopCapture = " + Convert.ToInt32(IsDesktopCapture) + ", IsPrimaryCamera = " + Convert.ToInt32(IsPrimaryCamera) + " WHERE ID = " + mvarID; int results = F.ExecuteSqlCommand(sSQL); }
public void Update(long RecordingSize) { Functions F = new Functions(); string sSQL = "UPDATE tblRecording SET DiskSize = " + RecordingSize + " WHERE ID = " + mvarID; int results = F.ExecuteSqlCommand(sSQL); }
/// <summary> /// Assigns Recording to another a different Session /// </summary> /// <param name="SessionId"></param> /// <param name="DummyVariable"></param> public void Update(int SessionId, bool DummyVariable) { Functions F = new Functions(); string sSQL = "UPDATE tblRecording SET SessionId = '" + SessionId + "'" + " WHERE ID = " + mvarID; int results = F.ExecuteSqlCommand(sSQL); }
public void Update(int VideoStorageServerId, int StreamingEncoderId) { Functions F = new Functions(); string sSQL = "UPDATE tblRecording SET VideoStorageServerID = " + VideoStorageServerID + ", StreamingEncoderID = " + StreamingEncoderID + " WHERE ID = " + mvarID; int results = F.ExecuteSqlCommand(sSQL); }
public bool UpdatePermissions(OCL.User CurrentUser, bool IsSuperUser) { if(this.mvarIsPublicAccess) { return false; } Functions F = new Functions(); string sCommand = ""; if(CurrentUser.mvarIsSuperUser == true) { sCommand = "UPDATE tblUSER SET IsSuperUser = "******" WHERE ID = " + mvarID; } else { return false; } int orow = F.ExecuteSqlCommand(sCommand); if(orow == 0) return false; else return true; }
public void Update(string DisplayName) { Functions F = new Functions(); string sSQL = "UPDATE tblRecording SET DisplayName = '" + DisplayName + "'" + " WHERE ID = " + mvarID; int results = F.ExecuteSqlCommand(sSQL); }
public void Update(string ControlAddress, int ControlPort, string UploadAddress, bool IsUploadFTP, string StorageDirectory,int VideoStorageServerTypeId) { Functions F = new Functions(); string sSQL = "UPDATE tblVideoStorageServer SET ControlAddress = '" + ControlAddress.ToUpper() + "'" + ", ControlPort = " + ControlPort + ", UploadAddress = '" + UploadAddress.ToUpper() + "'" + ", IsUploadFTP = " + Convert.ToInt32(IsUploadFTP) + ", StorageDirectory = '" + StorageDirectory + "'" + ", TypeId = " + VideoStorageServerTypeId + " WHERE ID = " + mvarID; int results = F.ExecuteSqlCommand(sSQL); }
internal void SetIsMarkedForDeletion(bool IsMarkedForDeletion) { Functions F = new Functions(); int intBool = Convert.ToInt32(IsMarkedForDeletion); string sSQL = "UPDATE tblRecording SET IsMarkedForDeletion = " + intBool + " WHERE ID = " + mvarID; int results = F.ExecuteSqlCommand(sSQL); }
public void Update(string Description,string ControlAddress, int ControlPort, string StreamingAddress, int StreamPort, bool IsMulticast, bool HasControlableCamera, int MediaBufferServerID, int SceneID, string StreamingHeader) { Functions F = new Functions(); string sSQL = "UPDATE tblSource SET Description = '" + Description + "'" + ",ControlAddress = '" + ControlAddress.ToUpper() + "'" + ", ControlPort = " + ControlPort + ", StreamAddress = '" + StreamingAddress.ToUpper() + "'" + ", StreamPort = " + StreamPort + ", IsMulticast = " + Convert.ToInt32(IsMulticast) + ", HasControlableCamera = " + Convert.ToInt32(HasControlableCamera) + ", MediaBufferServerID = " + MediaBufferServerID + ", SceneID = " + SceneID + ", StreamingHeader = '" + StreamingHeader + "'" + " WHERE ID = " + mvarID; int results = F.ExecuteSqlCommand(sSQL); }
public void Update(string Description,int OwnerID,int PreviousSectionID) { Functions F = new Functions(); bool KeepUser = true; int[] UO = F.GetUnassignedObjects(); //Check to see if this is NoBody User if(mvarOwnerID == UO[0]) { OCL.Section PrevSect = F.GetSection(PreviousSectionID); foreach(OCL.User U in PrevSect.CurrentUsers) { if(U.ID == mvarOwnerID) { if(U.NextOwnedSections.Count == 1) { KeepUser = false; //The Nobody User only has this one //section attached to this branch it //is ok to remove him after reassign } } } } string sSQL = "UPDATE tblSection SET Name = '" + Description + "' , OwnerID = " + OwnerID + " WHERE ID = " + mvarID; int results = F.ExecuteSqlCommand(sSQL); int OldOwner = mvarOwnerID; if(OwnerID != mvarOwnerID) { try { sSQL = "SELECT * FROM tblUserSectionRel WHERE UserId = " + OwnerID + " AND " + "SectionId = " + PreviousSectionID; // "SectionId = " + mvarID; DataSet DS = F.ReturnDataSet(sSQL); DataTable DT = DS.Tables[0]; if(DT.Rows.Count == 0) { F.AddUser(OwnerID,PreviousSectionID); } if(!KeepUser) F.RemoveUser(OldOwner,PreviousSectionID); mvarOwnerID = OwnerID; } catch(Exception Err) { throw new ApplicationException(Err.Message,Err.InnerException); } } }
public void Update(string Address, int Port,int SceneID, bool IsOnSerialPort) { Functions F = new Functions("Jeremiah",13075); string sSQL = "UPDATE tblControl SET Address = '" + Address.ToUpper() + "'" + ", SceneID = " + SceneID + ", IsOnSerialPort = " + Convert.ToInt32(IsOnSerialPort) + ", Port = " + Port + " WHERE ID = " + mvarID; try { int results = F.ExecuteSqlCommand(sSQL); } catch(Exception Err) { string peekerror = Err.Message; } }
public void Update(string Name, string FileImage) { Functions F = new Functions(); string sSQL = "UPDATE tblPlayList SET FileImage = '" + FileImage + "'" + ", SET Name = '" + Name + "'" + " WHERE ID = " + mvarID; int results = F.ExecuteSqlCommand(sSQL); }
public void Update(string Address, int VideoStorageServerID, int Port) { Functions F = new Functions(); string sSQL = "UPDATE tblForwardingServer SET Address = '" + Address.ToUpper() + "'" + ", VideoStorageServerID = " + VideoStorageServerID + ", Port = " + Port + " WHERE ID = " + mvarID; int results = F.ExecuteSqlCommand(sSQL); }
public void Update(int LengthInSeconds) { Functions F = new Functions(); string sSQL = "UPDATE tblRecording SET PlayLength = " + LengthInSeconds + " WHERE ID = " + mvarID; int results = F.ExecuteSqlCommand(sSQL); }
public void Update(string Description,string DisplayName, int VideoStorageServerID, int StreamingEncoderID,string SessionId, bool IsMarkedForDeletion,bool IsReady, bool IsDesktopCapture, bool IsPrimaryCamera) { Functions F = new Functions(); int LatestSessionId = this.SessionID; if(IsPrimaryCamera == true) { string sTSQL = "Update tblRecording SET IsPrimaryCamera = 0 WHERE SessionId = " + LatestSessionId; int TResults = F.ExecuteNonQuery(sTSQL); } if(IsDesktopCapture == true) { string sTSQL2 = "Update tblRecording SET IsDesktopCapture = 0 WHERE SessionId = " + LatestSessionId; int TResults2 = F.ExecuteNonQuery(sTSQL2); } string sSQL = "UPDATE tblRecording SET Name = '" + Description + "'" + ", DisplayName = '" + DisplayName + "'" + ", VideoStorageServerID = " + VideoStorageServerID + ", StreamingEncoderID = " + StreamingEncoderID + ", SessionId = '" + SessionId + "'" + ", IsMarkedForDeletion = " + Convert.ToInt32(IsMarkedForDeletion) + ", IsReady = " + Convert.ToInt32(IsReady) + ", IsDesktopCapture = " + Convert.ToInt32(IsDesktopCapture) + ", IsPrimaryCamera = " + Convert.ToInt32(IsPrimaryCamera) + " WHERE ID = " + mvarID; int results = F.ExecuteSqlCommand(sSQL); }
public void Update(bool IsReady) { Functions F = new Functions(); string sSQL = "UPDATE tblRecording SET IsReady = " + Convert.ToInt32(IsReady) + " WHERE ID = " + mvarID; int results = F.ExecuteSqlCommand(sSQL); }
public void Update(string Description, string DisplayName, int VideoStorageServerID, int StreamingEncoderID,bool IsReady) { Functions F = new Functions(); string sSQL = "UPDATE tblRecording SET Name = '" + Description + "'" + ", DisplayName = '" + DisplayName + "'" + ", VideoStorageServerID = " + VideoStorageServerID + ", StreamingEncoderID = " + StreamingEncoderID + ", IsReady = " + Convert.ToInt32(IsReady) + " WHERE ID = " + mvarID; int results = F.ExecuteSqlCommand(sSQL); }
public void Update(string Address, int ForwardingServerID, string StorageDirectory, int Port) { Functions F = new Functions(); string sSQL = "UPDATE tblMediaBufferServer SET Address = '" + Address.ToUpper() + "'" + ", ForwardingServerID = " + ForwardingServerID + ", StorageDirectory = '" + StorageDirectory + "'" + ", Port = " + Port + " WHERE ID = " + mvarID; int results = F.ExecuteSqlCommand(sSQL); }
public bool SetSystemAdministratorAccess(OCL.User AccessingUser, bool IsSystemAdministrator) { if(AccessingUser.mvarIsSuperUser) { Functions F = new Functions(); string sCommand = "UPDATE tblUSER SET IsSuperUser = "******" WHERE ID = " + mvarID; int orow = F.ExecuteSqlCommand(sCommand); if(orow == 0) return false; else return true; } return false; }