internal Recordings GetRecordingsBySessionId(int SessionId)
{
try
{
Recordings X = new Recordings();
string sSQL = "Select * FROM tblRecording WHERE SessionId = " + SessionId;
DataSet DS = RF.GetDataSet(sSQL);
foreach(DataRow R in DS.Tables[0].Rows)
{
Recording Rec = null;
Rec = FillRecording(R);
if(Rec != null)
X.Add(Rec);
}
return X;
}
catch(Exception Err)
{
throw new ApplicationException(Err.Message);
}
}
internal Recordings GetAllRecordingsMarkedForDeletion()
{
try
{
Recordings X = new Recordings();
string sSQL = "Select * FROM tblRecording WHERE IsMarkedForDeletion <> 0";
DataSet DS = RF.GetDataSet(sSQL);
foreach(DataRow r in DS.Tables[0].Rows)
{
//int RecordingId = Convert.ToInt32(r[0]);
Recording Rec = FillRecording(r);
X.Add(Rec);
}
if(X.Count == 0)
X = null;
return X;
}
catch(Exception Err)
{
throw new ApplicationException(Err.Message);
}
}