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