public List <V_Camera> GetEntities()
{
var entities = new List <V_Camera>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_V_Camera_Repository_GetEntities, null)) {
while (rdr.Read())
{
var entity = new V_Camera();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.IP = SqlTypeConverter.DBNullStringHandler(rdr["IP"]);
entity.Port = SqlTypeConverter.DBNullInt32Handler(rdr["Port"]);
entity.Uid = SqlTypeConverter.DBNullStringHandler(rdr["Uid"]);
entity.Pwd = SqlTypeConverter.DBNullStringHandler(rdr["Pwd"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]);
entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]);
entity.DeviceName = SqlTypeConverter.DBNullStringHandler(rdr["DeviceName"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.RoomName = SqlTypeConverter.DBNullStringHandler(rdr["RoomName"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.StationName = SqlTypeConverter.DBNullStringHandler(rdr["StationName"]);
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.AreaName = SqlTypeConverter.DBNullStringHandler(rdr["AreaName"]);
entities.Add(entity);
}
}
return(entities);
}
public V_Camera GetEntity(string id)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);
V_Camera entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_V_Camera_Repository_GetEntity, parms)) {
if (rdr.Read())
{
entity = new V_Camera();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.IP = SqlTypeConverter.DBNullStringHandler(rdr["IP"]);
entity.Port = SqlTypeConverter.DBNullInt32Handler(rdr["Port"]);
entity.Uid = SqlTypeConverter.DBNullStringHandler(rdr["Uid"]);
entity.Pwd = SqlTypeConverter.DBNullStringHandler(rdr["Pwd"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]);
entity.DeviceId = SqlTypeConverter.DBNullStringHandler(rdr["DeviceId"]);
entity.DeviceName = SqlTypeConverter.DBNullStringHandler(rdr["DeviceName"]);
entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]);
entity.RoomName = SqlTypeConverter.DBNullStringHandler(rdr["RoomName"]);
entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]);
entity.StationName = SqlTypeConverter.DBNullStringHandler(rdr["StationName"]);
entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]);
entity.AreaName = SqlTypeConverter.DBNullStringHandler(rdr["AreaName"]);
}
}
return(entity);
}
