public ActionResult ActionEdit(TOURIS_TV_CITY cityView)
{
try
{
cityView.LAST_MODIFIED_BY = CurrentUser.GetCurrentUserId();
cityView.LAST_MODIFIED_TIME = CurrentUser.GetCurrentDateTime();
rs = JsonConvert.DeserializeObject <ResultStatus>(ParsingObject.RequestData(cityView, "City", "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_CITY cityView = new TOURIS_TV_CITY();
TOURIS_TV_CITY cityRes = new TOURIS_TV_CITY();
cityView.ID = id;
cityRes = JsonConvert.DeserializeObject <TOURIS_TV_CITY>(ParsingObject.RequestData(id, "City", "GetProvinceByCountryId", EnumList.IHttpMethod.Put.ToString()));
return(View(cityRes));
}
public ActionResult Edit(int id)
{
TOURIS_TV_CITY cityView = new TOURIS_TV_CITY();
TOURIS_TV_CITY cityRes = new TOURIS_TV_CITY();
cityView.ID = id;
cityRes = JsonConvert.DeserializeObject <TOURIS_TV_CITY>(ParsingObject.RequestData(id, "City", "RetrieveData", EnumList.IHttpMethod.Put.ToString()));
ViewBag.GetCountryList = Dropdown.GetCountryList();
ViewBag.GetProvinceList = Dropdown.GetProvinceListByCountryId(cityRes.COUNTRY_ID);
return(View(cityRes));
}
public static SelectList GetCityListByProvinceId(int provinceId)
{
List <TOURIS_TV_CITY> cities = JsonConvert.DeserializeObject <List <TOURIS_TV_CITY> >(ParsingObject.RequestData(provinceId, "City", "GetCityByProvinceId", EnumList.IHttpMethod.Put.ToString()));
TOURIS_TV_CITY city = new TOURIS_TV_CITY {
ID = 0, CITY_NAME = "Select City :"
};
cities.Add(city);
var cityList = cities.OrderBy(x => x.ID);
SelectList selectList = new SelectList(cityList, "ID", "CITY_NAME");
return(selectList);
}
public IHttpActionResult Add(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.Save, new Exception(eFunc.fg.DataIsntValid)));
return(Content(HttpStatusCode.NotFound, resObj));
}
TOURIS_TM_CITY city = new TOURIS_TM_CITY();
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.CREATED_BY = cityView.CREATED_BY;
city.CREATED_TIME = cityView.CREATED_TIME;
city.ROW_STATUS = eStat.fg.IsActive;
rs = repo.Add(city);
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_CITY> cities = repo.GridBind();
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.BadRequest, resObj));
}
}
public IHttpActionResult RetrieveData(int id)
{
ApiResData res = new ApiResData();
try
{
TOURIS_TM_CITY city = repo.Retrieve(id);
TOURIS_TV_CITY cityView = new TOURIS_TV_CITY();
if (city != null)
{
cityView.ID = city.ID;
cityView.PROVINCE_ID = city.PROVINCE_ID;
cityView.PROVINCE_NAME = city.TOURIS_TM_PROVINCE.PROVINCE_NAME;
cityView.COUNTRY_ID = city.TOURIS_TM_PROVINCE.TOURIS_TM_COUNTRY.ID;
cityView.COUNTRY_NAME = city.TOURIS_TM_PROVINCE.TOURIS_TM_COUNTRY.COUNTRY_NAME;
cityView.CITY_CODE = city.CITY_CODE;
cityView.CITY_NAME = city.CITY_NAME;
cityView.CITY_DESCRIPTION = city.CITY_DESCRIPTION;
cityView.CREATED_BY = city.CREATED_BY;
cityView.CREATED_TIME = city.CREATED_TIME;
cityView.LAST_MODIFIED_BY = city.LAST_MODIFIED_BY;
cityView.LAST_MODIFIED_TIME = city.LAST_MODIFIED_TIME;
rs.SetSuccessStatus();
}
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { cityView }, 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));
}
}
