public Dictionary <int, WindowCameraInfo> GetWindowCameraInfoByCamera(ref string errMessage, int camera) { Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; Dictionary <int, WindowCameraInfo> list = new Dictionary <int, WindowCameraInfo>(); try { DataSet ds = WindowCameraDataAccess.GetWindowCameraInfoByCamera(db, camera); WindowCameraInfo windowCameraInfo; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { windowCameraInfo = new WindowCameraInfo(ds.Tables[0].Rows[i]); list.Add(windowCameraInfo.Id, windowCameraInfo); } return(list); } 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, int id, int row, int col) { Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; try { int iRtn = WindowCameraDataAccess.Update(db, id, row, col); return(iRtn); } catch (Exception ex) { errMessage = ex.Message + ex.StackTrace; logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace); return(-1); } }
public bool IsWindowCameraExisted(ref string errMessage, int row, int col) { bool ret = true; Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; try { return(WindowCameraDataAccess.IsWindowCameraExisted(db, row, col)); } catch (Exception ex) { errMessage = ex.Message + ex.StackTrace; logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace); return(true); } }
public int Insert(ref string errMessage, WindowCameraInfo windowCameraInfo) { Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; try { return(WindowCameraDataAccess.IsWindowCameraExisted(db, windowCameraInfo.Row, windowCameraInfo.Col) ? WindowCameraDataAccess.Update(db, windowCameraInfo.Row, windowCameraInfo.Col, windowCameraInfo.CameraId) : WindowCameraDataAccess.Insert(db, windowCameraInfo)); } catch (Exception ex) { errMessage = ex.Message + ex.StackTrace; logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace); return(-1); } }
public WindowCameraInfo GetWindowCameraInfoByRowCol(ref string errMessage, int row, int col) { Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; try { DataSet ds = WindowCameraDataAccess.GetWindowCameraInfoByRowCol(db, row, col); if (ds.Tables[0].Rows.Count == 0) { return(null); } return(new WindowCameraInfo(ds.Tables[0].Rows[0])); } catch (Exception ex) { errMessage = ex.Message + ex.StackTrace; logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace); return(null); } }