public Dictionary <int, VideoInfo> GetVideoInfoByCamera(ref string errMessage, int cameraId)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
var videoList = new Dictionary <int, VideoInfo>();
try
{
DataSet ds = VideoDataAccess.GetVideoInfoByCamera(db, cameraId);
VideoInfo videoInfo;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
videoInfo = new VideoInfo(ds.Tables[0].Rows[i]);
DataSet dsCamera;
CameraInfo oCamera;
dsCamera = CameraDataAccess.GetCamInfoByCameraId(db, videoInfo.CameraId);
foreach (DataRow dr in dsCamera.Tables[0].Rows)
{
oCamera = new CameraInfo(dr);
videoInfo.CameraInfo = oCamera;
}
videoList.Add(videoInfo.Id, videoInfo);
}
return(videoList);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
public VideoInfo GetVideoInfoById(ref string errMessage, int id)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
DataSet ds = VideoDataAccess.GetVideoInfoById(db, id);
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
VideoInfo videoInfo = new VideoInfo(ds.Tables[0].Rows[0]);
DataSet dsCamera;
CameraInfo oCamera;
dsCamera = CameraDataAccess.GetCamInfoByCameraId(db, videoInfo.CameraId);
foreach (DataRow dr in dsCamera.Tables[0].Rows)
{
oCamera = new CameraInfo(dr);
videoInfo.CameraInfo = oCamera;
}
return(videoInfo);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
public CameraInfo GetCameraInfoByCameraId(ref string errMessage, int CameraId)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
DataSet ds = CameraDataAccess.GetCamInfoByCameraId(db, CameraId);
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
return(new CameraInfo(ds.Tables[0].Rows[0]));
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}