public List<Models.HotelDetail> parseHotelDetails()
{
CsvReader csv = new CsvReader(reader, true);
int fieldCount = csv.FieldCount;
List<HotelDetail> hotels = new List<HotelDetail>();
String[] headers = csv.GetFieldHeaders();
while (csv.ReadNextRecord())
{
//This is where the models come into effect
HotelDetail thisObj = new HotelDetail();
//This loop reflects contents of the model. Header captions match actual text in csv file
for (int i = 0; i < fieldCount; i++)
{
if (headers[i].Equals("doc_id"))
{
thisObj.docID = csv[i];
}
else if (headers[i].Equals("hotel_name"))
{
thisObj.hotelName = csv[i];
}
else if (headers[i].Equals("hotel_url"))
{
thisObj.hotelUrl = csv[i];
}
else if (headers[i].Equals("street"))
{
thisObj.street = csv[i];
}
else if (headers[i].Equals("city"))
{
thisObj.city = csv[i];
}
else if (headers[i].Equals("state"))
{
thisObj.state = csv[i];
}
else if (headers[i].Equals("country"))
{
thisObj.country = csv[i];
}
else if (headers[i].Equals("zip"))
{
thisObj.zip = csv[i];
}
else if (headers[i].Equals("class"))
{
thisObj.classRating = csv[i];
}
else if (headers[i].Equals("price"))
{
thisObj.price = csv[i];
}
else if (headers[i].Equals("num_reviews"))
{
thisObj.numReviews = csv[i];
}
else if (headers[i].Equals("CLEANLINESS"))
{
thisObj.cleanliness = csv[i];
}
else if (headers[i].Equals("ROOM"))
{
thisObj.room = csv[i];
}
else if (headers[i].Equals("SERVICE"))
{
thisObj.service = csv[i];
}
else if (headers[i].Equals("LOCATION"))
{
thisObj.location = csv[i];
}
else if (headers[i].Equals("VALUE"))
{
thisObj.value = csv[i];
}
else if (headers[i].Equals("COMFORT"))
{
thisObj.comfort = csv[i];
}
else if (headers[i].Equals("overall_ratingsource"))
{
thisObj.overallRating = csv[i];
}
}
//Every time around, add a new object
hotels.Add(thisObj);
}
return hotels;
}
public HotelDetail addHotelDetails(HotelDetail hotel)
{
return null;
}
public List<Models.HotelDetail> parseHotelDetails()
{
CsvReader csv = new CsvReader(reader, true);
int fieldCount = csv.FieldCount;
//Array storage
List<HotelDetail> hotels = new List<HotelDetail>();
String[] headers = csv.GetFieldHeaders();
while (csv.ReadNextRecord())
{
//HotelDetails Model
HotelDetail thisObj = new HotelDetail();
//Each field represents a table in the database direct from the CSV file
for (int i = 0; i < fieldCount; i++)
{
if (headers[i].Equals("doc_id"))
{
thisObj.docID = csv[i];
}
else if (headers[i].Equals("hotel_name"))
{
thisObj.hotelName = csv[i];
}
else if (headers[i].Equals("hotel_url"))
{
thisObj.hotelUrl = csv[i];
}
else if (headers[i].Equals("street"))
{
thisObj.street = csv[i];
}
else if (headers[i].Equals("city"))
{
thisObj.city = csv[i];
}
else if (headers[i].Equals("state"))
{
thisObj.state = csv[i];
}
else if (headers[i].Equals("country"))
{
thisObj.country = csv[i];
}
else if (headers[i].Equals("zip"))
{
thisObj.zip = csv[i];
}
else if (headers[i].Equals("class"))
{
thisObj.classRating = csv[i];
}
else if (headers[i].Equals("price"))
{
thisObj.price = csv[i];
}
else if (headers[i].Equals("num_reviews"))
{
thisObj.numReviews = csv[i];
}
else if (headers[i].Equals("CLEANLINESS"))
{
thisObj.cleanliness = csv[i];
}
else if (headers[i].Equals("ROOM"))
{
thisObj.room = csv[i];
}
else if (headers[i].Equals("SERVICE"))
{
thisObj.service = csv[i];
}
else if (headers[i].Equals("LOCATION"))
{
thisObj.location = csv[i];
}
else if (headers[i].Equals("VALUE"))
{
thisObj.value = csv[i];
}
else if (headers[i].Equals("COMFORT"))
{
thisObj.comfort = csv[i];
}
else if (headers[i].Equals("overall_ratingsource"))
{
thisObj.overallRating = csv[i];
}
}
//Every time around, add a new object
hotels.Add(thisObj);
}
return hotels;
}