public Dictionary <int, Event> GetEventCustom(ref string errMessage, string str)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
Dictionary <int, Event> list = new Dictionary <int, Event>();
try
{
DataSet ds = EventDataAccess.GetEventCustom(db, str);
Event et;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
et = new Event(ds.Tables[0].Rows[i]);
et.CapturePicture = CapturePictureBusiness.Instance.GetCapturePicture(ref errMessage, et.PictureID);
et.CameraInfo = CameraBusiness.Instance.GetCameraInfoByCameraId(ref errMessage,
et.CapturePicture.CameraID);
et.VideoInfo = VideoBusiness.Instance.GetVideoInfoById(ref errMessage, et.VideoId);
list.Add(et.EventId, et);
}
return(list);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
public Event GetEvent(ref string errMessage, int cameraId, DateTime captureDataTime)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
Event et = null;
try
{
DataSet ds = EventDataAccess.GetEventCustom(db, string.Format(" and CapturePicture.CameraId={0} and CapturePicture.DateTime='{1}'", cameraId, captureDataTime));
et = new Event(ds.Tables[0].Rows[0]);
et.CapturePicture = CapturePictureBusiness.Instance.GetCapturePicture(ref errMessage, et.PictureID);
et.CameraInfo = CameraBusiness.Instance.GetCameraInfoByCameraId(ref errMessage,
et.CapturePicture.CameraID);
et.VideoInfo = VideoBusiness.Instance.GetVideoInfoById(ref errMessage, et.VideoId);
return(et);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
