public IHttpActionResult RetrieveData(int id)
{
ApiResData res = new ApiResData();
try
{
TOURIS_TM_MENU menu = repo.Retrieve(id);
TOURIS_TV_MENU menuView = new TOURIS_TV_MENU();
if (menu != null)
{
menuView.ID = menu.ID;
menuView.MENU_NAME = menu.MENU_NAME;
menuView.MENU_DESCRIPTION = menu.MENU_DESCRIPTION;
menuView.MENU_PARENT_ID = menu.MENU_PARENT_ID;
menuView.CREATED_BY = menu.CREATED_BY;
menuView.CREATED_TIME = menu.CREATED_TIME;
menuView.LAST_MODIFIED_BY = menu.LAST_MODIFIED_BY;
menuView.LAST_MODIFIED_TIME = menu.LAST_MODIFIED_TIME;
rs.SetSuccessStatus();
}
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { menuView }, 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.BadRequest, resObj));
}
}
public IHttpActionResult ChangePassword(CUSTOM_CHANGE_PASSWORD changePassword)
{
ApiResData res = new ApiResData();
try
{
if (!ModelState.IsValid)
{
rs.SetErrorStatus(eFunc.fg.SFailed);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.DataNf, new Exception(eFunc.fg.DataIsntValid)));
return(Content(HttpStatusCode.NotFound, resObj));
}
rs = repo.ChangePassword(changePassword.IdUser, changePassword.OldPassword, changePassword.NewPassword);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Delete, 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.BadRequest, resObj));
}
}
public IHttpActionResult RetrieveData(int id)
{
ApiResData res = new ApiResData();
try
{
TOURIS_TM_SLIDESHOW slideshow = repo.Retrieve(id);
TOURIS_TV_SLIDESHOW slideshowView = new TOURIS_TV_SLIDESHOW();
if (slideshow != null)
{
slideshowView.ID = slideshow.ID;
slideshowView.TITTLE = slideshow.TITTLE;
slideshowView.CONTENT_DESCRIPTION = slideshow.CONTENT_DESCRIPTION;
slideshowView.CLASS = slideshow.CLASS;
slideshowView.PHOTO_PATH = slideshow.PHOTO_PATH;
slideshowView.URL = slideshow.URL;
slideshowView.CREATED_BY = slideshow.CREATED_BY;
slideshowView.CREATED_TIME = slideshow.CREATED_TIME;
slideshowView.LAST_MODIFIED_BY = slideshow.LAST_MODIFIED_BY;
slideshowView.LAST_MODIFIED_TIME = slideshow.LAST_MODIFIED_TIME;
rs.SetSuccessStatus();
}
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { slideshowView }, 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.BadRequest, resObj));
}
}
public IHttpActionResult RetrieveData(int id)
{
ApiResData res = new ApiResData();
try
{
TOURIS_TM_COUNTRY country = repo.Retrieve(id);
TOURIS_TV_COUNTRY countryView = new TOURIS_TV_COUNTRY();
if (country != null)
{
countryView.ID = country.ID;
countryView.COUNTRY_CODE = country.COUNTRY_CODE;
countryView.COUNTRY_NAME = country.COUNTRY_NAME;
countryView.COUNTRY_DESCRIPTION = country.COUNTRY_DESCRIPTION;
countryView.CREATED_BY = country.CREATED_BY;
countryView.CREATED_TIME = country.CREATED_TIME;
countryView.LAST_MODIFIED_BY = country.LAST_MODIFIED_BY;
countryView.LAST_MODIFIED_TIME = country.LAST_MODIFIED_TIME;
rs.SetSuccessStatus();
}
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { countryView }, 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.BadRequest, resObj));
}
}
public IHttpActionResult RetrieveData(int id)
{
ApiResData res = new ApiResData();
try
{
TOURIS_TM_SUB_CATEGORY_PHOTO subCategoryPhoto = repo.Retrieve(id);
TOURIS_TV_SUB_CATEGORY_PHOTO subCategoryPhotoView = new TOURIS_TV_SUB_CATEGORY_PHOTO();
if (subCategoryPhoto != null)
{
subCategoryPhotoView.ID = subCategoryPhoto.ID;
subCategoryPhotoView.SUB_CATEGORY_ID = subCategoryPhoto.SUB_CATEGORY_ID;
subCategoryPhotoView.SUB_CATEGORY_NAME = subCategoryPhoto.TOURIS_TM_SUB_CATEGORY.SUB_CATEGORY_NAME;
subCategoryPhotoView.PHOTO_NAME = subCategoryPhoto.PHOTO_NAME;
subCategoryPhotoView.PHOTO_DESCRIPTION = subCategoryPhoto.PHOTO_DESCRIPTION;
subCategoryPhotoView.PHOTO_PATH = subCategoryPhoto.PHOTO_PATH;
subCategoryPhotoView.CREATED_BY = subCategoryPhoto.CREATED_BY;
subCategoryPhotoView.CREATED_TIME = subCategoryPhoto.CREATED_TIME;
subCategoryPhotoView.LAST_MODIFIED_BY = subCategoryPhoto.LAST_MODIFIED_BY;
subCategoryPhotoView.LAST_MODIFIED_TIME = subCategoryPhoto.LAST_MODIFIED_TIME;
rs.SetSuccessStatus();
}
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { subCategoryPhotoView }, 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));
}
}
public IHttpActionResult Delete(int id)
{
ApiResData res = new ApiResData();
try
{
if (!ModelState.IsValid)
{
rs.SetErrorStatus(eFunc.fg.SFailed);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Delete, new Exception(eFunc.fg.DataNf)));
return(Content(HttpStatusCode.NotFound, resObj));
}
rs = repo.Delete(id, "System", CurrentUser.GetCurrentDateTime());
if (rs.IsSuccess)
{
rs.SetSuccessStatus();
}
else
{
rs.SetErrorStatus(eFunc.fg.SFailed);
}
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Delete, null));
return(Content(HttpStatusCode.OK, resObj));
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Delete, new Exception(eFunc.fg.DFailed)));
return(Content(HttpStatusCode.BadRequest, resObj));
}
}
public IHttpActionResult RetrieveData(int id)
{
ApiResData res = new ApiResData();
try
{
TOURIS_TM_CONTACT_US contactUs = repo.Retrieve(id);
TOURIS_TV_CONTACT_US contactUsView = new TOURIS_TV_CONTACT_US();
if (contactUs != null)
{
contactUsView.ID = contactUs.ID;
contactUsView.NAME_SENDER = contactUs.NAME_SENDER;
contactUsView.EMAIL_SENDER = contactUs.EMAIL_SENDER;
contactUsView.PHONE_SENDER = contactUs.PHONE_SENDER;
contactUsView.DESCRIPTION = contactUs.DESCRIPTION;
contactUsView.CREATED_BY = contactUs.CREATED_BY;
contactUsView.CREATED_TIME = contactUs.CREATED_TIME;
contactUsView.LAST_MODIFIED_BY = contactUs.LAST_MODIFIED_BY;
contactUsView.LAST_MODIFIED_TIME = contactUs.LAST_MODIFIED_TIME;
rs.SetSuccessStatus();
}
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { contactUsView }, 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.BadRequest, resObj));
}
}
public IHttpActionResult RetrieveData(int id)
{
ApiResData res = new ApiResData();
try
{
TOURIS_TM_PROVINCE province = repo.Retrieve(id);
TOURIS_TV_PROVINCE provinceView = new TOURIS_TV_PROVINCE();
if (province != null)
{
provinceView.ID = province.ID;
provinceView.COUNTRY_ID = province.COUNTRY_ID;
provinceView.COUNTRY_NAME = province.TOURIS_TM_COUNTRY.COUNTRY_NAME;
provinceView.PROVINCE_CODE = province.PROVINCE_CODE;
provinceView.PROVINCE_NAME = province.PROVINCE_NAME;
provinceView.PROVINCE_DESCRIPTION = province.PROVINCE_DESCRIPTION;
provinceView.CREATED_BY = province.CREATED_BY;
provinceView.CREATED_TIME = province.CREATED_TIME;
provinceView.LAST_MODIFIED_BY = province.LAST_MODIFIED_BY;
provinceView.LAST_MODIFIED_TIME = province.LAST_MODIFIED_TIME;
rs.SetSuccessStatus();
}
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { provinceView }, 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));
}
}
public IHttpActionResult RetrieveData(int id)
{
ApiResData res = new ApiResData();
try
{
TOURIS_TM_CATEGORY category = repo.Retrieve(id);
TOURIS_TV_CATEGORY categoryView = new TOURIS_TV_CATEGORY();
if (category != null)
{
categoryView.ID = category.ID;
categoryView.CATEGORY_CODE = category.CATEGORY_CODE;
categoryView.CATEGORY_NAME = category.CATEGORY_NAME;
categoryView.CATEGORY_DESCRIPTION = category.CATEGORY_DESCRIPTION;
categoryView.URL = category.URL;
categoryView.CLASS = category.CLASS;
categoryView.PHOTO_PATH = category.PHOTO_PATH;
categoryView.CREATED_BY = category.CREATED_BY;
categoryView.CREATED_TIME = category.CREATED_TIME;
categoryView.LAST_MODIFIED_BY = category.LAST_MODIFIED_BY;
categoryView.LAST_MODIFIED_TIME = category.LAST_MODIFIED_TIME;
if (category.TOURIS_TM_SUB_CATEGORY.Count > 0)
{
foreach (var item in category.TOURIS_TM_SUB_CATEGORY)
{
TOURIS_TV_SUB_CATEGORY subCategory = new TOURIS_TV_SUB_CATEGORY();
subCategory.ID = item.ID;
subCategory.ADDRESS = item.ADDRESS;
subCategory.CATEGORY_ID = item.CATEGORY_ID;
subCategory.END_TIME = item.END_TIME;
subCategory.START_TIME = item.START_TIME;
subCategory.SUB_CATEGORY_DESCRIPTION = item.SUB_CATEGORY_DESCRIPTION;
subCategory.SUB_CATEGORY_NAME = item.SUB_CATEGORY_NAME;
subCategory.VILLAGE_ID = item.VILLAGE_ID;
subCategory.PHOTO_PATH = item.PHOTO_PATH;
categoryView.TOURIS_TV_SUB_CATEGORY.Add(subCategory);
}
}
rs.SetSuccessStatus();
}
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { categoryView }, 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.BadRequest, resObj));
}
}
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));
}
}
public IHttpActionResult Add(TOURIS_TV_SUB_CATEGORY subCategoryView)
{
ApiResData res = new ApiResData();
try
{
if (!ModelState.IsValid)
{
rs.SetErrorStatus(eFunc.fg.SFailed);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, new Exception(eFunc.fg.DataIsntValid)));
return(Content(HttpStatusCode.NotFound, resObj));
}
TOURIS_TM_SUB_CATEGORY subCategory = new TOURIS_TM_SUB_CATEGORY();
subCategory.CATEGORY_ID = subCategoryView.CATEGORY_ID;
subCategory.VILLAGE_ID = subCategoryView.VILLAGE_ID;
subCategory.SUB_CATEGORY_NAME = subCategoryView.SUB_CATEGORY_NAME;
subCategory.SUB_CATEGORY_DESCRIPTION = subCategoryView.SUB_CATEGORY_DESCRIPTION;
subCategory.START_TIME = subCategoryView.START_TIME;
subCategory.END_TIME = subCategoryView.END_TIME;
subCategory.PHOTO_PATH = subCategoryView.PHOTO_PATH;
subCategory.ADDRESS = subCategoryView.ADDRESS;
subCategory.LATITUDE = subCategoryView.LATITUDE;
subCategory.LONGITUDE = subCategoryView.LONGITUDE;
subCategory.CREATED_BY = subCategoryView.CREATED_BY;
subCategory.CREATED_TIME = subCategoryView.CREATED_TIME;
subCategory.ROW_STATUS = eStat.fg.IsActive;
rs = repo.Add(subCategory);
if (rs.IsSuccess)
{
rs.SetSuccessStatus();
}
else
{
rs.SetErrorStatus(eFunc.fg.SFailed);
}
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, null));
return(Content(HttpStatusCode.OK, resObj));
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, new Exception(eFunc.fg.SFailed)));
return(Content(HttpStatusCode.BadRequest, resObj));
}
}
public IHttpActionResult RetrieveData(int id)
{
ApiResData res = new ApiResData();
try
{
TOURIS_TM_SUB_CATEGORY subCategory = repo.Retrieve(id);
TOURIS_TV_SUB_CATEGORY subCategoryView = new TOURIS_TV_SUB_CATEGORY();
if (subCategory != null)
{
subCategoryView.ID = subCategory.ID;
subCategoryView.CATEGORY_ID = subCategory.CATEGORY_ID;
subCategoryView.CATEGORY_NAME = subCategory.TOURIS_TM_CATEGORY.CATEGORY_NAME;
subCategoryView.COUNTRY_ID = subCategory.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.TOURIS_TM_COUNTRY.ID;
subCategoryView.COUNTRY_NAME = subCategory.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.TOURIS_TM_COUNTRY.COUNTRY_NAME;
subCategoryView.PROVINCE_ID = subCategory.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.ID;
subCategoryView.PROVINCE_NAME = subCategory.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.PROVINCE_NAME;
subCategoryView.CITY_ID = subCategory.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.ID;
subCategoryView.CITY_NAME = subCategory.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.CITY_NAME;
subCategoryView.DISTRICT_ID = subCategory.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.ID;
subCategoryView.DISTRICT_NAME = subCategory.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.DISTRICT_NAME;
subCategoryView.VILLAGE_NAME = subCategory.TOURIS_TM_VILLAGE.VILLAGE_NAME;
subCategoryView.VILLAGE_ID = subCategory.VILLAGE_ID;
subCategoryView.SUB_CATEGORY_NAME = subCategory.SUB_CATEGORY_NAME;
subCategoryView.SUB_CATEGORY_DESCRIPTION = subCategory.SUB_CATEGORY_DESCRIPTION;
subCategoryView.ADDRESS = subCategory.ADDRESS;
subCategoryView.START_TIME = subCategory.START_TIME;
subCategoryView.END_TIME = subCategory.END_TIME;
subCategoryView.PHOTO_PATH = subCategory.PHOTO_PATH;
subCategoryView.LATITUDE = subCategory.LATITUDE;
subCategoryView.LONGITUDE = subCategory.LONGITUDE;
subCategoryView.CREATED_BY = subCategory.CREATED_BY;
subCategoryView.CREATED_TIME = subCategory.CREATED_TIME;
subCategoryView.LAST_MODIFIED_BY = subCategory.LAST_MODIFIED_BY;
subCategoryView.LAST_MODIFIED_TIME = subCategory.LAST_MODIFIED_TIME;
rs.SetSuccessStatus();
}
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { subCategoryView }, 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));
}
}
public IHttpActionResult Add(TOURIS_TV_SOSMED sosmedView)
{
ApiResData res = new ApiResData();
try
{
if (!ModelState.IsValid)
{
rs.SetErrorStatus(eFunc.fg.SFailed);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, new Exception(eFunc.fg.DataIsntValid)));
return(Content(HttpStatusCode.NotFound, resObj));
}
TOURIS_TM_SOSMED sosmed = new TOURIS_TM_SOSMED();
sosmed.TYPE = sosmedView.TYPE;
sosmed.NAME = sosmedView.NAME;
sosmed.DESCRIPTION = sosmedView.DESCRIPTION;
sosmed.ICON = sosmedView.ICON;
sosmed.URL = sosmedView.URL;
sosmed.DATA_EMBED = sosmedView.DATA_EMBED;
sosmed.HEIGHT = sosmedView.HEIGHT;
sosmed.WIDTH = sosmedView.WIDTH;
sosmed.DATA_WIDGET_ID = sosmedView.DATA_WIDGET_ID;
sosmed.CREATED_BY = sosmedView.CREATED_BY;
sosmed.CREATED_TIME = sosmedView.CREATED_TIME;
sosmed.ROW_STATUS = eStat.fg.IsActive;
rs = repo.Add(sosmed);
if (rs.IsSuccess)
{
rs.SetSuccessStatus();
}
else
{
rs.SetErrorStatus(eFunc.fg.SFailed);
}
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, null));
return(Content(HttpStatusCode.OK, resObj));
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, new Exception(eFunc.fg.SFailed)));
return(Content(HttpStatusCode.BadRequest, resObj));
}
}
public IHttpActionResult Add(TOURIS_TV_CATEGORY categoryView)
{
ApiResData res = new ApiResData();
try
{
if (!ModelState.IsValid)
{
rs.SetErrorStatus(eFunc.fg.SFailed);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, new Exception(eFunc.fg.DataIsntValid)));
return(Content(HttpStatusCode.NotFound, resObj));
}
TOURIS_TM_CATEGORY category = new TOURIS_TM_CATEGORY();
category.CATEGORY_CODE = categoryView.CATEGORY_CODE;
category.CATEGORY_NAME = categoryView.CATEGORY_NAME;
category.CATEGORY_DESCRIPTION = categoryView.CATEGORY_DESCRIPTION;
category.URL = categoryView.URL;
category.CLASS = categoryView.CLASS;
category.PHOTO_PATH = categoryView.PHOTO_PATH;
category.CREATED_BY = categoryView.CREATED_BY;
category.CREATED_TIME = categoryView.CREATED_TIME;
category.ROW_STATUS = eStat.fg.IsActive;
rs = repo.Add(category);
if (rs.IsSuccess)
{
rs.SetSuccessStatus();
}
else
{
rs.SetErrorStatus(eFunc.fg.SFailed);
}
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, null));
return(Content(HttpStatusCode.OK, resObj));
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, new Exception(eFunc.fg.SFailed)));
return(Content(HttpStatusCode.BadRequest, resObj));
}
}
public IHttpActionResult GetVillageByDistrictId(int id)
{
ApiResData res = new ApiResData();
try
{
List <TOURIS_TM_VILLAGE> villages = repo.GetVillageByDistrictId(id);
List <TOURIS_TV_VILLAGE> vilageViews = new List <TOURIS_TV_VILLAGE>();
if (villages.Count > 0)
{
foreach (var item in villages)
{
TOURIS_TV_VILLAGE villageView = new TOURIS_TV_VILLAGE();
villageView.ID = item.ID;
villageView.COUNTRY_ID = item.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.TOURIS_TM_COUNTRY.ID;
villageView.COUNTRY_NAME = item.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.TOURIS_TM_COUNTRY.COUNTRY_NAME;
villageView.PROVINCE_ID = item.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.ID;
villageView.PROVINCE_NAME = item.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.PROVINCE_NAME;
villageView.CITY_ID = item.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.ID;
villageView.CITY_NAME = item.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.CITY_NAME;
villageView.DISTRICT_ID = item.TOURIS_TM_DISTRICT.ID;
villageView.DISTRICT_NAME = item.TOURIS_TM_DISTRICT.DISTRICT_NAME;
villageView.VILLAGE_NAME = item.VILLAGE_NAME;
villageView.VILLAGE_DESCRIPTION = item.VILLAGE_DESCRIPTION;
villageView.CREATED_BY = item.CREATED_BY;
villageView.CREATED_TIME = item.CREATED_TIME;
villageView.LAST_MODIFIED_BY = item.LAST_MODIFIED_BY;
villageView.LAST_MODIFIED_TIME = item.LAST_MODIFIED_TIME;
vilageViews.Add(villageView);
}
rs.SetSuccessStatus();
}
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { vilageViews }, 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));
}
}
public IHttpActionResult Add(TOURIS_TV_SLIDESHOW slideshowView)
{
ApiResData res = new ApiResData();
try
{
if (!ModelState.IsValid)
{
rs.SetErrorStatus(eFunc.fg.SFailed);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, new Exception(eFunc.fg.DataIsntValid)));
return(Content(HttpStatusCode.NotFound, resObj));
}
TOURIS_TM_SLIDESHOW slideshow = new TOURIS_TM_SLIDESHOW();
slideshow.TITTLE = slideshowView.TITTLE;
slideshow.CONTENT_DESCRIPTION = slideshowView.CONTENT_DESCRIPTION;
slideshow.CLASS = slideshowView.CLASS;
slideshow.PHOTO_PATH = slideshowView.PHOTO_PATH;
slideshow.URL = slideshowView.URL;
slideshow.CREATED_BY = slideshowView.CREATED_BY;
slideshow.CREATED_TIME = slideshowView.CREATED_TIME;
slideshow.ROW_STATUS = eStat.fg.IsActive;
rs = repo.Add(slideshow);
if (rs.IsSuccess)
{
rs.SetSuccessStatus();
}
else
{
rs.SetErrorStatus(eFunc.fg.SFailed);
}
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, null));
return(Content(HttpStatusCode.OK, resObj));
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, new Exception(eFunc.fg.SFailed)));
return(Content(HttpStatusCode.BadRequest, resObj));
}
}
public IHttpActionResult GridBind()
{
ApiResData res = new ApiResData();
try
{
List <TOURIS_TM_SOSMED> sosmed = repo.GridBind();
List <TOURIS_TV_SOSMED> sosmedViews = new List <TOURIS_TV_SOSMED>();
if (sosmed.Count > 0)
{
foreach (var item in sosmed)
{
TOURIS_TV_SOSMED sosmedView = new TOURIS_TV_SOSMED();
sosmedView.ID = item.ID;
sosmedView.TYPE = item.TYPE;
sosmedView.NAME = item.NAME;
sosmedView.DESCRIPTION = item.DESCRIPTION;
sosmedView.ICON = item.ICON;
sosmedView.URL = item.URL;
sosmedView.DATA_EMBED = item.DATA_EMBED;
sosmedView.HEIGHT = item.HEIGHT;
sosmedView.WIDTH = item.WIDTH;
sosmedView.DATA_WIDGET_ID = item.DATA_WIDGET_ID;
sosmedView.CREATED_BY = item.CREATED_BY;
sosmedView.CREATED_TIME = item.CREATED_TIME;
sosmedView.LAST_MODIFIED_BY = item.LAST_MODIFIED_BY;
sosmedView.LAST_MODIFIED_TIME = item.LAST_MODIFIED_TIME;
sosmedViews.Add(sosmedView);
}
rs.SetSuccessStatus();
}
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { sosmedViews }, 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.BadRequest, resObj));
}
}
public IHttpActionResult Add(TOURIS_TV_CONTACT_US contactUsView)
{
ApiResData res = new ApiResData();
try
{
if (!ModelState.IsValid)
{
rs.SetErrorStatus(eFunc.fg.SFailed);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, new Exception(eFunc.fg.DataIsntValid)));
return(Content(HttpStatusCode.NotFound, resObj));
}
TOURIS_TM_CONTACT_US contactUs = new TOURIS_TM_CONTACT_US();
contactUs.NAME_SENDER = contactUsView.NAME_SENDER;
contactUs.EMAIL_SENDER = contactUsView.EMAIL_SENDER;
contactUs.PHONE_SENDER = contactUsView.PHONE_SENDER;
contactUs.DESCRIPTION = contactUsView.DESCRIPTION;
contactUs.CREATED_BY = contactUsView.CREATED_BY;
contactUs.CREATED_TIME = contactUsView.CREATED_TIME;
contactUs.ROW_STATUS = eStat.fg.IsActive;
rs = repo.Add(contactUs);
if (rs.IsSuccess)
{
rs.SetSuccessStatus();
}
else
{
rs.SetErrorStatus(eFunc.fg.SFailed);
}
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, null));
return(Content(HttpStatusCode.OK, resObj));
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, new Exception(eFunc.fg.SFailed)));
return(Content(HttpStatusCode.BadRequest, resObj));
}
}
public IHttpActionResult Add(TOURIS_TV_PROVINCE provinceView)
{
ApiResData res = new ApiResData();
try
{
if (!ModelState.IsValid)
{
rs.SetErrorStatus(eFunc.fg.SFailed);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, new Exception(eFunc.fg.DataIsntValid)));
return(Content(HttpStatusCode.NotFound, resObj));
}
TOURIS_TM_PROVINCE province = new TOURIS_TM_PROVINCE();
province.COUNTRY_ID = provinceView.COUNTRY_ID;
province.PROVINCE_CODE = provinceView.PROVINCE_CODE;
province.PROVINCE_NAME = provinceView.PROVINCE_NAME;
province.PROVINCE_DESCRIPTION = provinceView.PROVINCE_DESCRIPTION;
province.CREATED_BY = provinceView.CREATED_BY;
province.CREATED_TIME = provinceView.CREATED_TIME;
province.ROW_STATUS = eStat.fg.IsActive;
rs = repo.Add(province);
if (rs.IsSuccess)
{
rs.SetSuccessStatus();
}
else
{
rs.SetErrorStatus(eFunc.fg.SFailed);
}
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, null));
return(Content(HttpStatusCode.OK, resObj));
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, new Exception(eFunc.fg.SFailed)));
return(Content(HttpStatusCode.BadRequest, resObj));
}
}
public IHttpActionResult Add(TOURIS_TV_DISTRICT districtView)
{
ApiResData res = new ApiResData();
try
{
if (!ModelState.IsValid)
{
rs.SetErrorStatus(eFunc.fg.SFailed);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, new Exception(eFunc.fg.DataIsntValid)));
return(Content(HttpStatusCode.NotFound, resObj));
}
TOURIS_TM_DISTRICT district = new TOURIS_TM_DISTRICT();
district.CITY_ID = districtView.CITY_ID;
district.DISTRICT_CODE = districtView.DISTRICT_CODE;
district.DISTRICT_NAME = districtView.DISTRICT_NAME;
district.DISTRICT_DESCRIPTION = districtView.DISTRICT_DESCRIPTION;
district.CREATED_BY = districtView.CREATED_BY;
district.CREATED_TIME = districtView.CREATED_TIME;
district.ROW_STATUS = eStat.fg.IsActive;
rs = repo.Add(district);
if (rs.IsSuccess)
{
rs.SetSuccessStatus();
}
else
{
rs.SetErrorStatus(eFunc.fg.SFailed);
}
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, null));
return(Content(HttpStatusCode.OK, resObj));
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, new Exception(eFunc.fg.SFailed)));
return(Content(HttpStatusCode.BadRequest, resObj));
}
}
public IHttpActionResult Edit(TOURIS_TV_CITY cityView)
{
ApiResData res = new ApiResData();
try
{
if (!ModelState.IsValid)
{
rs.SetErrorStatus(eFunc.fg.SFailed);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Edit, new Exception(eFunc.fg.DataIsntValid)));
return(Content(HttpStatusCode.NotFound, resObj));
}
TOURIS_TM_CITY city = new TOURIS_TM_CITY();
city.ID = cityView.ID;
city.PROVINCE_ID = cityView.PROVINCE_ID;
city.CITY_CODE = cityView.CITY_CODE;
city.CITY_NAME = cityView.CITY_NAME;
city.CITY_DESCRIPTION = cityView.CITY_DESCRIPTION;
city.LAST_MODIFIED_TIME = cityView.LAST_MODIFIED_TIME;
city.LAST_MODIFIED_BY = cityView.LAST_MODIFIED_BY;
rs = repo.Edit(city);
if (rs.IsSuccess)
{
rs.SetSuccessStatus();
}
else
{
rs.SetErrorStatus(eFunc.fg.SFailed);
}
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Edit, null));
return(Content(HttpStatusCode.OK, resObj));
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Edit, new Exception(eFunc.fg.EFailed)));
return(Content(HttpStatusCode.BadRequest, resObj));
}
}
public IHttpActionResult Edit(TOURIS_TV_SUB_CATEGORY_PHOTO subCategoryPhotoView)
{
ApiResData res = new ApiResData();
try
{
if (!ModelState.IsValid)
{
rs.SetErrorStatus(eFunc.fg.SFailed);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Edit, new Exception(eFunc.fg.DataIsntValid)));
return(Content(HttpStatusCode.NotFound, resObj));
}
TOURIS_TM_SUB_CATEGORY_PHOTO subCategoryPhoto = new TOURIS_TM_SUB_CATEGORY_PHOTO();
subCategoryPhoto.ID = subCategoryPhotoView.ID;
subCategoryPhoto.SUB_CATEGORY_ID = subCategoryPhotoView.SUB_CATEGORY_ID;
subCategoryPhoto.PHOTO_NAME = subCategoryPhotoView.PHOTO_NAME;
subCategoryPhoto.PHOTO_DESCRIPTION = subCategoryPhotoView.PHOTO_DESCRIPTION;
subCategoryPhoto.PHOTO_PATH = subCategoryPhotoView.PHOTO_PATH;
subCategoryPhoto.LAST_MODIFIED_TIME = subCategoryPhotoView.LAST_MODIFIED_TIME;
subCategoryPhoto.LAST_MODIFIED_BY = subCategoryPhotoView.LAST_MODIFIED_BY;
rs = repo.Edit(subCategoryPhoto);
if (rs.IsSuccess)
{
rs.SetSuccessStatus();
}
else
{
rs.SetErrorStatus(eFunc.fg.SFailed);
}
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Edit, null));
return(Content(HttpStatusCode.OK, resObj));
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Edit, new Exception(eFunc.fg.EFailed)));
return(Content(HttpStatusCode.BadRequest, resObj));
}
}
public IHttpActionResult Edit(TOURIS_TV_DISTRICT ProvinceView)
{
ApiResData res = new ApiResData();
try
{
if (!ModelState.IsValid)
{
rs.SetErrorStatus(eFunc.fg.SFailed);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Edit, new Exception(eFunc.fg.DataIsntValid)));
return(Content(HttpStatusCode.NotFound, resObj));
}
TOURIS_TM_DISTRICT district = new TOURIS_TM_DISTRICT();
district.ID = ProvinceView.ID;
district.CITY_ID = ProvinceView.CITY_ID;
district.DISTRICT_CODE = ProvinceView.DISTRICT_CODE;
district.DISTRICT_NAME = ProvinceView.DISTRICT_NAME;
district.DISTRICT_DESCRIPTION = ProvinceView.DISTRICT_DESCRIPTION;
district.LAST_MODIFIED_TIME = ProvinceView.LAST_MODIFIED_TIME;
district.LAST_MODIFIED_BY = ProvinceView.LAST_MODIFIED_BY;
rs = repo.Edit(district);
if (rs.IsSuccess)
{
rs.SetSuccessStatus();
}
else
{
rs.SetErrorStatus(eFunc.fg.SFailed);
}
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Edit, null));
return(Content(HttpStatusCode.OK, resObj));
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Edit, new Exception(eFunc.fg.EFailed)));
return(Content(HttpStatusCode.BadRequest, resObj));
}
}
public IHttpActionResult Add(TOURIS_TV_MENU menuView)
{
ApiResData res = new ApiResData();
try
{
if (!ModelState.IsValid)
{
rs.SetErrorStatus(eFunc.fg.SFailed);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, new Exception(eFunc.fg.DataIsntValid)));
return(Content(HttpStatusCode.NotFound, resObj));
}
TOURIS_TM_MENU menu = new TOURIS_TM_MENU();
menu.MENU_NAME = menuView.MENU_NAME;
menu.MENU_DESCRIPTION = menuView.MENU_DESCRIPTION;
menu.MENU_PARENT_ID = menuView.MENU_PARENT_ID;
menu.CREATED_BY = menuView.CREATED_BY;
menu.CREATED_TIME = menuView.CREATED_TIME;
menu.ROW_STATUS = eStat.fg.IsActive;
rs = repo.Add(menu);
if (rs.IsSuccess)
{
rs.SetSuccessStatus();
}
else
{
rs.SetErrorStatus(eFunc.fg.SFailed);
}
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, null));
return(Content(HttpStatusCode.OK, resObj));
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
resObj = JObject.FromObject(res.ResCUD(new object[] { rs }, eFunc.fg.Save, new Exception(eFunc.fg.SFailed)));
return(Content(HttpStatusCode.BadRequest, resObj));
}
}
public IHttpActionResult GridBind()
{
ApiResData res = new ApiResData();
try
{
List <TOURIS_TM_DISTRICT> districts = repo.GridBind();
List <TOURIS_TV_DISTRICT> districtViews = new List <TOURIS_TV_DISTRICT>();
if (districts.Count > 0)
{
foreach (var item in districts)
{
TOURIS_TV_DISTRICT districtView = new TOURIS_TV_DISTRICT();
districtView.ID = item.ID;
districtView.CITY_ID = item.CITY_ID;
districtView.PROVINCE_NAME = item.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.PROVINCE_NAME;
districtView.COUNTRY_NAME = item.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.TOURIS_TM_COUNTRY.COUNTRY_NAME;
districtView.CITY_NAME = item.TOURIS_TM_CITY.CITY_NAME;
districtView.DISTRICT_CODE = item.DISTRICT_CODE;
districtView.DISTRICT_NAME = item.DISTRICT_NAME;
districtView.DISTRICT_DESCRIPTION = item.DISTRICT_DESCRIPTION;
districtView.CREATED_BY = item.CREATED_BY;
districtView.CREATED_TIME = item.CREATED_TIME;
districtView.LAST_MODIFIED_BY = item.LAST_MODIFIED_BY;
districtView.LAST_MODIFIED_TIME = item.LAST_MODIFIED_TIME;
districtViews.Add(districtView);
}
rs.SetSuccessStatus();
}
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { districtViews }, 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.BadRequest, resObj));
}
}
public IHttpActionResult GridBind()
{
ApiResData res = new ApiResData();
try
{
List <TOURIS_TM_CATEGORY> categories = repo.GridBind();
List <TOURIS_TV_CATEGORY> categoryViews = new List <TOURIS_TV_CATEGORY>();
if (categories.Count > 0)
{
foreach (var item in categories)
{
TOURIS_TV_CATEGORY categoryView = new TOURIS_TV_CATEGORY();
categoryView.ID = item.ID;
categoryView.CATEGORY_CODE = item.CATEGORY_CODE;
categoryView.CATEGORY_NAME = item.CATEGORY_NAME;
categoryView.CATEGORY_DESCRIPTION = item.CATEGORY_DESCRIPTION;
categoryView.URL = item.URL;
categoryView.CLASS = item.CLASS;
categoryView.PHOTO_PATH = item.PHOTO_PATH;
categoryView.CREATED_BY = item.CREATED_BY;
categoryView.CREATED_TIME = item.CREATED_TIME;
categoryView.LAST_MODIFIED_BY = item.LAST_MODIFIED_BY;
categoryView.LAST_MODIFIED_TIME = item.LAST_MODIFIED_TIME;
categoryViews.Add(categoryView);
}
rs.SetSuccessStatus();
}
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { categoryViews }, 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.BadRequest, resObj));
}
}
public IHttpActionResult RetrieveData(int id)
{
ApiResData res = new ApiResData();
try
{
TOURIS_TM_VILLAGE village = repo.Retrieve(id);
TOURIS_TV_VILLAGE villageView = new TOURIS_TV_VILLAGE();
if (village != null)
{
villageView.ID = village.ID;
villageView.COUNTRY_ID = village.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.TOURIS_TM_COUNTRY.ID;
villageView.COUNTRY_NAME = village.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.TOURIS_TM_COUNTRY.COUNTRY_NAME;
villageView.PROVINCE_ID = village.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.ID;
villageView.PROVINCE_NAME = village.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.PROVINCE_NAME;
villageView.CITY_ID = village.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.ID;
villageView.CITY_NAME = village.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.CITY_NAME;
villageView.DISTRICT_ID = village.DISTRICT_ID;
villageView.DISTRICT_NAME = village.TOURIS_TM_DISTRICT.DISTRICT_NAME;
villageView.VILLAGE_CODE = village.VILLAGE_CODE;
villageView.VILLAGE_NAME = village.VILLAGE_NAME;
villageView.VILLAGE_DESCRIPTION = village.VILLAGE_DESCRIPTION;
villageView.CREATED_BY = village.CREATED_BY;
villageView.CREATED_TIME = village.CREATED_TIME;
villageView.LAST_MODIFIED_BY = village.LAST_MODIFIED_BY;
villageView.LAST_MODIFIED_TIME = village.LAST_MODIFIED_TIME;
rs.SetSuccessStatus();
}
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { villageView }, 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.BadRequest, resObj));
}
}
public IHttpActionResult GetCityByProvinceId(int id)
{
ApiResData res = new ApiResData();
try
{
List <TOURIS_TM_CITY> cities = repo.GetCityByProvinceId(id);
List <TOURIS_TV_CITY> cityViews = new List <TOURIS_TV_CITY>();
if (cities.Count > 0)
{
foreach (var item in cities)
{
TOURIS_TV_CITY cityView = new TOURIS_TV_CITY();
cityView.ID = item.ID;
cityView.PROVINCE_ID = item.PROVINCE_ID;
cityView.PROVINCE_NAME = item.TOURIS_TM_PROVINCE.PROVINCE_NAME;
cityView.COUNTRY_NAME = item.TOURIS_TM_PROVINCE.TOURIS_TM_COUNTRY.COUNTRY_NAME;
cityView.CITY_CODE = item.CITY_CODE;
cityView.CITY_NAME = item.CITY_NAME;
cityView.CITY_DESCRIPTION = item.CITY_DESCRIPTION;
cityView.CREATED_BY = item.CREATED_BY;
cityView.CREATED_TIME = item.CREATED_TIME;
cityView.LAST_MODIFIED_BY = item.LAST_MODIFIED_BY;
cityView.LAST_MODIFIED_TIME = item.LAST_MODIFIED_TIME;
cityViews.Add(cityView);
}
rs.SetSuccessStatus();
}
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { cityViews }, 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));
}
}
public IHttpActionResult GridBind()
{
ApiResData res = new ApiResData();
try
{
List <TOURIS_TM_PROVINCE> countries = repo.GridBind();
List <TOURIS_TV_PROVINCE> provinceViews = new List <TOURIS_TV_PROVINCE>();
if (countries.Count > 0)
{
foreach (var item in countries)
{
TOURIS_TV_PROVINCE provinceView = new TOURIS_TV_PROVINCE();
provinceView.ID = item.ID;
provinceView.COUNTRY_ID = item.COUNTRY_ID;
provinceView.COUNTRY_NAME = item.TOURIS_TM_COUNTRY.COUNTRY_NAME;
provinceView.PROVINCE_CODE = item.PROVINCE_CODE;
provinceView.PROVINCE_NAME = item.PROVINCE_NAME;
provinceView.PROVINCE_DESCRIPTION = item.PROVINCE_DESCRIPTION;
provinceView.CREATED_BY = item.CREATED_BY;
provinceView.CREATED_TIME = item.CREATED_TIME;
provinceView.LAST_MODIFIED_BY = item.LAST_MODIFIED_BY;
provinceView.LAST_MODIFIED_TIME = item.LAST_MODIFIED_TIME;
provinceViews.Add(provinceView);
}
rs.SetSuccessStatus();
}
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { provinceViews }, 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));
}
}
public IHttpActionResult GridBind()
{
ApiResData res = new ApiResData();
try
{
List <TOURIS_TM_SLIDESHOW> countries = repo.GridBind();
List <TOURIS_TV_SLIDESHOW> slideshowViews = new List <TOURIS_TV_SLIDESHOW>();
if (countries.Count > 0)
{
foreach (var item in countries)
{
TOURIS_TV_SLIDESHOW slideshowView = new TOURIS_TV_SLIDESHOW();
slideshowView.ID = item.ID;
slideshowView.TITTLE = item.TITTLE;
slideshowView.CONTENT_DESCRIPTION = item.CONTENT_DESCRIPTION;
slideshowView.CLASS = item.CLASS;
slideshowView.PHOTO_PATH = item.PHOTO_PATH;
slideshowView.URL = item.URL;
slideshowView.CREATED_BY = item.CREATED_BY;
slideshowView.CREATED_TIME = item.CREATED_TIME;
slideshowView.LAST_MODIFIED_BY = item.LAST_MODIFIED_BY;
slideshowView.LAST_MODIFIED_TIME = item.LAST_MODIFIED_TIME;
slideshowViews.Add(slideshowView);
}
rs.SetSuccessStatus();
}
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { slideshowViews }, 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.BadRequest, resObj));
}
}
