public void Add(Recording X)
{
List.Add(X);
}
public Recording GetRecording(int ID)
{
try
{
Recording X = null;
string sSQL = "Select * FROM tblRecording WHERE ID = " + ID;
DataTable DT = GetDataTable(sSQL);
if(DT.Rows.Count > 0)
{
X = new Recording();
DataRow r = DT.Rows[0];
X.mvarID = Convert.ToInt32((object)r[0]);
X.mvarDescription = Convert.ToString((object)r[1]);
X.mvarOwnerID = Convert.ToInt32((object)r[2]);
X.mvarCreatedDate = Convert.ToDateTime((object)r[3]);
X.mvarUniqueIdentifier = r[4].ToString();
X.mvarVideoStorageServerID = Convert.ToInt32((object)r[5]);
X.mvarDisplayName = Convert.ToString((object)r[6]);
X.mvarStreamingEncoderID = Convert.ToInt32((object)r[7]);
X.mvarSessionID = Convert.ToString((object)r[8]);
X.mvarSessionName = Convert.ToString((object)r[9]);
X.mvarIsMarkedForDeletion = Convert.ToBoolean((object)r[10]);
X.mvarIsReady = Convert.ToBoolean((object)r[11]);
X.mvarDiskSize = Convert.ToInt64((object)r[12]);
X.mvarPlayLength = Convert.ToInt64((object)r[13]);
X.mvarHasAudio = Convert.ToBoolean((object)r[14]);
X.mvarHasVideo = Convert.ToBoolean((object)r[15]);
}
DT.Dispose();
return X;
}
catch(Exception Err)
{
throw new ApplicationException(Err.Message);
}
}
public Recording GetRecordingByDescription(string RecordingName)
{
try
{
Recording X = null;
string sSQL = "Select * FROM tblRecording WHERE Name = '" + RecordingName + "'";
DataTable DT = GetDataTable(sSQL);
if(DT.Rows.Count > 0)
{
X = new Recording();
DataRow r = DT.Rows[0];
X.mvarID = Convert.ToInt32((object)r[0]);
X.mvarDescription = Convert.ToString((object)r[1]);
X.mvarOwnerID = Convert.ToInt32((object)r[2]);
X.mvarCreatedDate = Convert.ToDateTime((object)r[3]);
X.mvarUniqueIdentifier = r[4].ToString();
X.mvarVideoStorageServerID = Convert.ToInt32((object)r[5]);
X.mvarDisplayName = Convert.ToString((object)r[6]);
X.mvarStreamingEncoderID = Convert.ToInt32((object)r[7]);
X.mvarSessionID = Convert.ToString((object)r[8]);
X.mvarSessionName = Convert.ToString((object)r[9]);
X.mvarIsReady = Convert.ToBoolean((object)r[10]);
}
DT.Dispose();
return X;
}
catch(Exception Err)
{
throw new ApplicationException(Err.Message);
}
}
public Recording FillRecording(DataRow r)
{
Recording X = new Recording();
X.mvarID = Convert.ToInt32((object)r[0]);
X.mvarDescription = Convert.ToString((object)r[1]);
X.mvarOwnerID = Convert.ToInt32((object)r[2]);
X.mvarCreatedDate = Convert.ToDateTime((object)r[3]);
X.mvarUniqueIdentifier = r[4].ToString();
X.mvarVideoStorageServerID = Convert.ToInt32((object)r[5]);
X.mvarDisplayName = Convert.ToString((object)r[6]);
X.mvarStreamingEncoderID = Convert.ToInt32((object)r[7]);
X.mvarSessionID = Convert.ToString((object)r[8]);
X.mvarSessionName = Convert.ToString((object)r[9]);
X.mvarIsMarkedForDeletion = Convert.ToBoolean((object)r[10]);
X.mvarIsReady = Convert.ToBoolean((object)r[11]);
X.mvarDiskSize = Convert.ToInt64((object)r[12]);
X.mvarPlayLength = Convert.ToInt64((object)r[13]);
X.mvarHasAudio = Convert.ToBoolean((object)r[14]);
X.mvarHasVideo = Convert.ToBoolean((object)r[15]);
return X;
}
