コード例 #1
0
        public IHttpActionResult getone([FromUri] System.String roleName
                                        )
        {
            aspnetrolemaskView result = db.aspnetrolemaskDbSet
                                        .Where(p => p.RoleName == roleName)
                                        .Select(itm => new aspnetrolemaskView()
            {
                RoleName        = itm.RoleName,
                RoleDescription = itm.RoleDescription,
                Mask0           = itm.Mask0,
                Mask1           = itm.Mask1,
                Mask2           = itm.Mask2,
                Mask3           = itm.Mask3,
                Mask4           = itm.Mask4,
                Mask5           = itm.Mask5,
                Mask6           = itm.Mask6,
                Mask7           = itm.Mask7,
                Mask8           = itm.Mask8,
                Mask9           = itm.Mask9,
                MaskA           = itm.MaskA,
                MaskB           = itm.MaskB,
                MaskC           = itm.MaskC,
                MaskD           = itm.MaskD,
                Dask0           = itm.Dask0,
                Dask1           = itm.Dask1,
                Dask2           = itm.Dask2
            }).FirstOrDefault();

            if (result == null)
            {
                return(NotFound());
            }
            return(Ok(result));
        } // the end of public GetOne()-method
コード例 #2
0
        public IHttpActionResult deleteone([FromUri] System.String roleName
                                           )
        {
            aspnetrolemaskView result = db.aspnetrolemaskDbSet
                                        .Where(p => p.RoleName == roleName)
                                        .Select(itm => new aspnetrolemaskView()
            {
                RoleName        = itm.RoleName,
                RoleDescription = itm.RoleDescription,
                Mask0           = itm.Mask0,
                Mask1           = itm.Mask1,
                Mask2           = itm.Mask2,
                Mask3           = itm.Mask3,
                Mask4           = itm.Mask4,
                Mask5           = itm.Mask5,
                Mask6           = itm.Mask6,
                Mask7           = itm.Mask7,
                Mask8           = itm.Mask8,
                Mask9           = itm.Mask9,
                MaskA           = itm.MaskA,
                MaskB           = itm.MaskB,
                MaskC           = itm.MaskC,
                MaskD           = itm.MaskD,
                Dask0           = itm.Dask0,
                Dask1           = itm.Dask1,
                Dask2           = itm.Dask2
            }).FirstOrDefault();

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

            aspnetrolemask entityToDelete = db.aspnetrolemaskDbSet
                                            .Where(p => p.RoleName == result.RoleName)
                                            .FirstOrDefault();

            if (entityToDelete == null)
            {
                return(Ok(result));
            }
            db.aspnetrolemaskDbSet.Remove(entityToDelete);
            db.SaveChanges();
            return(Ok(result));
        }
コード例 #3
0
        public IHttpActionResult addone([FromBody] aspnetrolemaskView viewToAdd)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }
            aspnetrolemask entityToAdd = new aspnetrolemask();

            entityToAdd.RoleName        = viewToAdd.RoleName;
            entityToAdd.RoleDescription = viewToAdd.RoleDescription;
            entityToAdd.Mask0           = viewToAdd.Mask0;
            entityToAdd.Mask1           = viewToAdd.Mask1;
            entityToAdd.Mask2           = viewToAdd.Mask2;
            entityToAdd.Mask3           = viewToAdd.Mask3;
            entityToAdd.Mask4           = viewToAdd.Mask4;
            entityToAdd.Mask5           = viewToAdd.Mask5;
            entityToAdd.Mask6           = viewToAdd.Mask6;
            entityToAdd.Mask7           = viewToAdd.Mask7;
            entityToAdd.Mask8           = viewToAdd.Mask8;
            entityToAdd.Mask9           = viewToAdd.Mask9;
            entityToAdd.MaskA           = viewToAdd.MaskA;
            entityToAdd.MaskB           = viewToAdd.MaskB;
            entityToAdd.MaskC           = viewToAdd.MaskC;
            entityToAdd.MaskD           = viewToAdd.MaskD;
            entityToAdd.Dask0           = viewToAdd.Dask0;
            entityToAdd.Dask1           = viewToAdd.Dask1;
            entityToAdd.Dask2           = viewToAdd.Dask2;
            db.aspnetrolemaskDbSet.Add(entityToAdd);
            db.SaveChanges();

            aspnetrolemaskView result = db.aspnetrolemaskDbSet
                                        .Where(p => p.RoleName == entityToAdd.RoleName)
                                        .Select(itm => new aspnetrolemaskView()
            {
                RoleName        = itm.RoleName,
                RoleDescription = itm.RoleDescription,
                Mask0           = itm.Mask0,
                Mask1           = itm.Mask1,
                Mask2           = itm.Mask2,
                Mask3           = itm.Mask3,
                Mask4           = itm.Mask4,
                Mask5           = itm.Mask5,
                Mask6           = itm.Mask6,
                Mask7           = itm.Mask7,
                Mask8           = itm.Mask8,
                Mask9           = itm.Mask9,
                MaskA           = itm.MaskA,
                MaskB           = itm.MaskB,
                MaskC           = itm.MaskC,
                MaskD           = itm.MaskD,
                Dask0           = itm.Dask0,
                Dask1           = itm.Dask1,
                Dask2           = itm.Dask2
            }).FirstOrDefault();

            if (result == null)
            {
                return(NotFound());
            }
            return(Ok(result));
        }
コード例 #4
0
        public IHttpActionResult updateone([FromBody] aspnetrolemaskView viewToUpdate)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }
            aspnetrolemask resultEntity = db.aspnetrolemaskDbSet
                                          .Where(p => p.RoleName == viewToUpdate.RoleName)
                                          .FirstOrDefault();

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

            resultEntity.RoleDescription = viewToUpdate.RoleDescription;
            resultEntity.Mask0           = viewToUpdate.Mask0;
            resultEntity.Mask1           = viewToUpdate.Mask1;
            resultEntity.Mask2           = viewToUpdate.Mask2;
            resultEntity.Mask3           = viewToUpdate.Mask3;
            resultEntity.Mask4           = viewToUpdate.Mask4;
            resultEntity.Mask5           = viewToUpdate.Mask5;
            resultEntity.Mask6           = viewToUpdate.Mask6;
            resultEntity.Mask7           = viewToUpdate.Mask7;
            resultEntity.Mask8           = viewToUpdate.Mask8;
            resultEntity.Mask9           = viewToUpdate.Mask9;
            resultEntity.MaskA           = viewToUpdate.MaskA;
            resultEntity.MaskB           = viewToUpdate.MaskB;
            resultEntity.MaskC           = viewToUpdate.MaskC;
            resultEntity.MaskD           = viewToUpdate.MaskD;
            resultEntity.Dask0           = viewToUpdate.Dask0;
            resultEntity.Dask1           = viewToUpdate.Dask1;
            resultEntity.Dask2           = viewToUpdate.Dask2;
            db.Entry(resultEntity).State = EntityState.Modified;
            db.SaveChanges();
            aspnetrolemaskView result = db.aspnetrolemaskDbSet
                                        .Where(p => p.RoleName == viewToUpdate.RoleName)
                                        .Select(itm => new aspnetrolemaskView()
            {
                RoleName        = itm.RoleName,
                RoleDescription = itm.RoleDescription,
                Mask0           = itm.Mask0,
                Mask1           = itm.Mask1,
                Mask2           = itm.Mask2,
                Mask3           = itm.Mask3,
                Mask4           = itm.Mask4,
                Mask5           = itm.Mask5,
                Mask6           = itm.Mask6,
                Mask7           = itm.Mask7,
                Mask8           = itm.Mask8,
                Mask9           = itm.Mask9,
                MaskA           = itm.MaskA,
                MaskB           = itm.MaskB,
                MaskC           = itm.MaskC,
                MaskD           = itm.MaskD,
                Dask0           = itm.Dask0,
                Dask1           = itm.Dask1,
                Dask2           = itm.Dask2
            }).FirstOrDefault();

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