public ActionResult ActionEdit(TOURIS_TV_VILLAGE villageView)
{
try
{
villageView.LAST_MODIFIED_BY = CurrentUser.GetCurrentUserId();
villageView.LAST_MODIFIED_TIME = CurrentUser.GetCurrentDateTime();
rs = JsonConvert.DeserializeObject <ResultStatus>(ParsingObject.RequestData(villageView, "Village", "Edit", EnumList.IHttpMethod.Post.ToString()));
if (rs.IsSuccess)
{
rs.SetSuccessStatus("Data has been edited successfully");
TempData["msgSuccess"] = rs.MessageText;
}
else
{
rs.SetErrorStatus("Data failed to edited");
TempData["msgError"] = rs.MessageText;
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.Message);
rs.SetErrorStatus("Data failed to edited");
TempData["msgError"] = rs.MessageText;
}
return(RedirectToAction("Index"));
}
public ActionResult Detail(int id)
{
TOURIS_TV_VILLAGE villageView = new TOURIS_TV_VILLAGE();
TOURIS_TV_VILLAGE villageRes = new TOURIS_TV_VILLAGE();
villageView.ID = id;
villageRes = JsonConvert.DeserializeObject <TOURIS_TV_VILLAGE>(ParsingObject.RequestData(id, "Village", "RetrieveData", EnumList.IHttpMethod.Put.ToString()));
return(View(villageRes));
}
public static SelectList GetVillageByDistrictId(int districtId)
{
List <TOURIS_TV_VILLAGE> villages = JsonConvert.DeserializeObject <List <TOURIS_TV_VILLAGE> >(ParsingObject.RequestData(districtId, "Village", "GetVillageByDistrictId", EnumList.IHttpMethod.Put.ToString()));
TOURIS_TV_VILLAGE village = new TOURIS_TV_VILLAGE {
ID = 0, DISTRICT_NAME = "Select District :"
};
villages.Add(village);
var villageList = villages.OrderBy(x => x.ID);
SelectList selectList = new SelectList(villageList, "ID", "VILLAGE_NAME");
return(selectList);
}
public static SelectList GetVillageList()
{
List <TOURIS_TV_VILLAGE> villages = JsonConvert.DeserializeObject <List <TOURIS_TV_VILLAGE> >(ParsingObject.RequestData(null, "Village", "GridBind", EnumList.IHttpMethod.Get.ToString()));
TOURIS_TV_VILLAGE village = new TOURIS_TV_VILLAGE {
ID = 0, VILLAGE_NAME = "Select Village :"
};
villages.Add(village);
var villageList = villages.OrderBy(x => x.ID);
SelectList selectList = new SelectList(villageList, "ID", "VILLAGE_NAME");
return(selectList);
}
public ActionResult Edit(int id)
{
TOURIS_TV_VILLAGE villageView = new TOURIS_TV_VILLAGE();
TOURIS_TV_VILLAGE villageRes = new TOURIS_TV_VILLAGE();
villageView.ID = id;
villageRes = JsonConvert.DeserializeObject <TOURIS_TV_VILLAGE>(ParsingObject.RequestData(id, "Village", "RetrieveData", EnumList.IHttpMethod.Put.ToString()));
ViewBag.GetCountryList = Dropdown.GetCountryList();
ViewBag.GetProvinceList = Dropdown.GetProvinceListByCountryId(villageRes.COUNTRY_ID);
ViewBag.GetCityList = Dropdown.GetCityListByProvinceId(villageRes.PROVINCE_ID);
ViewBag.GetDistrictList = Dropdown.GetDistrictByCityId(villageRes.CITY_ID);
return(View(villageRes));
}
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_VILLAGE villageView)
{
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_VILLAGE village = new TOURIS_TM_VILLAGE();
village.DISTRICT_ID = villageView.DISTRICT_ID;
village.VILLAGE_CODE = villageView.VILLAGE_CODE;
village.VILLAGE_NAME = villageView.VILLAGE_NAME;
village.VILLAGE_DESCRIPTION = villageView.VILLAGE_DESCRIPTION;
village.CREATED_BY = villageView.CREATED_BY;
village.CREATED_TIME = villageView.CREATED_TIME;
village.ROW_STATUS = eStat.fg.IsActive;
rs = repo.Add(village);
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_VILLAGE 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_VILLAGE village = new TOURIS_TM_VILLAGE();
village.ID = ProvinceView.ID;
village.DISTRICT_ID = ProvinceView.DISTRICT_ID;
village.VILLAGE_CODE = ProvinceView.VILLAGE_CODE;
village.VILLAGE_NAME = ProvinceView.VILLAGE_NAME;
village.VILLAGE_DESCRIPTION = ProvinceView.VILLAGE_DESCRIPTION;
village.LAST_MODIFIED_TIME = ProvinceView.LAST_MODIFIED_TIME;
village.LAST_MODIFIED_BY = ProvinceView.LAST_MODIFIED_BY;
rs = repo.Edit(village);
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 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));
}
}
