本文整理汇总了C#中OCL.CanDeleteSession方法的典型用法代码示例。如果您正苦于以下问题:C# OCL.CanDeleteSession方法的具体用法?C# OCL.CanDeleteSession怎么用?C# OCL.CanDeleteSession使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类OCL
的用法示例。
在下文中一共展示了OCL.CanDeleteSession方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: DeleteSession
internal bool DeleteSession(OCL.User AccessingUser,OCL.RecordingSession RS)
{
if(!RS.CanDeleteSession(AccessingUser))
{
return false;
}
try
{
string sSQL = "SELECT tblAttachments.StoredName FROM tblAttachments left outer join tblNotes ON tblNotes.Id = tblAttachments.NoteId" +
" left outer join tblSession ON tblNotes.SessionId = tblSession.Id WHERE tblSession.Id = " + RS.ID;
DataSet DS = RF.GetDataSet(sSQL);
FTPTransfer FT = new FTPTransfer();
try
{
FT.ConnectToOysterServer(ServerAddress);
//FT.ConnectToOysterServer("ome-prototype");
}
catch(Exception Err)
{
throw new Exception(Err.Message);
}
if(DS.Tables[0].Rows.Count > 0)
{
foreach(DataRow r in DS.Tables[0].Rows)
{
FT.RemoveFile(Convert.ToString(r[0]));
}
}
sSQL = "DELETE FROM tblAttachments FROM tblSession,tblNotes WHERE tblNotes.SessionId = tblSession.Id " +
"AND tblAttachments.NoteId = tblNotes.Id AND tblSession.Id = " + RS.ID;
int numrecs = RF.ExecuteCommandNonQuery(sSQL);
//Remove Recordings
sSQL = "SELECT tblRecording.Name FROM tblRecording WHERE SessionId = " + RS.ID;
DS = RF.GetDataSet(sSQL);
if(DS.Tables[0].Rows.Count > 0)
{
foreach(DataRow r in DS.Tables[0].Rows)
{
FT.RemoveFile(Convert.ToString(r[0]));
}
}
//DELETE EVERYTHING!!!
sSQL = "DELETE FROM tblNotes WHERE tblNotes.SessionId = " + RS.mvarID +
"; DELETE FROM tblRecording WHERE tblRecording.SessionId = " + RS.mvarID +
"; DELETE FROM tblSession WHERE tblSession.Id = " + RS.mvarID;
numrecs = RF.ExecuteCommandNonQuery(sSQL);
if(numrecs > 0)
return true;
else
return false;
}
catch(Exception Err)
{
throw new Exception(Err.Message);
}
}