Esempio n. 1
0
        public ResultStatus Edit(TOURIS_TM_SOSMED sosmed)
        {
            try
            {
                TOURIS_TM_SOSMED sosmedNew = _ctx.TOURIS_TM_SOSMED.Find(sosmed.ID);
                sosmedNew.TYPE               = sosmed.TYPE;
                sosmedNew.NAME               = sosmed.NAME;
                sosmedNew.DESCRIPTION        = sosmed.DESCRIPTION;
                sosmedNew.ICON               = sosmed.ICON;
                sosmedNew.URL                = sosmed.URL;
                sosmedNew.DATA_EMBED         = sosmed.DATA_EMBED;
                sosmedNew.HEIGHT             = sosmed.HEIGHT;
                sosmedNew.WIDTH              = sosmed.WIDTH;
                sosmedNew.DATA_WIDGET_ID     = sosmed.DATA_WIDGET_ID;
                sosmedNew.LAST_MODIFIED_TIME = sosmed.LAST_MODIFIED_TIME;
                sosmedNew.LAST_MODIFIED_BY   = sosmed.LAST_MODIFIED_BY;
                _ctx.Entry(sosmedNew).State  = System.Data.Entity.EntityState.Modified;
                _ctx.SaveChanges();
                rs.SetSuccessStatus();
            }
            catch (Exception ex)
            {
                rs.SetErrorStatus(ex.Message);
            }

            return(rs);
        }
Esempio n. 2
0
        public ResultStatus Add(TOURIS_TM_SOSMED sosmed)
        {
            try
            {
                _ctx.TOURIS_TM_SOSMED.Add(sosmed);
                _ctx.SaveChanges();
                rs.SetSuccessStatus();
            }
            catch (Exception ex)
            {
                rs.SetErrorStatus(ex.Message);
            }

            return(rs);
        }
        public IHttpActionResult Add(TOURIS_TV_SOSMED sosmedView)
        {
            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_SOSMED sosmed = new TOURIS_TM_SOSMED();
                sosmed.TYPE           = sosmedView.TYPE;
                sosmed.NAME           = sosmedView.NAME;
                sosmed.DESCRIPTION    = sosmedView.DESCRIPTION;
                sosmed.ICON           = sosmedView.ICON;
                sosmed.URL            = sosmedView.URL;
                sosmed.DATA_EMBED     = sosmedView.DATA_EMBED;
                sosmed.HEIGHT         = sosmedView.HEIGHT;
                sosmed.WIDTH          = sosmedView.WIDTH;
                sosmed.DATA_WIDGET_ID = sosmedView.DATA_WIDGET_ID;
                sosmed.CREATED_BY     = sosmedView.CREATED_BY;
                sosmed.CREATED_TIME   = sosmedView.CREATED_TIME;
                sosmed.ROW_STATUS     = eStat.fg.IsActive;

                rs = repo.Add(sosmed);
                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));
            }
        }
Esempio n. 4
0
        public ResultStatus Delete(int id, string modifiedBy, DateTime modifiedTime)
        {
            try
            {
                TOURIS_TM_SOSMED sosmed = _ctx.TOURIS_TM_SOSMED.Find(id);
                sosmed.LAST_MODIFIED_TIME = modifiedTime;
                sosmed.LAST_MODIFIED_BY   = modifiedBy;
                sosmed.ROW_STATUS         = eStat.fg.NotActive;

                _ctx.Entry(sosmed).State = 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_SOSMED sosmed     = repo.Retrieve(id);
                TOURIS_TV_SOSMED sosmedView = new TOURIS_TV_SOSMED();

                if (sosmed != null)
                {
                    sosmedView.ID                 = sosmed.ID;
                    sosmedView.TYPE               = sosmed.TYPE;
                    sosmedView.NAME               = sosmed.NAME;
                    sosmedView.DESCRIPTION        = sosmed.DESCRIPTION;
                    sosmedView.ICON               = sosmed.ICON;
                    sosmedView.URL                = sosmed.URL;
                    sosmedView.DATA_EMBED         = sosmed.DATA_EMBED;
                    sosmedView.HEIGHT             = sosmed.HEIGHT;
                    sosmedView.WIDTH              = sosmed.WIDTH;
                    sosmedView.DATA_WIDGET_ID     = sosmed.DATA_WIDGET_ID;
                    sosmedView.CREATED_BY         = sosmed.CREATED_BY;
                    sosmedView.CREATED_TIME       = sosmed.CREATED_TIME;
                    sosmedView.LAST_MODIFIED_BY   = sosmed.LAST_MODIFIED_BY;
                    sosmedView.LAST_MODIFIED_TIME = sosmed.LAST_MODIFIED_TIME;
                    rs.SetSuccessStatus();
                }
                resObj = JObject.FromObject(res.ResGetDataTable(new object[] { sosmedView }, 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));
            }
        }