public int GetId(int numRecord) { string connectionString = ConfigurationManager.ConnectionStrings["ConnectToSQL"].ConnectionString; IRoomRepository repository = new RoomRepository(connectionString); int _id = 0; int counter = 0; var rooms = repository.SelectAll(); var roomDTOs = new List<RoomDTO>(); foreach (var room in rooms) { counter++; roomDTOs.Add(new RoomDTO() { Id = room.Id, Name = room.Name, Price = room.Price, npp = counter}); } foreach (var item in roomDTOs) { if (item.npp == numRecord) { _id = item.Id; break; } } return _id; }
public RoomDTO[] SelectAll() { string connectionString = ConfigurationManager.ConnectionStrings["ConnectToSQL"].ConnectionString; IRoomRepository repository = new RoomRepository(connectionString); var rooms = repository.SelectAll(); var roomDTOs = new List<RoomDTO>(); foreach (var room in rooms) { roomDTOs.Add(new RoomDTO() { npp = room.npp, Id = room.Id, Name = room.Name, Price = room.Price }); } return roomDTOs.ToArray(); }