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