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