public ResultStatus Add(TOURIS_TM_CITY city)
{
try
{
_ctx.TOURIS_TM_CITY.Add(city);
_ctx.SaveChanges();
rs.SetSuccessStatus();
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
}
return(rs);
}
public IHttpActionResult Add(TOURIS_TV_CITY cityView)
{
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_CITY city = new TOURIS_TM_CITY();
city.PROVINCE_ID = cityView.PROVINCE_ID;
city.CITY_CODE = cityView.CITY_CODE;
city.CITY_NAME = cityView.CITY_NAME;
city.CITY_DESCRIPTION = cityView.CITY_DESCRIPTION;
city.CREATED_BY = cityView.CREATED_BY;
city.CREATED_TIME = cityView.CREATED_TIME;
city.ROW_STATUS = eStat.fg.IsActive;
rs = repo.Add(city);
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_CITY province = _ctx.TOURIS_TM_CITY.Find(id);
province.LAST_MODIFIED_TIME = modifiedTime;
province.LAST_MODIFIED_BY = modifiedBy;
province.ROW_STATUS = eStat.fg.NotActive;
_ctx.Entry(province).State = EntityState.Modified;
_ctx.SaveChanges();
rs.SetSuccessStatus();
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
}
return(rs);
}
public ResultStatus Edit(TOURIS_TM_CITY city)
{
try
{
TOURIS_TM_CITY cityNew = _ctx.TOURIS_TM_CITY.Find(city.ID);
cityNew.PROVINCE_ID = city.PROVINCE_ID;
cityNew.CITY_CODE = city.CITY_CODE;
cityNew.CITY_NAME = city.CITY_NAME;
cityNew.CITY_DESCRIPTION = city.CITY_DESCRIPTION;
cityNew.LAST_MODIFIED_TIME = city.LAST_MODIFIED_TIME;
cityNew.LAST_MODIFIED_BY = city.LAST_MODIFIED_BY;
_ctx.Entry(cityNew).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_CITY city = repo.Retrieve(id);
TOURIS_TV_CITY cityView = new TOURIS_TV_CITY();
if (city != null)
{
cityView.ID = city.ID;
cityView.PROVINCE_ID = city.PROVINCE_ID;
cityView.PROVINCE_NAME = city.TOURIS_TM_PROVINCE.PROVINCE_NAME;
cityView.COUNTRY_ID = city.TOURIS_TM_PROVINCE.TOURIS_TM_COUNTRY.ID;
cityView.COUNTRY_NAME = city.TOURIS_TM_PROVINCE.TOURIS_TM_COUNTRY.COUNTRY_NAME;
cityView.CITY_CODE = city.CITY_CODE;
cityView.CITY_NAME = city.CITY_NAME;
cityView.CITY_DESCRIPTION = city.CITY_DESCRIPTION;
cityView.CREATED_BY = city.CREATED_BY;
cityView.CREATED_TIME = city.CREATED_TIME;
cityView.LAST_MODIFIED_BY = city.LAST_MODIFIED_BY;
cityView.LAST_MODIFIED_TIME = city.LAST_MODIFIED_TIME;
rs.SetSuccessStatus();
}
resObj = JObject.FromObject(res.ResGetDataTable(new object[] { cityView }, 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));
}
}
