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); }