public async Task <IActionResult> RemoveCustomMenu(CustomAccess customAccess) { int Result = await menu.RemoveAssignedCustom(customAccess); if (Result > 0) { return(Ok(Result)); } return(BadRequest()); }
public async Task <int> RemoveAssignedCustom(CustomAccess customAccess) { string query = @"DELETE FROM CustomAccess WHERE CustomId = @CustomId"; return(await db.SaveData(query, new { customAccess.CustomId })); }
public async Task <int> AssignedCustomMenu(CustomAccess customAccess) { string query = @"INSERT INTO CustomAccess OUTPUT inserted.CustomId VALUES (@UserId,@MenuId)"; return(await db.SaveDataReturnId(query, new { customAccess.UserId, customAccess.MenuId })); }