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); }
/// <summary> /// Updates the Database with the current reported file size on disk /// </summary> /// <returns>File size in bytes</returns> public long RefreshFileSizeOnDisk() { Functions F = new Functions(); long FileSize = F.GetActualFileSizeOnDisk(this.StoredName); string sSQL = "Update tblAttachments SET FileSize = " + FileSize.ToString() + "WHERE Id = " + mvarID; F.ExecuteNonQuery(sSQL); return FileSize; }
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 bool Update(OCL.User AccessingUser,string Description,string Format,bool UseStreamAddress,bool UseStreamPort, bool UseStreamHeader, bool UseConstant1, bool UseConstant2, bool UseConstant3, bool UseConstant4, string Constant1, string Constant2, string Constant3, string Constant4) { if(!AccessingUser.mvarIsSuperUser) { return false; } string sSQL = "UPDATE tblSourceType SET Description = '"+ Description + "'" + ", Format = '" + Format + "'" + ", UseStreamAddress = " + Convert.ToInt32(UseStreamAddress) + ", UseStreamPort = " + Convert.ToInt32(UseStreamPort) + ", UseStreamHeader = " + Convert.ToInt32(UseStreamHeader) + ", UseConstant1 = " + Convert.ToInt32(UseConstant1) + ", UseConstant2 = " + Convert.ToInt32(UseConstant2) + ", UseConstant3 = " + Convert.ToInt32(UseConstant3) + ", UseConstant4 = " + Convert.ToInt32(UseConstant4) + ", Constant1 = '" + Constant1 + "'" + ", Constant2 = '" + Constant2 + "'" + ", Constant3 = '" + Constant3 + "'" + ", Constant4 = '" + Constant4 + "'" + " WHERE ID = " + this.mvarID; OCL.Functions F = new Functions(); int NumRecs = F.ExecuteNonQuery(sSQL); if(NumRecs > 0) return true; else return false; }