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 static int Insert(Database db, ChangeSynGroup oGroupInfo)
{
StringBuilder sbField = new StringBuilder();
StringBuilder sbValue = new StringBuilder();
sbField.Append("INSERT INTO ChangeSynGroup(");
sbValue.Append("values(");
sbField.Append("Name");
sbValue.AppendFormat("'{0}'", oGroupInfo.Name);
sbField.Append(",Description");
sbValue.AppendFormat(",'{0}')", oGroupInfo.Description);
string cmdText = sbField.ToString() + " " + sbValue.ToString() + "";
try
{
return db.ExecuteNonQuery(CommandType.Text, cmdText);
}
catch (Exception ex)
{
throw ex;
}
}
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;
}
}
public int Update(ref string errMessage, ChangeSynGroup synGroup)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
return ChangeSynGroupDataAccess.Update(db, synGroup);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
Logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return -1;
}
}
public static int Update(Database db, ChangeSynGroup oGroupInfo)
{
StringBuilder sb = new StringBuilder();
sb.Append("update ChangeSynGroup set");
sb.AppendFormat(" Name='{0}'", oGroupInfo.Name);
sb.AppendFormat(",Description='{0}'", oGroupInfo.Description);
sb.AppendFormat(" where GroupID={0})", oGroupInfo.ChangeSynGroupId);
string cmdText = sb.ToString();
try
{
return db.ExecuteNonQuery(CommandType.Text, cmdText);
}
catch (Exception ex)
{
throw ex;
}
}