public VideoStorageServerType GetVideoStorageServerType(int ID)
{
try
{
VideoStorageServerType X = null;
string sSQL = "Select * FROM tblVideoStorageServerType WHERE ID = " + ID;
DataTable DT = GetDataTable(sSQL);
if(DT.Rows.Count > 0)
{
X = new VideoStorageServerType();
DataRow r = DT.Rows[0];
int count = 0;
X.mvarDictionary = new OysterDictionary();
foreach(DataColumn c in DT.Columns)
{
string sKey = c.ColumnName;
object oValue = (object)r[count];
X.mvarDictionary.Add(sKey.ToUpper(),oValue);
count++;
}
X.mvarID = Convert.ToInt32((object)r[0]);
X.mvarDescription = Convert.ToString((object)r[1]);
X.mvarStreamHeader = Convert.ToString((object)r[2]);
X.mvarUsePort = Convert.ToBoolean((object)r[3]);
}
DT.Dispose();
return X;
}
catch(Exception Err)
{
throw new ApplicationException(Err.Message);
}
}
public void Add(VideoStorageServerType X)
{
List.Add(X);
}
public VideoStorageServerType GetVideoStorageServerType(char[] StreamHeader)
{
try
{
string sStreamHeader = StreamHeader.ToString();
VideoStorageServerType X = new VideoStorageServerType();
string sSQL = "Select * FROM tblVideoStorageServerType WHERE StreamHeader = '" + sStreamHeader + "'";
DataTable DT = GetDataTable(sSQL);
if(DT.Rows.Count > 0)
{
DataRow r = DT.Rows[0];
X.mvarID = Convert.ToInt32((object)r[0]);
X.mvarDescription = Convert.ToString((object)r[1]);
X.mvarStreamHeader = Convert.ToString((object)r[2]);
}
else
X = null;
DT.Dispose();
return X;
}
catch(Exception Err)
{
throw new ApplicationException(Err.Message);
}
}