public Dictionary <int, CameraInfo> GetAllCameraInfo(ref string errMessage)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
Dictionary <int, CameraInfo> list = new Dictionary <int, CameraInfo>();
try
{
DataSet ds = CameraDataAccess.GetAllCamInfo(db);
CameraInfo oCamera;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
oCamera = new CameraInfo(ds.Tables[0].Rows[i]);
list.Add(oCamera.CameraId, oCamera);
}
return(list);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
public int Insert(ref string errMessage, List <CameraInfo> listCam, DeviceInfo oDeviceInfo)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
int iDeviceId = 0;
int iRtn = 0;
try
{
// using (TransactionScope transaction = new TransactionScope())
//{
iRtn = DeviceDataAccess.Insert(db, oDeviceInfo);
iDeviceId = DeviceDataAccess.GetMaxDeviceId(db);
foreach (CameraInfo item in listCam)
{
item.DeviceId = iDeviceId;
CameraDataAccess.Insert(db, item);
}
// transaction.Complete();
// }
return(iRtn);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(-1);
}
}
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 Dictionary <int, GroupInfo> GetAllGroupInfos(ref string errMessage)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
Dictionary <int, GroupInfo> list = new Dictionary <int, GroupInfo>();
try
{
GroupInfo oGroupInfo;
DeviceInfo oDevice;
DataSet ds = GroupDataAccess.GetAllGroupInfo(db);
DataSet dsDevice;
DataSet dsCamera;
CameraInfo oCamera;
DataSet dsAlarm;
AlarmInfo oAlarm;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
oGroupInfo = new GroupInfo(ds.Tables[0].Rows[i]);
dsDevice = DeviceDataAccess.GetDeviceInfoByGroupId(db, oGroupInfo.GroupID);
oGroupInfo.ListDevice = new Dictionary <int, DeviceInfo>();
foreach (DataRow dr in dsDevice.Tables[0].Rows)
{
oDevice = new DeviceInfo(dr);
oDevice.ListCamera = new Dictionary <int, CameraInfo>();
dsCamera = CameraDataAccess.GetCamInfoByDeviceId(db, oDevice.DeviceId);
foreach (DataRow drCam in dsCamera.Tables[0].Rows)
{
oCamera = new CameraInfo(drCam);
oDevice.ListCamera.Add(oCamera.CameraId, oCamera);
}
oDevice.ListAlarm = new Dictionary <int, AlarmInfo>();
dsAlarm = AlarmDataAccess.GetAlarmInfoByDeviceId(db, oDevice.DeviceId);
foreach (DataRow drAlarm in dsAlarm.Tables[0].Rows)
{
oAlarm = new AlarmInfo(drAlarm);
oDevice.ListAlarm.Add(oAlarm.AlarmId, oAlarm);
}
oGroupInfo.ListDevice.Add(oDevice.DeviceId, oDevice);
}
list.Add(oGroupInfo.GroupID, oGroupInfo);
}
return(list);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
public DataTable GetCheckInfo(int number, string name, string beginTime, string endTime, int checkType)
{
DataTable dt = null;
try
{
dt = new CameraDataAccess().GetCheckInfo(number, name, beginTime, endTime, checkType);
}
catch (Exception ex)
{
Util.WriteLog(ex.ToString(), Util.EXCEPTION_LOG_TITLE);
}
return(dt);
}
public DataTable GetCameraInfo()
{
DataTable dt = null;
try
{
dt = new CameraDataAccess().GetCameraInfo();
}
catch (Exception ex)
{
Util.WriteLog(ex.ToString(), Util.EXCEPTION_LOG_TITLE);
}
return(dt);
}
public int Update(ref string errMessage, CameraInfo oCameraInfo)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
return(CameraDataAccess.Update(db, oCameraInfo));
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(-1);
}
}
public Dictionary <int, CameraInfo> GetCamInfoByDeviceId(ref string errMessage, int DeviceId)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
Dictionary <int, CameraInfo> list = new Dictionary <int, CameraInfo>();
try
{
DataSet ds = CameraDataAccess.GetCamInfoByDeviceId(db, DeviceId);
CameraInfo oCamera;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
oCamera = new CameraInfo(ds.Tables[0].Rows[i]);
list.Add(oCamera.CameraId, oCamera);
}
return(list);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
/*Database db = DatabaseFactory.CreateDatabase();
* errMessage = "";
* try
* {
* DataSet ds = CameraDataAccess.GetCamInfoByDeviceId(db, DeviceId);
* 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;
* }*/
}
public int Delete(ref string errMessage, int CameraId)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
int iRtn = CameraDataAccess.Delete(db, CameraId);
return(iRtn);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(-1);
}
}
public DeviceInfo GetDeviceInfoByDeviceName(ref string errMessage, string deviceName)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
DataSet ds = DeviceDataAccess.GetDeviceInfoByDeviceName(db, deviceName);
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
DataSet dsCamera;
CameraInfo oCamera;
DeviceInfo oDeviceInfo = new DeviceInfo(ds.Tables[0].Rows[0]);
oDeviceInfo.ListCamera = new Dictionary <int, CameraInfo>();
dsCamera = CameraDataAccess.GetCamInfoByDeviceId(db, oDeviceInfo.DeviceId);
foreach (DataRow drCam in dsCamera.Tables[0].Rows)
{
oCamera = new CameraInfo(drCam);
oDeviceInfo.ListCamera.Add(oCamera.CameraId, oCamera);
}
oDeviceInfo.ListAlarm = new Dictionary <int, AlarmInfo>();
DataSet dsAlarm;
AlarmInfo oAlarm;
dsAlarm = AlarmDataAccess.GetAlarmInfoByDeviceId(db, oDeviceInfo.DeviceId);
foreach (DataRow drAlarm in dsAlarm.Tables[0].Rows)
{
oAlarm = new AlarmInfo(drAlarm);
oDeviceInfo.ListAlarm.Add(oAlarm.AlarmId, oAlarm);
}
return(oDeviceInfo);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
// Create video source
public CameraInfo GetCamInfoByDeviceIdAndCameraName(ref string errMessage, int deviceId, string cameraName)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
DataSet ds = CameraDataAccess.GetCamInfoByDeviceIdAndCameraName(db, deviceId, cameraName);
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);
}
}
public int Update(ref string errMessage, List <CameraInfo> listCam, DeviceInfo oDeviceInfo)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
int iRtn = -1;
try
{
CameraDataAccess.DeleteByDeviceId(db, oDeviceInfo.DeviceId);
foreach (CameraInfo item in listCam)
{
CameraDataAccess.Insert(db, item);
}
iRtn = DeviceDataAccess.Update(db, oDeviceInfo);
return(iRtn);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(-1);
}
}
public Dictionary <int, ChangeSynGroup> GetAllChangeSynGroup(ref string errMessage)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
var list = new Dictionary <int, ChangeSynGroup>();
try
{
ChangeSynGroup synGroup;
DeviceInfo oDevice;
DataSet ds = ChangeSynGroupDataAccess.GetAllChangeSynGroupInfo(db);
DataSet dsCamera;
CameraInfo oCamera;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
synGroup = new ChangeSynGroup(ds.Tables[0].Rows[i]);
dsCamera = CameraDataAccess.GetCamInfoByChangeSynGroupId(db, synGroup.ChangeSynGroupId);
synGroup.ListCamera = new Dictionary <int, CameraInfo>();
foreach (DataRow drCam in dsCamera.Tables[0].Rows)
{
oCamera = new CameraInfo(drCam);
synGroup.ListCamera.Add(oCamera.CameraId, oCamera);
}
list.Add(synGroup.ChangeSynGroupId, synGroup);
}
return(list);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
Logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
public ChangeSynGroup GetChangeSynGroupById(ref string errMessage, int synGroupId)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
DataSet ds = ChangeSynGroupDataAccess.GetChangeSynGroupById(db, synGroupId);
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
CameraInfo oCamera;
DeviceInfo oDevice;
var synGroup = new ChangeSynGroup(ds.Tables[0].Rows[0])
{
ListCamera = new Dictionary <int, CameraInfo>()
};
DataSet dsCamera = CameraDataAccess.GetCamInfoByDeviceId(db, synGroup.ChangeSynGroupId);
synGroup.ListCamera = new Dictionary <int, CameraInfo>();
foreach (DataRow drCam in dsCamera.Tables[0].Rows)
{
oCamera = new CameraInfo(drCam);
synGroup.ListCamera.Add(oCamera.CameraId, oCamera);
}
return(synGroup);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
Logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(null);
}
}
