Пример #1
0
        public IHttpActionResult addone([FromBody] aspnetmodelView viewToAdd)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }
            aspnetmodel entityToAdd = new aspnetmodel();

            entityToAdd.ModelPk          = viewToAdd.ModelPk;
            entityToAdd.ModelName        = viewToAdd.ModelName;
            entityToAdd.ModelDescription = viewToAdd.ModelDescription;
            db.aspnetmodellDbSet.Add(entityToAdd);
            db.SaveChanges();

            aspnetmodelView result = db.aspnetmodellDbSet
                                     .Where(p => p.ModelPk == entityToAdd.ModelPk)
                                     .Select(itm => new aspnetmodelView()
            {
                ModelPk          = itm.ModelPk,
                ModelName        = itm.ModelName,
                ModelDescription = itm.ModelDescription
            }).FirstOrDefault();

            if (result == null)
            {
                return(NotFound());
            }
            return(Ok(result));
        }
Пример #2
0
        public IHttpActionResult deleteone([FromUri] System.Int32 modelPk
                                           )
        {
            aspnetmodelView result = db.aspnetmodellDbSet
                                     .Where(p => p.ModelPk == modelPk)
                                     .Select(itm => new aspnetmodelView()
            {
                ModelPk          = itm.ModelPk,
                ModelName        = itm.ModelName,
                ModelDescription = itm.ModelDescription
            }).FirstOrDefault();

            if (result == null)
            {
                return(NotFound());
            }

            aspnetmodel entityToDelete = db.aspnetmodellDbSet
                                         .Where(p => p.ModelPk == result.ModelPk)
                                         .FirstOrDefault();

            if (entityToDelete == null)
            {
                return(Ok(result));
            }
            db.aspnetmodellDbSet.Remove(entityToDelete);
            db.SaveChanges();
            return(Ok(result));
        }
Пример #3
0
        public IHttpActionResult updateone([FromBody] aspnetmodelView viewToUpdate)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }
            aspnetmodel resultEntity = db.aspnetmodellDbSet
                                       .Where(p => p.ModelPk == viewToUpdate.ModelPk)
                                       .FirstOrDefault();

            if (resultEntity == null)
            {
                return(NotFound());
            }

            resultEntity.ModelName        = viewToUpdate.ModelName;
            resultEntity.ModelDescription = viewToUpdate.ModelDescription;
            db.Entry(resultEntity).State  = EntityState.Modified;
            db.SaveChanges();
            aspnetmodelView result = db.aspnetmodellDbSet
                                     .Where(p => p.ModelPk == viewToUpdate.ModelPk)
                                     .Select(itm => new aspnetmodelView()
            {
                ModelPk          = itm.ModelPk,
                ModelName        = itm.ModelName,
                ModelDescription = itm.ModelDescription
            }).FirstOrDefault();

            if (result == null)
            {
                return(NotFound());
            }
            return(Ok(result));
        }