public Dictionary<int, WindowCameraInfo> GetAllWindowCameraInfo(ref string errMessage)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
Dictionary<int, WindowCameraInfo> list = new Dictionary<int, WindowCameraInfo>();
try
{
DataSet ds = WindowCameraDataAccess.GetAllWindowCameraInfo(db);
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 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 static int Insert(Database db, WindowCameraInfo windowCameraInfo)
{
StringBuilder sbField = new StringBuilder();
StringBuilder sbValue = new StringBuilder();
sbField.Append("INSERT INTO [WindowCameraInfo](");
sbValue.Append("values (");
sbField.Append("[row]");
sbValue.AppendFormat("{0}", windowCameraInfo.Row);
sbField.Append(",[col]");
sbValue.AppendFormat(",{0}", windowCameraInfo.Col);
sbField.Append(",[Camera])");
sbValue.AppendFormat(",{0})", windowCameraInfo.CameraId);
string cmdText = sbField.ToString() + " " + sbValue.ToString();
try
{
cmdText = cmdText.Replace("\r\n", "");
return db.ExecuteNonQuery(CommandType.Text, cmdText);
}
catch (Exception ex)
{
throw ex;
}
}