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, 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 int Insert(ref string errMessage, DeviceInfo oDeviceInfo) { Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; try { return(DeviceDataAccess.Insert(db, oDeviceInfo)); } catch (Exception ex) { errMessage = ex.Message + ex.StackTrace; logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace); return(-1); } }
public DataTable GetDisplayDeviceByDeviceList(ref string errMessage, string deviceList) { Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; try { DataSet ds = DeviceDataAccess.GetAllDisplayDeviceByDeviceList(db, deviceList); return(ds.Tables[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 deviceId) { Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; try { int iRtn = DeviceDataAccess.Delete(db, deviceId); iRtn = CameraDataAccess.DeleteByDeviceId(db, deviceId); 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); } }
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); } }
protected override void InitializeDeviceDataAccess() { DeviceDataAccess.Initialize <AndroidDeviceDataAccess>(); (DeviceDataAccess.Current as AndroidDeviceDataAccess).Context = context; }
public void TestInit() { EnvironmentVariables.Initialize(AuthenticationTestable.AuthenticationClientId, AuthenticationTestable.AuthenticationRedirectUri); dataAccess = DeviceDataAccess.Initialize <DeviceDataAccessTestable>(); }
protected override void InitializeDeviceDataAccess() { DeviceDataAccess.Initialize <WinPhoneDeviceDataAccess>(); }