public ResultStatus Add(TOURIS_TM_CITY city) { try { _ctx.TOURIS_TM_CITY.Add(city); _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
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 ResultStatus Delete(int id, string modifiedBy, DateTime modifiedTime) { try { TOURIS_TM_CITY province = _ctx.TOURIS_TM_CITY.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 ResultStatus Edit(TOURIS_TM_CITY city) { try { TOURIS_TM_CITY cityNew = _ctx.TOURIS_TM_CITY.Find(city.ID); cityNew.PROVINCE_ID = city.PROVINCE_ID; cityNew.CITY_CODE = city.CITY_CODE; cityNew.CITY_NAME = city.CITY_NAME; cityNew.CITY_DESCRIPTION = city.CITY_DESCRIPTION; cityNew.LAST_MODIFIED_TIME = city.LAST_MODIFIED_TIME; cityNew.LAST_MODIFIED_BY = city.LAST_MODIFIED_BY; _ctx.Entry(cityNew).State = System.Data.Entity.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_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)); } }