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