public ResultStatus Edit(TOURIS_TM_SUB_CATEGORY subCategory)
{
try
{
TOURIS_TM_SUB_CATEGORY subCategoryNew = _ctx.TOURIS_TM_SUB_CATEGORY.Find(subCategory.ID);
subCategoryNew.CATEGORY_ID = subCategory.CATEGORY_ID;
subCategoryNew.VILLAGE_ID = subCategory.VILLAGE_ID;
subCategoryNew.ADDRESS = subCategory.ADDRESS;
subCategoryNew.SUB_CATEGORY_NAME = subCategory.SUB_CATEGORY_NAME;
subCategoryNew.SUB_CATEGORY_DESCRIPTION = subCategory.SUB_CATEGORY_DESCRIPTION;
subCategoryNew.START_TIME = subCategory.START_TIME;
subCategoryNew.END_TIME = subCategory.END_TIME;
subCategoryNew.PHOTO_PATH = subCategory.PHOTO_PATH;
subCategoryNew.LAST_MODIFIED_TIME = subCategory.LAST_MODIFIED_TIME;
subCategoryNew.LAST_MODIFIED_BY = subCategory.LAST_MODIFIED_BY;
_ctx.Entry(subCategoryNew).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_SUB_CATEGORY subCategory = repo.Retrieve(id);
TOURIS_TV_SUB_CATEGORY subCategoryView = new TOURIS_TV_SUB_CATEGORY();
if (subCategory != null)
{
subCategoryView.ID = subCategory.ID;
subCategoryView.CATEGORY_ID = subCategory.CATEGORY_ID;
subCategoryView.CATEGORY_NAME = subCategory.TOURIS_TM_CATEGORY.CATEGORY_NAME;
subCategoryView.COUNTRY_ID = subCategory.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.TOURIS_TM_COUNTRY.ID;
subCategoryView.COUNTRY_NAME = subCategory.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.TOURIS_TM_COUNTRY.COUNTRY_NAME;
subCategoryView.PROVINCE_ID = subCategory.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.ID;
subCategoryView.PROVINCE_NAME = subCategory.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.TOURIS_TM_PROVINCE.PROVINCE_NAME;
subCategoryView.CITY_ID = subCategory.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.ID;
subCategoryView.CITY_NAME = subCategory.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.TOURIS_TM_CITY.CITY_NAME;
subCategoryView.DISTRICT_ID = subCategory.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.ID;
subCategoryView.DISTRICT_NAME = subCategory.TOURIS_TM_VILLAGE.TOURIS_TM_DISTRICT.DISTRICT_NAME;
subCategoryView.VILLAGE_NAME = subCategory.TOURIS_TM_VILLAGE.VILLAGE_NAME;
subCategoryView.VILLAGE_ID = subCategory.VILLAGE_ID;
subCategoryView.SUB_CATEGORY_NAME = subCategory.SUB_CATEGORY_NAME;
subCategoryView.SUB_CATEGORY_DESCRIPTION = subCategory.SUB_CATEGORY_DESCRIPTION;
subCategoryView.ADDRESS = subCategory.ADDRESS;
subCategoryView.START_TIME = subCategory.START_TIME;
subCategoryView.END_TIME = subCategory.END_TIME;
subCategoryView.PHOTO_PATH = subCategory.PHOTO_PATH;
subCategoryView.LATITUDE = subCategory.LATITUDE;
subCategoryView.LONGITUDE = subCategory.LONGITUDE;
subCategoryView.CREATED_BY = subCategory.CREATED_BY;
subCategoryView.CREATED_TIME = subCategory.CREATED_TIME;
subCategoryView.LAST_MODIFIED_BY = subCategory.LAST_MODIFIED_BY;
subCategoryView.LAST_MODIFIED_TIME = subCategory.LAST_MODIFIED_TIME;
rs.SetSuccessStatus();
}
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { subCategoryView }, 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 IHttpActionResult Add(TOURIS_TV_SUB_CATEGORY subCategoryView)
{
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 subCategory = new TOURIS_TM_SUB_CATEGORY();
subCategory.CATEGORY_ID = subCategoryView.CATEGORY_ID;
subCategory.VILLAGE_ID = subCategoryView.VILLAGE_ID;
subCategory.SUB_CATEGORY_NAME = subCategoryView.SUB_CATEGORY_NAME;
subCategory.SUB_CATEGORY_DESCRIPTION = subCategoryView.SUB_CATEGORY_DESCRIPTION;
subCategory.START_TIME = subCategoryView.START_TIME;
subCategory.END_TIME = subCategoryView.END_TIME;
subCategory.PHOTO_PATH = subCategoryView.PHOTO_PATH;
subCategory.ADDRESS = subCategoryView.ADDRESS;
subCategory.LATITUDE = subCategoryView.LATITUDE;
subCategory.LONGITUDE = subCategoryView.LONGITUDE;
subCategory.CREATED_BY = subCategoryView.CREATED_BY;
subCategory.CREATED_TIME = subCategoryView.CREATED_TIME;
subCategory.ROW_STATUS = eStat.fg.IsActive;
rs = repo.Add(subCategory);
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 Add(TOURIS_TM_SUB_CATEGORY subCategory)
{
try
{
_ctx.TOURIS_TM_SUB_CATEGORY.Add(subCategory);
_ctx.SaveChanges();
rs.SetSuccessStatus();
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
}
return(rs);
}
public ResultStatus Delete(int id, string modifiedBy, DateTime modifiedTime)
{
try
{
TOURIS_TM_SUB_CATEGORY subCategory = _ctx.TOURIS_TM_SUB_CATEGORY.Find(id);
subCategory.LAST_MODIFIED_TIME = modifiedTime;
subCategory.LAST_MODIFIED_BY = modifiedBy;
subCategory.ROW_STATUS = eStat.fg.NotActive;
_ctx.Entry(subCategory).State = EntityState.Modified;
_ctx.SaveChanges();
rs.SetSuccessStatus();
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
}
return(rs);
}
