public IHttpActionResult RetrieveData(int id)
{
ApiResData res = new ApiResData();
try
{
TOURIS_TM_CATEGORY category = repo.Retrieve(id);
TOURIS_TV_CATEGORY categoryView = new TOURIS_TV_CATEGORY();
if (category != null)
{
categoryView.ID = category.ID;
categoryView.CATEGORY_CODE = category.CATEGORY_CODE;
categoryView.CATEGORY_NAME = category.CATEGORY_NAME;
categoryView.CATEGORY_DESCRIPTION = category.CATEGORY_DESCRIPTION;
categoryView.URL = category.URL;
categoryView.CLASS = category.CLASS;
categoryView.PHOTO_PATH = category.PHOTO_PATH;
categoryView.CREATED_BY = category.CREATED_BY;
categoryView.CREATED_TIME = category.CREATED_TIME;
categoryView.LAST_MODIFIED_BY = category.LAST_MODIFIED_BY;
categoryView.LAST_MODIFIED_TIME = category.LAST_MODIFIED_TIME;
if (category.TOURIS_TM_SUB_CATEGORY.Count > 0)
{
foreach (var item in category.TOURIS_TM_SUB_CATEGORY)
{
TOURIS_TV_SUB_CATEGORY subCategory = new TOURIS_TV_SUB_CATEGORY();
subCategory.ID = item.ID;
subCategory.ADDRESS = item.ADDRESS;
subCategory.CATEGORY_ID = item.CATEGORY_ID;
subCategory.END_TIME = item.END_TIME;
subCategory.START_TIME = item.START_TIME;
subCategory.SUB_CATEGORY_DESCRIPTION = item.SUB_CATEGORY_DESCRIPTION;
subCategory.SUB_CATEGORY_NAME = item.SUB_CATEGORY_NAME;
subCategory.VILLAGE_ID = item.VILLAGE_ID;
subCategory.PHOTO_PATH = item.PHOTO_PATH;
categoryView.TOURIS_TV_SUB_CATEGORY.Add(subCategory);
}
}
rs.SetSuccessStatus();
}
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { categoryView }, 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 Add(TOURIS_TM_CATEGORY category)
{
try
{
_ctx.TOURIS_TM_CATEGORY.Add(category);
_ctx.SaveChanges();
rs.SetSuccessStatus();
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
}
return(rs);
}
public IHttpActionResult Add(TOURIS_TV_CATEGORY categoryView)
{
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_CATEGORY category = new TOURIS_TM_CATEGORY();
category.CATEGORY_CODE = categoryView.CATEGORY_CODE;
category.CATEGORY_NAME = categoryView.CATEGORY_NAME;
category.CATEGORY_DESCRIPTION = categoryView.CATEGORY_DESCRIPTION;
category.URL = categoryView.URL;
category.CLASS = categoryView.CLASS;
category.PHOTO_PATH = categoryView.PHOTO_PATH;
category.CREATED_BY = categoryView.CREATED_BY;
category.CREATED_TIME = categoryView.CREATED_TIME;
category.ROW_STATUS = eStat.fg.IsActive;
rs = repo.Add(category);
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_CATEGORY category = _ctx.TOURIS_TM_CATEGORY.Find(id);
category.LAST_MODIFIED_TIME = modifiedTime;
category.LAST_MODIFIED_BY = modifiedBy;
category.ROW_STATUS = eStat.fg.NotActive;
_ctx.Entry(category).State = EntityState.Modified;
_ctx.SaveChanges();
rs.SetSuccessStatus();
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
}
return(rs);
}
public ResultStatus Edit(TOURIS_TM_CATEGORY category)
{
try
{
TOURIS_TM_CATEGORY categoryNew = _ctx.TOURIS_TM_CATEGORY.Find(category.ID);
categoryNew.CATEGORY_CODE = category.CATEGORY_CODE;
categoryNew.CATEGORY_NAME = category.CATEGORY_NAME;
categoryNew.CATEGORY_DESCRIPTION = category.CATEGORY_DESCRIPTION;
categoryNew.URL = category.URL;
categoryNew.CLASS = category.CLASS;
categoryNew.PHOTO_PATH = category.PHOTO_PATH;
categoryNew.LAST_MODIFIED_TIME = category.LAST_MODIFIED_TIME;
categoryNew.LAST_MODIFIED_BY = category.LAST_MODIFIED_BY;
_ctx.Entry(categoryNew).State = System.Data.Entity.EntityState.Modified;
_ctx.SaveChanges();
rs.SetSuccessStatus();
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
}
return(rs);
}