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