public IHttpActionResult GridBind() { ApiResData res = new ApiResData(); try { List <TOURIS_TM_SUB_CATEGORY> subCategories = repo.GridBind(); List <TOURIS_TV_SUB_CATEGORY> subCategoryViews = new List <TOURIS_TV_SUB_CATEGORY>(); if (subCategories.Count > 0) { foreach (var item in subCategories) { TOURIS_TV_SUB_CATEGORY subCategoryView = new TOURIS_TV_SUB_CATEGORY(); subCategoryView.ID = item.ID; subCategoryView.CATEGORY_ID = item.CATEGORY_ID; subCategoryView.CATEGORY_NAME = item.TOURIS_TM_CATEGORY.CATEGORY_NAME; subCategoryView.COUNTRY_ID = item.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.TOURIS_TM_COUNTRY.ID; subCategoryView.COUNTRY_NAME = item.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.TOURIS_TM_COUNTRY.COUNTRY_NAME; subCategoryView.PROVINCE_ID = item.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.ID; subCategoryView.PROVINCE_NAME = item.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.PROVINCE_NAME; subCategoryView.CITY_ID = item.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.ID; subCategoryView.CITY_NAME = item.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.CITY_NAME; subCategoryView.VILLAGE_ID = item.VILLAGE_ID; subCategoryView.VILLAGE_NAME = item.TOURIS_TM_VILLAGE.VILLAGE_NAME; subCategoryView.SUB_CATEGORY_NAME = item.SUB_CATEGORY_NAME; subCategoryView.SUB_CATEGORY_DESCRIPTION = item.SUB_CATEGORY_DESCRIPTION; subCategoryView.ADDRESS = item.ADDRESS; subCategoryView.START_TIME = item.START_TIME; subCategoryView.END_TIME = item.END_TIME; subCategoryView.PHOTO_PATH = item.PHOTO_PATH; subCategoryView.LATITUDE = item.LATITUDE; subCategoryView.LONGITUDE = item.LONGITUDE; subCategoryView.CREATED_BY = item.CREATED_BY; subCategoryView.CREATED_TIME = item.CREATED_TIME; subCategoryView.LAST_MODIFIED_BY = item.LAST_MODIFIED_BY; subCategoryView.LAST_MODIFIED_TIME = item.LAST_MODIFIED_TIME; subCategoryViews.Add(subCategoryView); } rs.SetSuccessStatus(); } resObj = JObject.FromObject(res.ResGetDataTable(new object[] { subCategoryViews }, null)); return(Content(HttpStatusCode.OK, resObj)); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); resObj = JObject.FromObject(res.ResGetDataTable(new object[] { rs }, new Exception(eFunc.fg.DataNf))); return(Content(HttpStatusCode.BadGateway, resObj)); } }