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);
}
}
