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