public dynamic update(GroupsUser entity) { using (ProductWithQRCodeDbContext db = new ProductWithQRCodeDbContext()) { return(db.Database.SqlQuery <ExecQueryResult>("exec TaiKhoan_update @maTaiKhoan, @tenTaiKhoan, @tinhTrang", new SqlParameter("@maTaiKhoan", entity.ID), new SqlParameter("@tenTaiKhoan", entity.Name), new SqlParameter("@tinhTrang", entity.Status)).Single()); } }
public async Task <ActionResult <Groups> > AddUser([FromBody] GroupsUser model) { var _userId = Convert.ToInt16(User.FindFirst("sub")?.Value); var groupsUser = new GroupsUser { GroupsId = model.GroupsId, UserId = _userId }; await _context.GroupsUser.AddAsync(groupsUser); var result = _context.SaveChangesAsync(); if (result.Result == 1) { return(Ok()); } return(BadRequest()); }
public async Task <ActionResult <Groups> > RemoveUser([FromBody] GroupsUser model) { var _userId = Convert.ToInt16(User.FindFirst("sub")?.Value); var groupsUser = new GroupsUser { GroupsId = model.GroupsId, UserId = _userId }; var connection = await _context.GroupsUser.Where(x => x.GroupsId == groupsUser.GroupsId && x.UserId == groupsUser.UserId).FirstAsync(); _context.GroupsUser.Remove(connection); var result = _context.SaveChangesAsync(); if (result.Result == 1) { return(Ok()); } return(BadRequest()); }