public IHttpActionResult RetrieveData(int id) { ApiResData res = new ApiResData(); try { TOURIS_TM_SUB_CATEGORY_PHOTO subCategoryPhoto = repo.Retrieve(id); TOURIS_TV_SUB_CATEGORY_PHOTO subCategoryPhotoView = new TOURIS_TV_SUB_CATEGORY_PHOTO(); if (subCategoryPhoto != null) { subCategoryPhotoView.ID = subCategoryPhoto.ID; subCategoryPhotoView.SUB_CATEGORY_ID = subCategoryPhoto.SUB_CATEGORY_ID; subCategoryPhotoView.SUB_CATEGORY_NAME = subCategoryPhoto.TOURIS_TM_SUB_CATEGORY.SUB_CATEGORY_NAME; subCategoryPhotoView.PHOTO_NAME = subCategoryPhoto.PHOTO_NAME; subCategoryPhotoView.PHOTO_DESCRIPTION = subCategoryPhoto.PHOTO_DESCRIPTION; subCategoryPhotoView.PHOTO_PATH = subCategoryPhoto.PHOTO_PATH; subCategoryPhotoView.CREATED_BY = subCategoryPhoto.CREATED_BY; subCategoryPhotoView.CREATED_TIME = subCategoryPhoto.CREATED_TIME; subCategoryPhotoView.LAST_MODIFIED_BY = subCategoryPhoto.LAST_MODIFIED_BY; subCategoryPhotoView.LAST_MODIFIED_TIME = subCategoryPhoto.LAST_MODIFIED_TIME; rs.SetSuccessStatus(); } resObj = JObject.FromObject(res.ResGetDataTable(new object[] { subCategoryPhotoView }, 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_SUB_CATEGORY_PHOTO subCategoryPhoto) { try { _ctx.TOURIS_TM_SUB_CATEGORY_PHOTO.Add(subCategoryPhoto); _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public IHttpActionResult Add(TOURIS_TV_SUB_CATEGORY_PHOTO subCategoryPhotoView) { 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_SUB_CATEGORY_PHOTO subCategoryPhoto = new TOURIS_TM_SUB_CATEGORY_PHOTO(); subCategoryPhoto.SUB_CATEGORY_ID = subCategoryPhotoView.SUB_CATEGORY_ID; subCategoryPhoto.PHOTO_NAME = subCategoryPhotoView.PHOTO_NAME; subCategoryPhoto.PHOTO_DESCRIPTION = subCategoryPhotoView.PHOTO_DESCRIPTION; subCategoryPhoto.PHOTO_PATH = subCategoryPhotoView.PHOTO_PATH; subCategoryPhoto.CREATED_BY = subCategoryPhotoView.CREATED_BY; subCategoryPhoto.CREATED_TIME = subCategoryPhotoView.CREATED_TIME; subCategoryPhoto.ROW_STATUS = eStat.fg.IsActive; rs = repo.Add(subCategoryPhoto); 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_SUB_CATEGORY_PHOTO subCategoryPhoto = _ctx.TOURIS_TM_SUB_CATEGORY_PHOTO.Find(id); subCategoryPhoto.LAST_MODIFIED_TIME = modifiedTime; subCategoryPhoto.LAST_MODIFIED_BY = modifiedBy; subCategoryPhoto.ROW_STATUS = eStat.fg.NotActive; _ctx.Entry(subCategoryPhoto).State = EntityState.Modified; _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public ResultStatus Edit(TOURIS_TM_SUB_CATEGORY_PHOTO subCategoryPhoto) { try { TOURIS_TM_SUB_CATEGORY_PHOTO subCategoryPhotoNew = _ctx.TOURIS_TM_SUB_CATEGORY_PHOTO.Find(subCategoryPhoto.ID); subCategoryPhotoNew.SUB_CATEGORY_ID = subCategoryPhoto.SUB_CATEGORY_ID; subCategoryPhotoNew.PHOTO_NAME = subCategoryPhoto.PHOTO_NAME; subCategoryPhotoNew.PHOTO_DESCRIPTION = subCategoryPhoto.PHOTO_DESCRIPTION; subCategoryPhotoNew.PHOTO_PATH = subCategoryPhoto.PHOTO_PATH; subCategoryPhotoNew.LAST_MODIFIED_TIME = subCategoryPhoto.LAST_MODIFIED_TIME; subCategoryPhotoNew.LAST_MODIFIED_BY = subCategoryPhoto.LAST_MODIFIED_BY; _ctx.Entry(subCategoryPhotoNew).State = System.Data.Entity.EntityState.Modified; _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }