public IHttpActionResult RetrieveData(int id) { ApiResData res = new ApiResData(); try { TOURIS_TM_PROVINCE province = repo.Retrieve(id); TOURIS_TV_PROVINCE provinceView = new TOURIS_TV_PROVINCE(); if (province != null) { provinceView.ID = province.ID; provinceView.COUNTRY_ID = province.COUNTRY_ID; provinceView.COUNTRY_NAME = province.TOURIS_TM_COUNTRY.COUNTRY_NAME; provinceView.PROVINCE_CODE = province.PROVINCE_CODE; provinceView.PROVINCE_NAME = province.PROVINCE_NAME; provinceView.PROVINCE_DESCRIPTION = province.PROVINCE_DESCRIPTION; provinceView.CREATED_BY = province.CREATED_BY; provinceView.CREATED_TIME = province.CREATED_TIME; provinceView.LAST_MODIFIED_BY = province.LAST_MODIFIED_BY; provinceView.LAST_MODIFIED_TIME = province.LAST_MODIFIED_TIME; rs.SetSuccessStatus(); } resObj = JObject.FromObject(res.ResGetDataTable(new object[] { provinceView }, 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 ResultStatus Add(TOURIS_TM_PROVINCE province) { try { _ctx.TOURIS_TM_PROVINCE.Add(province); _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public IHttpActionResult Add(TOURIS_TV_PROVINCE provinceView) { 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_PROVINCE province = new TOURIS_TM_PROVINCE(); province.COUNTRY_ID = provinceView.COUNTRY_ID; province.PROVINCE_CODE = provinceView.PROVINCE_CODE; province.PROVINCE_NAME = provinceView.PROVINCE_NAME; province.PROVINCE_DESCRIPTION = provinceView.PROVINCE_DESCRIPTION; province.CREATED_BY = provinceView.CREATED_BY; province.CREATED_TIME = provinceView.CREATED_TIME; province.ROW_STATUS = eStat.fg.IsActive; rs = repo.Add(province); 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_PROVINCE province = _ctx.TOURIS_TM_PROVINCE.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_PROVINCE province) { try { TOURIS_TM_PROVINCE provinceNew = _ctx.TOURIS_TM_PROVINCE.Find(province.ID); provinceNew.COUNTRY_ID = province.COUNTRY_ID; provinceNew.PROVINCE_CODE = province.PROVINCE_CODE; provinceNew.PROVINCE_NAME = province.PROVINCE_NAME; provinceNew.PROVINCE_DESCRIPTION = province.PROVINCE_DESCRIPTION; provinceNew.LAST_MODIFIED_TIME = province.LAST_MODIFIED_TIME; provinceNew.LAST_MODIFIED_BY = province.LAST_MODIFIED_BY; _ctx.Entry(provinceNew).State = System.Data.Entity.EntityState.Modified; _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }