public ResultStatus Add(TOURIS_TM_VILLAGE village)
{
try
{
_ctx.TOURIS_TM_VILLAGE.Add(village);
_ctx.SaveChanges();
rs.SetSuccessStatus();
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
}
return(rs);
}
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 ResultStatus Delete(int id, string modifiedBy, DateTime modifiedTime)
{
try
{
TOURIS_TM_VILLAGE province = _ctx.TOURIS_TM_VILLAGE.Find(id);
province.LAST_MODIFIED_TIME = modifiedTime;
province.LAST_MODIFIED_BY = modifiedBy;
province.ROW_STATUS = eStat.fg.NotActive;
_ctx.Entry(province).State = EntityState.Modified;
_ctx.SaveChanges();
rs.SetSuccessStatus();
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
}
return(rs);
}
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 ResultStatus Edit(TOURIS_TM_VILLAGE village)
{
try
{
TOURIS_TM_VILLAGE villageNew = _ctx.TOURIS_TM_VILLAGE.Find(village.ID);
villageNew.DISTRICT_ID = village.DISTRICT_ID;
villageNew.VILLAGE_CODE = village.VILLAGE_CODE;
villageNew.VILLAGE_NAME = village.VILLAGE_NAME;
villageNew.VILLAGE_DESCRIPTION = village.VILLAGE_DESCRIPTION;
villageNew.LAST_MODIFIED_TIME = village.LAST_MODIFIED_TIME;
villageNew.LAST_MODIFIED_BY = village.LAST_MODIFIED_BY;
_ctx.Entry(villageNew).State = System.Data.Entity.EntityState.Modified;
_ctx.SaveChanges();
rs.SetSuccessStatus();
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
}
return(rs);
}
