public static List<PlaceCategoryModel> GetAllPlaceCat(DataTable data)
{
List<PlaceCategoryModel> result = new List<PlaceCategoryModel>();
for (int i = 0; i < data.Rows.Count; i++)
{
PlaceCategoryModel place_cat = new PlaceCategoryModel();
place_cat.id = Convert.ToInt32(data.Rows[i][0]);
place_cat.place_category = Convert.ToString(data.Rows[i][1]);
result.Add(place_cat);
}
return result;
}
public static List<PlaceModel> GetAllFromDataTable(DataTable data)
{
List<PlaceModel> result = new List<PlaceModel>();
for (int i = 0; i < data.Rows.Count; i++)
{
PlaceModel place = new PlaceModel();
place.id = Convert.ToInt32(data.Rows[i][0]);
PlaceCategoryModel place_cat = new PlaceCategoryModel();
place_cat.GetDataById(Convert.ToInt32(data.Rows[i][1]));
place.place_category_obj = place_cat;
place.name = Convert.ToString(data.Rows[i][2]);
place.imgurl = Convert.ToString(data.Rows[i][3]);
place.lat = Convert.ToDouble(data.Rows[i][4]);
place.lng = Convert.ToDouble(data.Rows[i][5]);
place.house_number = Convert.ToString(data.Rows[i][6]);
place.street = Convert.ToString(data.Rows[i][7]);
place.ward = Convert.ToString(data.Rows[i][8]);
place.district = Convert.ToString(data.Rows[i][9]);
place.city = Convert.ToString(data.Rows[i][10]);
place.province = Convert.ToString(data.Rows[i][11]);
place.country = Convert.ToString(data.Rows[i][12]);
place.phone_number = Convert.ToString(data.Rows[i][13]);
place.email = Convert.ToString(data.Rows[i][14]);
place.website = Convert.ToString(data.Rows[i][15]);
place.history = Convert.ToString(data.Rows[i][16]);
place.details = Convert.ToString(data.Rows[i][17]);
place.sources = Convert.ToString(data.Rows[i][18]);
place.general_rating = Convert.ToInt32(data.Rows[i][19] == DBNull.Value ? 0 : data.Rows[i][19]);
place.general_count_rating = Convert.ToInt32(data.Rows[i][20] == DBNull.Value ? 0 : data.Rows[i][20]);
place.general_sum_rating = Convert.ToInt32(data.Rows[i][21] == DBNull.Value ? 0 : data.Rows[i][21]);
result.Add(place);
}
return result;
}
