internal int UnassignRoles(UpdateRolesModal updateRolesModal) { int final = 1; try { using (var connection = new OleDbConnection(connString)) { connection.Open(); using (var cmd = new OleDbCommand()) { cmd.Connection = connection; cmd.CommandTimeout = 300; for (int i = 0; i < updateRolesModal.RolesDetailsList.Count; i++) { cmd.CommandText = "DELETE * FROM Users_Roles WHERE UserId ='" + updateRolesModal.UidNo + "' and RoleId = " + updateRolesModal.RolesDetailsList[i].RoleId + " and AccessType = '" + updateRolesModal.RolesDetailsList[i].AccessType + "'"; cmd.ExecuteNonQuery(); final = final + cmd.ExecuteNonQuery(); } } return(final); } } catch (Exception ex) { _logger.LogError($"$$$SaveActivityAttend$$$####Error Message ->>>{ex} && {ex.Message}###### + StackTrace {ex.StackTrace}######## + InnerEx{ex.InnerException}#####"); return(0); } }
public IActionResult AssignUnassignRoles(UpdateRolesModal updateRolesModal, string action) { var result = new RequestResult <bool>() { Data = _rolesManager.AssignUnassignRoles(updateRolesModal, action), Message = "Success", Success = true }; return(Ok(result)); }
public bool AssignUnassignRoles(UpdateRolesModal updateRolesModal, string action) { if (action.ToLower().Trim() == "add") { return(_userRolesDataAccess.AssignRoles(updateRolesModal, action)); } if (action.ToLower().Trim() == "delete") { return(_userRolesDataAccess.UnassignRoles(updateRolesModal, action)); } throw new CustomException("Invalid Action"); }
internal int AssignRoles(UpdateRolesModal updateRolesModal) { int final = 0; try { using (var connection = new OleDbConnection(connString)) { connection.Open(); using (var cmd = new OleDbCommand(@"Insert into Users_Roles (UserId, RoleId, AccessType) VALUES (@UserId, @RoleId, @AccessType)", connection)) { cmd.CommandTimeout = 300; for (int i = 0; i < updateRolesModal.RolesDetailsList.Count; i++) { cmd.Parameters.Clear(); cmd.Parameters.AddRange(new OleDbParameter[] { new OleDbParameter { ParameterName = "@UserId", Value = updateRolesModal.UidNo }, new OleDbParameter { ParameterName = "@RoleId", Value = updateRolesModal.RolesDetailsList[i].RoleId }, new OleDbParameter { ParameterName = "@AccessType", Value = updateRolesModal.RolesDetailsList[i].AccessType }, }); final = final + cmd.ExecuteNonQuery(); } } return(final); } } catch (Exception ex) { _logger.LogError($"$$$SaveActivityAttend$$$####Error Message ->>>{ex} && {ex.Message}###### + StackTrace {ex.StackTrace}######## + InnerEx{ex.InnerException}#####"); return(0); } }
internal bool AssignRoles(UpdateRolesModal updateRolesModal, string action) { return(_dbConnection.AssignRoles(updateRolesModal) > 0 ? true : false); }