public List <D_Fsu> GetFsus() { var entities = new List <D_Fsu>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_D_Fsu_Repository_GetFsus, null)) { while (rdr.Read()) { var entity = new D_Fsu(); entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]); entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]); entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]); entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]); entity.AreaName = SqlTypeConverter.DBNullStringHandler(rdr["AreaName"]); entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]); entity.StationName = SqlTypeConverter.DBNullStringHandler(rdr["StationName"]); entity.StaTypeId = SqlTypeConverter.DBNullStringHandler(rdr["StaTypeId"]); entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]); entity.RoomName = SqlTypeConverter.DBNullStringHandler(rdr["RoomName"]); entity.RoomTypeId = SqlTypeConverter.DBNullStringHandler(rdr["RoomTypeId"]); entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]); entity.VendorId = SqlTypeConverter.DBNullStringHandler(rdr["VendorId"]); entity.VendorName = SqlTypeConverter.DBNullStringHandler(rdr["VendorName"]); entities.Add(entity); } } return(entities); }
public List <D_Fsu> GetFsusInRoom(string id) { SqlParameter[] parms = { new SqlParameter("@RoomId", SqlDbType.VarChar, 100) }; parms[0].Value = SqlTypeConverter.DBNullStringChecker(id); var entities = new List <D_Fsu>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_D_Fsu_Repository_GetFsusInRoom, parms)) { while (rdr.Read()) { var entity = new D_Fsu(); entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]); entity.Code = SqlTypeConverter.DBNullStringHandler(rdr["Code"]); entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]); entity.AreaId = SqlTypeConverter.DBNullStringHandler(rdr["AreaId"]); entity.AreaName = SqlTypeConverter.DBNullStringHandler(rdr["AreaName"]); entity.StationId = SqlTypeConverter.DBNullStringHandler(rdr["StationId"]); entity.StationName = SqlTypeConverter.DBNullStringHandler(rdr["StationName"]); entity.StaTypeId = SqlTypeConverter.DBNullStringHandler(rdr["StaTypeId"]); entity.RoomId = SqlTypeConverter.DBNullStringHandler(rdr["RoomId"]); entity.RoomName = SqlTypeConverter.DBNullStringHandler(rdr["RoomName"]); entity.RoomTypeId = SqlTypeConverter.DBNullStringHandler(rdr["RoomTypeId"]); entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]); entity.VendorId = SqlTypeConverter.DBNullStringHandler(rdr["VendorId"]); entity.VendorName = SqlTypeConverter.DBNullStringHandler(rdr["VendorName"]); entities.Add(entity); } } return(entities); }